Startup ...

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Startup ...

Gary Fay
I have a fedora core 3 system. I was able to start the
postgres server with the tool but I have no idea how
to create the databases. I am getting errors about my
user id and I should connect with the one that started
the server, but I used the tool, not a command.

(Stopping the server and using a command did not work
so well either.) Documentation was read but was found
wanting. (KISS) Google gave high level stuff but I
just want the basics, its running, who is defined to
access and or how do I start as the postgres user?

Gary


               
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs 
 

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: Startup ...

Bruno Wolff III
On Wed, Aug 17, 2005 at 18:36:55 -0700,
  Gary Fay <[hidden email]> wrote:
> I have a fedora core 3 system. I was able to start the
> postgres server with the tool but I have no idea how
> to create the databases. I am getting errors about my
> user id and I should connect with the one that started
> the server, but I used the tool, not a command.

If you had the server actually running, then you should be able to create
a database using the createdb command.

Probably you want to run createuser first to create a postgres user name
matching your normal account name that has the right to create databases.

When you run createuser you will want to use the -U command to run the command
as the postgres user 'postgres' (or whatever user ran initdb).

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match