I installed postgres to take a look at it and play with and learn. But I cant get it started. Heres what happens: bob@sfpetard:~> psql -h localhost template1 psql: FATAL 1: user "bob" does not exist How do I set up users etc for postgres? Help me get started. -- Bob Rea ************************************************** "On the side of the box, under 'System Requirements', it said 'Requires Windows 95 or better'. So I installed Linux." ************************************************** sfpetard@earthlink.net http://home.earthlink.net/~sfpetard/
On Thu, 14 Feb 2002, Bob Rea wrote:
I installed postgres to take a look at it and play with and learn.
But I cant get it started.
Heres what happens: bob@sfpetard:~> psql -h localhost template1 psql: FATAL 1: user "bob" does not exist
How do I set up users etc for postgres?
Help me get started.
-- Bob Rea
Hello You could try: psql -U postgres template1 but it might be a very good idea to create your own test database first. This you can do by createdb -U postgres test_name and then psql -U postgres test_name PostgreSQL is excellent, fast and robust database server. I've had it running in production environment for two years now and it's under constant update/query load for 16h per day - works like magic. --Jyry C:-( C:-/ C========8-O C8-/ C:-(
This book did a good job of getting me started: Beginning Databases with PostgtreSQL, ISBN 1-861005-15-6 ... Reed, alta@alta-research.com On Thursday 14 February 2002 12:10, you wrote:
I installed postgres to take a look at it and play with and learn.
But I cant get it started.
Heres what happens: bob@sfpetard:~> psql -h localhost template1 psql: FATAL 1: user "bob" does not exist
How do I set up users etc for postgres?
Help me get started.
-- Reed White - ALTA RESEARCH - www.alta-research.com Phone: 877-360-2582 - Email: alta@alta-research.com
participants (3)
-
alta
-
Bob Rea
-
Jyry Kuukkanen