Re: Post Install / Secure PostgreSQL

  On 09/15/10 10:36 AM, Carlos Mennens wrote:
> On Wed, Sep 15, 2010 at 1:34 PM, John R Pierce<pierce@hogranch.com>  wrote:
>> no, there is no such state in postgres.  you connect and log into a
>> database.  connecting to a different database requires closing that
>> connection and opening a new one (which is what the \c command does in
>> psql).
> Thanks but then I am confused why I am getting the following:
>
> postgres=# \d
> No relations found.
> postgres=# \dt
> No relations found.
> postgres=# \c postgres
> psql (8.4.4)
> You are now connected to database "postgres".
> postgres=# \dt
> No relations found.
> postgres=# \d
>

the 'postgres' database on your system is empty.   this is quite
typical, as that database is simply a convenience for the postgres user
to have something to log into while doing his administrative duties.