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…
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…
Below is the command to use when you would like to dump only the data from a postgreSQL table. There are other options to use to dump the schema, multiple tables, exclude certain tables, or backup the entire database but these command line switches will dump only the data from one postgreSQL table. In the below…
Backing up and restoring PostgreSQL is fairly easy using pg_dump and psql. One more complicated scenario I have run into is doing a complete database backup with pg_dump and at some point down the road needing to just split out one table and restore it. This can be a pain because of how the pg_dump…
It is not stated clearly on pgAdmin’s site if it will operate on Windows Vista without issue so I decided to download, install and see if there were any issues. First I visited pgAdmin III Windows download page here. On this page it states that pgAdmin III will work with Windows 2000, Windows XP, and…
pgAdmin is a great GUI tool to use for managing PostgreSQL databases and can be obtained here. pgAdmin will run on Windows, Linux(CentOS, SUSE, Debian, etc.), Solaris, FreeBSD, or Mac OSX. After upgrading pgAdmin I was getting an error using the backup feature. The specific error is pasted below.