backing up database

Started by Tyler Woodover 25 years ago2 messagesgeneral
Jump to latest
#1Tyler Wood
electric_pancake@yahoo.com

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/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tyler Wood (#1)
Re: backing up database

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