createdb

Hi,

I got it up and running with:

[root@localhost init.d]# ./postgresql start
Initializing database:                                     [  OK  ]
Starting postgresql service:                               [  OK  ]

But now I want to create a database, but I cannot do this with the root
user. What is the best way to do this?

I tried with user postgresql but what password to use?

createdb --username=postgresql mydb

Thanks in advance.

Best regards,
Bart

> On Fri, Jan 09, 2004 at 22:39:09 +0100,
>   bartvde@xs4all.nl wrote:
>> Hi list,
>>
>> I just downloaded the source from PostgreSQL 7.4.1 and installed it on
>> Red
>> Hat 9. Install was succesfull. After this I installed PostGIS 0.8.0.
>>
>> To test the PostGIS install I need the perform the following command:
>>
>> createlang plpgsql postgistest
>>
>> But on performing this I get the following error:
>>
>> psql: could not connect to server: No such file or directory
>>         Is the server running locally and accepting
>>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>> createlang: external error
>>
>> Anybody have an idea what could be the problem?
>
> Most likely the server isn't running.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>