Re: FreeBSD 7.1 Release, Postgres v8.3.7 and confusion on a howto

On Wed, Aug 5, 2009 at 12:56, Stephan Szabo<sszabo(at)megazone(dot)bigpanda(dot)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