Thread: backing up database
I'm in the /usr/local/pgsql directory, as pgsql: [pgsql@host pgsql]$ whoami pgsql and it doesn't seem to work when i try to backup the database. this is what i type: [pgsql@host pgsql]$ pg_dump foodserver > foodserver_7_13_2000.pgdump and this is the error I get: getInherits(): SELECT failed anybody know something I'm doing wrong? Tyler Wood twood@uwm.edu __________________________________________________ Do You Yahoo!? Get Yahoo! Mail � Free email you can access from anywhere! http://mail.yahoo.com/
Tyler Wood <electric_pancake@yahoo.com> writes: > getInherits(): SELECT failed I don't think you've given us the whole error message --- but I'm going to venture a wild guess that you're running a 6.5 pg_dump against a 7.0 database or vice versa. Check your PATH. regards, tom lane