Skip to content
Question Defense
Technical answers for technical questions
Question Defense
  • Backtrack Linux
    • Backtrack Article Request
  • HTTP ERROR
  • Kali Linux
    • Kali Linux Article Request
  • Privacy Policy
  • Tools
    • Class Of Device – Bluetooth CoD List In Binary And Hex
    • phpMyAdmin Blowfish Secret Generator
  • Documentation
    • check_postgres.pl
    • Linux Man Pages
      • insmod
      • kill
      • Logrotate
      • ls
      • lsmod
      • mail
      • modprobe
      • more
      • mysqldump
      • ntfsprogs
      • ntfsresize
      • pg_dump
      • psql
      • rmmod
      • screen
    • Monarch
      • Monarch Commands
      • Monarch Control
      • Monarch Escalations
      • Monarch Groups
      • Monarch Management of Nagios Hosts
      • Monarch Managing Nagios Contacts
      • Monarch Managing Nagios Hosts
      • Monarch Profiles
      • Monarch Services Template
      • Monarch Time Periods
      • Monarch Tools
  • Tags
  • Contact
Linkedin page opens in new windowTwitter page opens in new window
Search:
Search
  • Backtrack Linux
    • Backtrack Article Request
  • HTTP ERROR
  • Kali Linux
    • Kali Linux Article Request
  • Privacy Policy
  • Tools
    • Class Of Device – Bluetooth CoD List In Binary And Hex
    • phpMyAdmin Blowfish Secret Generator
  • Documentation
    • check_postgres.pl
    • Linux Man Pages
      • insmod
      • kill
      • Logrotate
      • ls
      • lsmod
      • mail
      • modprobe
      • more
      • mysqldump
      • ntfsprogs
      • ntfsresize
      • pg_dump
      • psql
      • rmmod
      • screen
    • Monarch
      • Monarch Commands
      • Monarch Control
      • Monarch Escalations
      • Monarch Groups
      • Monarch Management of Nagios Hosts
      • Monarch Managing Nagios Contacts
      • Monarch Managing Nagios Hosts
      • Monarch Profiles
      • Monarch Services Template
      • Monarch Time Periods
      • Monarch Tools
  • Tags
  • Contact

Tag Archives: pg_dump

You are here:
  1. Home
  2. Entries tagged with "pg_dump"

Technology Insights

Dump a PostgreSQL Database Without the Data

InsightsBy alexMarch 1, 2009Leave a comment

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…

Technology Errors

ERROR: syntax error at or near “COLLATE”

ErrorsBy alexFebruary 24, 2009Leave a comment

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…

Technology Insights

Backup and Restore a Postgres Database Using pg_dump and psql

InsightsBy alexJanuary 31, 20091 Comment

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…

Technology Insights

How to Dump the Data From One PostgreSQL Table

InsightsBy alexJanuary 9, 200913 Comments

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…

Technology Insights

Restore One Table with psql from a pg_dump PostgreSQL Backup

InsightsBy alexNovember 13, 20089 Comments

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…

Technology Insights

Does pgAdmin III Install and Run on Windows Vista

InsightsBy alexNovember 1, 2008Leave a comment

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…

Technology Errors

pgAdmin: pg_dump: aborting because of version mismatch

ErrorsBy alexSeptember 4, 20086 Comments

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.

Question Defense
© 2021 question-defense.com
Go to Top