Postgresql Index Page 1

How to change postgresql database encoding to UTF8 from SQL_ASCII

In this tutorial, we explain how to change the encoding of a database in PostgreSQL. Use sudo -u postgres psql -C “SHOW SERVER_ENCODING” your_database to display the database encoding. You can create a new database with utf8 using the command: sudo -u postgres createdb -E utf8 your_database. If you already have a database with SQL_ASCII and you want to convert it to utf8 you will need to regenerate it, check here for the full guide.

Postgresql Index Page 1

Ubuntu upgrade postgres to version 10

In this tutorial we are going to upgrade PostgreSQL 9.X to 10. The following steps will work for Ubuntu 14.04, 17.04 and 16.04. Check our guide for easy upgrade with some troubleshooting also.

Postgresql Index Page 1

Moving PostgreSQL data directory to a new path

Sometimes you need to change the data directory of postgresql when adding disks, changing to a RAID of disks. In this tutorial we explain the steps to change data directrory.