On Wed, Aug 5, 2009 at 12:56, Stephan Szabo<sszabo@megazone.bigpanda.com> wrote:
> On Wed, 5 Aug 2009, Kurt Buff wrote:
>
>> All,
>>
>> I'm following this howto:
>> http://www.howtoforge.com/virtual_hosting_vsftpd_postgresql_freebsd
>>
>> and can't get past setting up the database.
>>
>> I've installed postgres, and it starts successfully after an initdb
>> [1], but I come to a full stop after the following commands:
>>
>> it-kbuff-fbsd# su - pgsql
>> $ psql system
>> psql: FATAL: database "system" does not exist
>>
>> Huh? Is it a problem with the howto, or a mismatch between the howto
>> and version of postgres I'm using, or am I performing a newb stunt?
>
> Actually, I'm not seeing anything in the howto that actually creates the
> database they have you trying to connect to. Perhaps doing a
> createdb system
> after the su but before the psql?
I've changed the config files from 'system' to 'template1', and that
seems to be working just fine.
Kurt