By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 644 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

ERROR: Relation "pg_user" does not exist

P: n/a
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 : sa**@soton.ac.uk
University of Southampton
HANTS SO17 1BJ http://www.combechem.org/
************************************************** ********

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
"S.Peppe" <S.*****@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 7: don't forget to increase your free space map settings

Nov 11 '05 #2

P: n/a
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.*****@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

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.