Upgrading walmgr.py is easy since really this is just a python script. The most complicated part of the upgrade process will be keeping your database cluster up. Follow the below steps and you should avoid any downtime. Download Latest SkyTools: Visit PgFoundry to download the latest SkyTools. Issue the below command from /usr/local/src on each…
I ran into a silly error tonight during some configuration changes for PostgreSQL that took me awhile to figure out so I wanted to share so it might save others some time in the future. In an attempt to boot the slave server in a PostgreSQL SkyTools walmgr configuration I was unable to get it…
You might receive the below error in your postgresql.log file after issuing the walmgr.py syncdaemon command as explained below. Error: CDTFATAL: role “root” does not exist Command Issued: bash walmgr.py conf/wal-master.ini syncdaemon -d
Dumping a PostgreSQL database without the data is easy. Issue the below command and it will output the database table structure to a text file that can easily be imported. bash pg_dump -U postgres –schema-only DBNAME -f FILENAME.sql The above can be imported into a new database using the below syntax. psql -U postgres DBNAME…
You may get the following error when attempting to restore a postgreSQL database. The issue will be that you are attemping to restore a dump of a database using PostgreSQL version 8.4 and anove into a PostgreSQL database that is version 8.3 or below. ERROR: syntax error at or near “COLLATE” To resolve this issue manually edit…
Recently I was troubleshooting an issue with a Peprl script that is used to backup and then restore a PostgreSQL database every night. The script creates a database, moves the current database, and then moves the new database it created into the place of the first database. I noticed that the restore database was not…
Keeping PostgreSQL updated via yum should be done via the pgdg yum repository supplied by pgsqlrpms.org. The latest CentOS PostgreSQL repo can be viewed here. You will need to download the repo and then install using rpm as shown below. bash wget http://yum.pgsqlrpms.org/reporpms/8.4/pgdg-centos-8.4-1.noarch.rpm rpm -Uhv pgdg-centos-8.4-1.noarch.rpm Another helpful postgresql install and management link is located…
Backing up and restoring a postgreSQL database is easy from the CLI. Some people prefer using pgAdmin III however through the GUI and over a network will use a lot more resources so it is recommended to backup and restore via your Linux CLI. Follow the simple steps below to backup and restore one Postgres…
Easily create or drop a database via the psql CLI using the below syntax. Create a PostgreSQL Database: Just modify the database_name to the name you prefer for your new database. bash create database database_name