postgreSQL problem: Relation "pg_user" does not exist

Noerr · 06-03-2002, 06:09 AM

I have installed it on 3 different redhat 7.2 machines and always get the same thing.

Any help would be very welcome

MartBrooks · 06-03-2002, 06:16 AM

Is this from the RPM or from the source?

Noerr · 06-03-2002, 07:14 AM

from rpm

MartBrooks · 06-03-2002, 07:32 AM

Did you run initdb?

Noerr · 06-03-2002, 08:29 AM

initdb ran fine, no problems detected
and my dir is also ok
its
/var/lib/postgres
and I have data in dir /data

MartBrooks · 06-03-2002, 08:42 AM

Try "createdb -U postmaster test"

Noerr · 06-03-2002, 09:25 AM

[postgres@bs2 postgres]$ createdb -U postgres test1
CREATE DATABASE
[postgres@bs2 postgres]$ psql test1
ERROR: Relation "pg_user" does not exist
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

test1=> \l
ERROR: Relation "pg_user" does not exist
ERROR: Relation "pg_user" does not exist

MartBrooks · 06-03-2002, 09:47 AM

Ghm, that doesn't look promising. If I were you I'd grab the latest source tarball and try and install from that.

Regards

Noerr · 06-03-2002, 09:49 AM

test1=> CREATE TABLE cities1 ( name varchar(80), location point);
CREATE
test1=> \l
ERROR: Relation "pg_user" does not exist
ERROR: Relation "pg_user" does not exist
test1=> INSERT INTO cities VALUES ('San Francisco', '(-194.0, 53.0)');
INSERT 24659 1
test1=>SELECT * FROM cities;
name | location
---------------+-----------
San Francisco | (-194,53)
(1 row)

test1=>

the problem is that I can't connect to it with odbc driver

MartBrooks · 06-03-2002, 09:55 AM

Then I've no idea. Sorry

Noerr · 06-03-2002, 10:01 AM

I think that there are come config files missing.
How does pq_user suppose to look like. I have modified pg_hba.conf to allow connections from different computers, but keep getting messages
my hba_conf
#local all ident sameuser
local all trust
host all 192.168.0.0 255.255.0.0 trust

The problem is that I have tried to set it up on different machines and always getting same error.

I'll try to compile it also, but I think I have done that too