Hi, I am relatively new to Linux and just installed postgres via rpms.
I think. However, I can't for the life of me figure out how to start up
postmaster or psql.
psql - I keep getting the following error when running psql...
"psql: could not connect to server: No such file or directory
Great! I very much appreciate your help. I'm unclear on what I need to
set PGDATA or the -D option with in order to run postmaster. Any idea?
Here is what I'm trying and the errors given...
$ postmaster
"postmaster does not know where to find the database system data.
You must specify the dir
Eric M. Wulff wrote:
Great! I very much appreciate your help. I'm unclear on what I need to
set PGDATA or the -D option with in order to run postmaster. Any idea?
The line you need with postmaster should be like :
postmaster -i -D /PATH/WHERE/FIND/DATA/FILES -S
The /PATH/WHERE/FIND/DATA/FILE
This is very helpful. My next problem is setting up a db. createdb fails...
"psql: FATAL: user "blah" does not exist
createdb: database creation failed"
The user is either myself or root. Of course, doesn't like root. How
do I get psql to recognize me as a user.
fyi - I'm on redhat 8.0.
On Sat, 2003-10-18 at 22:15, Eric M. Wulff wrote:
> This is very helpful. My next problem is setting up a db. createdb fails...
>
> "psql: FATAL: user "blah" does not exist
> createdb: database creation failed"
>
> The user is either myself or root. Of course, doesn't like root. How
> do I
