postgreSQL problem: Relation "pg_user" does not exist
 

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

Any help would be very welcome

:confused:

Is this from the RPM or from the source?

from rpm

Did you run initdb?

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

Try "createdb -U postmaster test"

[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

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

Regards

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

Then I've no idea. Sorry :(

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