psql test error

Hey there,

New to this forum, looks like good place to ask this;

Want to run PostgreSQL on my Mandrake 7.0 Linux box to learn it. Created login account of postgres. When I try this command to get the database going I get this error;
# psql test
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
createuser: creation of user "tester1" failed

Any idea what I can do to fix this? I'd really like to learn this database (already been using MySQL). Thanks.

The answer was in this post http://forums.devshed.com/showthrea...6743&forumid=21 just 3 posts away from yours.
If it doesn't fit, then feel free to ask.

Hi, thanks for the info, but no, I still get the same error. I tried both the PGOPTS="" (there was no commented version but I tried adding this anyway) and -i 5432 to both the
postmaster.opts.default and postmaster.opts.

Any other suggestions?

Did you restart Postgresql, in order to make it read the new configuration?

If you mean logging out of the postgres account, going back in and starting # psql test, yes I did.

No, I mean restarting the whole postgresql server.

Just so I'm sure what you mean, do you want me to reboot the linux PC that has PostgreSQL on it? Or is there a way to do it while leaving the machine running?

You can do it without rebooting, but I don't remember the command (kill or pgsql -start ???) take a look at www.postgresql.org , under the Users area there is a searchable documentation with users comments, please add your too, it could be useful to others.
Regards

Well, here is the solution for you:

pg_ctl -- Starts, stops, or restarts postmaster

pg_ctl start [-w] [-D datadir] [-l filename] [-o options] [-p path]

pg_ctl stop [-W] [-D datadir] [-m s[mart] | f[ast] | i[mmediate] ]

pg_ctl restart [-w] [-D datadir] [-m s[mart] | f[ast] | i[mmediate] ] [-o options]

pg_ctl status [-D datadir]

Taken from the manual