Skip to content

Long's blog

Góp nhặt của một kẻ mù công nghệ :p

  • My Info
    • Đỗ Thành Long’s CV
    • My Github
    • My Youtube
    • My Google Scholar
    • My Facebook
  • Café
    • soiqualang_chentreu
    • Trắng Xóa!
    • Capuchino
    • Robusta Café
    • Đen nóng Café
  • Dev
    • Web
    • Công nghệ
    • Uncategorized
  • GIS
    • Shared Map
    • QGIS
    • WebGIS
    • PostgreSQL, PostGIS
    • GeoServer
    • Openlayers
  • Viễn thám
  • Research
    • Ý tưởng
    • Research
    • Sói’s Tutorials
  • Tài liệu
    • GIS – Remote Sensing news
    • Tài liệu
    • Dữ liệu
    • Mẹo vặt
  • My Apps
    • Khoa học thường thức
    • Trắng Xóa – Danh ngôn
    • Harmonica tabs
    • Ảnh chế hài hước, dzui dzui
    • GeoGIS
    • Guitar tabs – Viettabs
    • 2000 Phác đồ điều trị bệnh
    • Q2A
    • Học HTML
    • Openlayers Cookbook
    • OpenLayers3 Leaflte Cookbook
    • OpenLayers Create Code
    • PostgreSQL Tools
    • Get link Remote Sensing Data
    • Lon,Lat Decimal
    • Download Landsat Images
    • Tra cứu vận đơn Viettel Post
    • GET Map OGC WMS, WFS, WCS services
    • PHP-SLD Generate
    • Viettabs.cf – Guitar tabs sharing
    • Files to Videos
  • Other
    • Reading
    • Games
    • Harvest Moon

Tag: postgresql

Docker Backup, Restore PostgreSQL Database

Posted on 03/11/2022 by soiqualang_chentreu Posted in Công nghệ, Lang thang, Linux, Mẹo vặt Tagged backup, database, Docker, postgresql, RestoreLeave a Comment on Docker Backup, Restore PostgreSQL Database

Docker Backup, Restore PostgreSQL Database Single Database PostgreSQL Backup Single Database sudo docker exec -t –user pg_username pg_container_name pg_dump -c -p 5432 -U pg_username "database_name" > "/path/on/your/machine/dump.sql" PostgreSQL Restore Single Database sudo docker exec -t –user pg_username pg_container_name psql -c […]

Read More

[PostgreSQL Linux] Remove installed PostgreSQL in opt dir

Posted on 19/09/202219/09/2022 by soiqualang_chentreu Posted in Lang thang, Linux Tagged Database Engines, postgresqlLeave a Comment on [PostgreSQL Linux] Remove installed PostgreSQL in opt dir

[PostgreSQL Linux] Remove installed PostgreSQL in opt dir I installed PostgreSQL through the installation file, so the installation directory is /opt/PostgreSQL/10 I tried sudo apt-get –purge remove postgresql* but this did not work for me. In my case uninstaller was […]

Read More

PostgreSQL Add User

Posted on 18/09/2022 by soiqualang_chentreu Posted in Lang thang, Mẹo vặt Tagged database, postgresqlLeave a Comment on PostgreSQL Add User

PostgreSQL Add User CREATE USER user_name WITH PASSWORD 'user_password'; GRANT ALL PRIVILEGES ON DATABASE "database_name" to user_name; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user_name; -soiqualang_chentreu-

Read More

[PostgreSQL] Create a database from an exist database

Posted on 10/09/202210/09/2022 by soiqualang_chentreu Posted in Lang thang, Sói's Tutorials Tagged postgresqlLeave a Comment on [PostgreSQL] Create a database from an exist database

[PostgreSQL] Create a database from an exist database Create a database Postgres allows the use of any existing database on the server as a template when creating a new database. I’m not sure whether pgAdmin gives you the option on […]

Read More

PostgreSQL – Function to remove accents in string

Posted on 04/09/2022 by soiqualang_chentreu Posted in Lang thang, Mẹo vặt, Sói's Tutorials Tagged accents, postgresqlLeave a Comment on PostgreSQL – Function to remove accents in string

PostgreSQL – Function to remove accents in string Loại bỏ dấu câu, chuyển câu có dấu thành không dấu trong PostgreSQL Ex: José, Jose, Jósé, Jóse -> Jose Load extension unaccent CREATE EXTENSION unaccent; Run SQL to remove accents in […]

Read More

PostgreSQL update value in JSONB

Posted on 07/07/2022 by soiqualang_chentreu Posted in Mẹo vặt, Sói's Tutorials Tagged database, jsonb, postgresql, sqlLeave a Comment on PostgreSQL update value in JSONB

PostgreSQL update value in JSONB Tình cờ mình làm việc, cần update lại giá trị một key trong cột có kiểu là jsonb, thế là mình nghĩ json thì cũng là text thôi, replace là được, và đây là cách […]

Read More

Fix OGR2OGR Import – invalid byte sequence for encoding UTF8

Posted on 09/04/2022 by soiqualang_chentreu Posted in GIS, Mẹo vặt Tagged OGR2OGR, postgresql, Shapefile, Shapefile to PostgreSQLLeave a Comment on Fix OGR2OGR Import – invalid byte sequence for encoding UTF8

Fix OGR2OGR Import – invalid byte sequence for encoding UTF8 Error showing When I use OGR2OGR to import Shapeilfe to PostgreSQL, I got error like this: invalid byte sequence for encoding "UTF8": 0xe2 0x6e 0x20 How to fix invalid byte […]

Read More

Force Drop Database PostgreSQL

Posted on 17/03/2022 by soiqualang_chentreu Posted in Mẹo vặt Tagged database, postgresqlLeave a Comment on Force Drop Database PostgreSQL

Force Drop Database PostgreSQL — Check current activity sessions SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'nongnghiepdongnai'; — Drop DB DROP DATABASE nongnghiepdongnai;

Read More

Xếp hạng các Database Engines theo mức độ phổ biến (tháng 3/2022)

Posted on 15/03/2022 by soiqualang_chentreu Posted in Công nghệ, Lang thang Tagged database, Database Engines, mysql, postgresql, sql serverLeave a Comment on Xếp hạng các Database Engines theo mức độ phổ biến (tháng 3/2022)

Xếp hạng các Database Engines theo mức độ phổ biến (tháng 3/2022) Nguồn: https://db-engines.com/en/ranking Điều thú vị mình thấy là riêng trong lĩnh vực các Database Engines thì các phần mềm mã nguồn mỡ cũng không hề kém cạnh các […]

Read More

PostgreSQL for IoT (The Internet Of Strange Things)

Posted on 14/03/2022 by soiqualang_chentreu Posted in Công nghệ, GIS, Lang thang, Tài liệu Tagged IoT, postgresqlLeave a Comment on PostgreSQL for IoT (The Internet Of Strange Things)

PostgreSQL for IoT (The Internet Of Strange Things)

Read More

[Sưu tầm] Introduction To PostgreSQL As A Time Series Database For IoT

Posted on 14/03/202215/03/2022 by soiqualang_chentreu Posted in Công nghệ, Lang thang Tagged database, IoT, postgresql, Time Series DatabaseLeave a Comment on [Sưu tầm] Introduction To PostgreSQL As A Time Series Database For IoT

Introduction To PostgreSQL As A Time Series Database For IoT Nguồn: https://www.c-sharpcorner.com/article/introduction-to-postgresql-as-a-time-series-database-for-iot/ A time-series database is a database system that is designed to store and load data over time through associated pairs of times and values. Time Series databases were initially […]

Read More

PostgreSQL force rename database

Posted on 10/03/2022 by soiqualang_chentreu Posted in Mẹo vặt, Web Tagged database, postgresqlLeave a Comment on PostgreSQL force rename database

PostgreSQL force rename database PostgreSQL ép đổi tên Database — Tắt hết connect đến DB SELECT pg_terminate_backend (pid) FROM pg_stat_activity WHERE datname = 'nongnghiepdongnai2'; — Đổi tên DB ALTER DATABASE nongnghiepdongnai2 RENAME TO nongnghiepdongnai; https://www.geeksforgeeks.org/postgresql-rename-database/

Read More

Fix Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above

Posted on 16/12/202116/12/2021 by soiqualang_chentreu Posted in Công nghệ, GIS, Mẹo vặt Tagged authentication, postgresql, SCRAMLeave a Comment on Fix Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above

Read More

Postgres convert empty string to NULL

Posted on 22/10/2021 by soiqualang_chentreu Posted in Công nghệ, Lang thang, Mẹo vặt Tagged database, empty string, NULL, postgresql, sqlLeave a Comment on Postgres convert empty string to NULL

Read More

PostgreSQL Window – Tạo Password File để dùng pg_dump

Posted on 12/10/2021 by soiqualang_chentreu Posted in Công nghệ, Dữ liệu, GIS, Mẹo vặt, Sói's Tutorials, Web Tagged database, pg_dump, pgpass.conf, postgresqlLeave a Comment on PostgreSQL Window – Tạo Password File để dùng pg_dump

Read More

Posts navigation

Older posts
Buy me a coffee - MOMO

Tags

Android Android studio api App Bundle ArcGIS Capacitor cloudflare database Docker gdal geoserver gis git github Google Earth Engine guitar htaccess Ionic IOS javascript JS GIS Jupyter Notebook leaflet Linux Machine learning map MapServer mysql Nodejs openlayers php Pokemon postgis postgresql python QGIS raster remote sensing sql tools ubuntu viettabs.cf viễn thám webgis wordpress

Recent Posts

  • IONIC Error: Unknown argument: platform
  • QGIS OpenDay November 2022
  • AI tự động sinh JD tuyển dụng
  • [JS GIS] JavaScript GIS Simplify | GeoToolbox
  • [JS GIS] JavaScript GIS Dissolve | GeoToolbox

Recent Comments

  • soiqualang_chentreu on Hướng dẫn đăng ký Google Developer – Upload app to Google Play
  • Huan on Hướng dẫn đăng ký Google Developer – Upload app to Google Play
  • afagh on Sentinel 2 Atmospheric Correction in Google Earth Engine
  • afagh on Sentinel 2 Atmospheric Correction in Google Earth Engine
  • soiqualang_chentreu on Sentinel 2 Atmospheric Correction in Google Earth Engine

Categories

  • Capuchino
  • Công nghệ
  • Dữ liệu
  • GIS
  • Google Earth Engine
  • Lang thang
  • Linux
  • Mẹo vặt
  • QGIS Tutorials and Tips
  • Research
  • Sói's Tutorials
  • Tài liệu
  • Uncategorized
  • Viễn thám
  • Web
  • WebGIS
  • Ý tưởng

Archives

  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • January 2021
  • December 2020
  • November 2020
  • September 2020
  • August 2020
  • August 2019
  • July 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • October 2017
  • September 2017
  • August 2017
  • June 2017
  • May 2017
  • April 2017

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright 2022. All rights reserved.


Back To Top