| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Post Install / Secure PostgreSQL |
| Date: | 2010-09-15 17:43:12 |
| Message-ID: | 4C9105B0.9060500@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/15/10 10:36 AM, Carlos Mennens wrote:
> On Wed, Sep 15, 2010 at 1:34 PM, John R Pierce<pierce(at)hogranch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wilson | 2010-09-15 17:44:24 | Re: Post Install / Secure PostgreSQL |
| Previous Message | Carlos Mennens | 2010-09-15 17:36:26 | Re: Post Install / Secure PostgreSQL |