Thread: ERROR: Relation "pg_user" does not exist
Hi there! I'm really new at this game, so please forgive me if my request is at all irritating. I have installed PostgreSQL onto a Debian/Linux machine, and I have just upgraded PostgreSQL via the apt-get update & upgrade commands. However, whenever I get into the PostgreSQL interactive terminal thus sp@vanthoff:~$ psql -U postgres SHG it returns this: ERROR: Relation "pg_user" does not exist Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit Now, if I try to connect to the database SHG: SHG=> \c SHG it returns this: You are now connected to database SHG. ERROR: Relation "pg_user" does not exist These errors are encountered even when I'm logged on as root. I'm not sure what other information you would require from me to answer this question, so please do not hesitate to ask for it. Has anyone ever come across this problem, and if so, how was it resolved? Many thanks in advance. Regards, Sam. -- ********************************************************** Sam Peppe Tel : +44 (0)23 8059 3587 Postdoctoral Research Fellow Fax : +44 (0)23 8059 3781 Department of Chemistry Email : samp@soton.ac.uk University of Southampton HANTS SO17 1BJ http://www.combechem.org/ **********************************************************
"S.Peppe" <S.Peppe@soton.ac.uk> writes: > it returns this: > ERROR: Relation "pg_user" does not exist Uh ... how old is the server you're connecting to, exactly? The pg_user view has been standard for awhile, I can't blame your psql for assuming it exists ... regards, tom lane
Thanks for your reply, Tom. The server I'm connecting to is only about 3 months old - that shouldn't be the problem then, as far as I can tell. Thanks again. Regards, Sam. On Wed, 2 Jul 2003, Tom Lane wrote: > "S.Peppe" <S.Peppe@soton.ac.uk> writes: > > it returns this: > > ERROR: Relation "pg_user" does not exist > > Uh ... how old is the server you're connecting to, exactly? > > The pg_user view has been standard for awhile, I can't blame your > psql for assuming it exists ... > > regards, tom lane
What he meant was what VERSION of postgresql is the server using. :-) On Wed, 2 Jul 2003, S.Peppe wrote: > Thanks for your reply, Tom. The server I'm connecting to is only about 3 > months old - that shouldn't be the problem then, as far as I can > tell. Thanks again. > > Regards, > > Sam. > > On Wed, 2 Jul 2003, Tom Lane wrote: > > > "S.Peppe" <S.Peppe@soton.ac.uk> writes: > > > it returns this: > > > ERROR: Relation "pg_user" does not exist > > > > Uh ... how old is the server you're connecting to, exactly? > > > > The pg_user view has been standard for awhile, I can't blame your > > psql for assuming it exists ... > > > > regards, tom lane > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >
Tom Lane wrote: > "S.Peppe" <S.Peppe@soton.ac.uk> writes: >> it returns this: >> ERROR: Relation "pg_user" does not exist > > Uh ... how old is the server you're connecting to, exactly? > > The pg_user view has been standard for awhile, I can't blame your > psql for assuming it exists ... Before pg_user became a view, pg_shadow *was* pg_user ... and that dates back to ... um ... it was there in 4.2 already ... Anyway, that can't be the source of the problem. Jan > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #