Error when trying to backup Postgres database

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Re: Error when trying to backup Postgres database

Postby ptrack pat » Thu Oct 08, 2009 5:31 pm

Well, it's not going to matter anyway because I can't see any way to add a column to a system table. I figured you would be able to do this but adding a column is not an option for system tables and I tried to do it via a SQL statement and it doesn't like that either. I don't know what that column does or why it's missing. Can you check on the other computer that you did the backup from and see if that field is in that table?

Another option is to try to do the backup directly from pgAdminIII and see if that gives any different results. Failing that, backing up the entire c:\program files\postgresql\8.3\data folder would also provide a backup except it wouldn't be just a single compressed file containing the backup but rather that entire folder...and sub-folders.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Previous

Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron