LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 06-03-2002, 06:09 AM   #1
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Rep: Reputation: 30
Question 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

 
Old 06-03-2002, 06:16 AM   #2
MartBrooks
Member
 
Registered: May 2002
Location: London
Distribution: Debian
Posts: 388

Rep: Reputation: 31
Is this from the RPM or from the source?
 
Old 06-03-2002, 07:14 AM   #3
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
from rpm
 
Old 06-03-2002, 07:32 AM   #4
MartBrooks
Member
 
Registered: May 2002
Location: London
Distribution: Debian
Posts: 388

Rep: Reputation: 31
Did you run initdb?
 
Old 06-03-2002, 08:29 AM   #5
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
initdb ran fine, no problems detected
and my dir is also ok
its
/var/lib/postgres
and I have data in dir /data
 
Old 06-03-2002, 08:42 AM   #6
MartBrooks
Member
 
Registered: May 2002
Location: London
Distribution: Debian
Posts: 388

Rep: Reputation: 31
Try "createdb -U postmaster test"
 
Old 06-03-2002, 09:25 AM   #7
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
[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
 
Old 06-03-2002, 09:47 AM   #8
MartBrooks
Member
 
Registered: May 2002
Location: London
Distribution: Debian
Posts: 388

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

Regards
 
Old 06-03-2002, 09:49 AM   #9
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
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
 
Old 06-03-2002, 09:55 AM   #10
MartBrooks
Member
 
Registered: May 2002
Location: London
Distribution: Debian
Posts: 388

Rep: Reputation: 31
Then I've no idea. Sorry
 
Old 06-03-2002, 10:01 AM   #11
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
what can i do with this promt"user machbuild does not exist - using root" wucheng Linux - Newbie 2 01-17-2011 07:41 AM
Postgresql error FATAL: user "root" does not exist" cgetty Ubuntu 4 06-21-2005 02:11 PM
"computers that are thousands of times more powerful than those that exist today." rksprst General 12 02-03-2005 07:25 PM
invalid binary "/usr/bin/postgres" while running postgresql ukrainet Linux - Newbie 1 12-01-2004 08:36 AM
RH9 NIS login error: "home directory does not exist" airrr Linux - Networking 2 08-06-2003 01:47 PM


All times are GMT -5. The time now is 11:20 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration