Re: psql -l bug

From: Olivier PRENANT <ohp(at)pyrenet(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: psql -l bug
Date: 2001-01-10 18:55:10
Message-ID: Pine.UW2.4.21.0101101953040.4812-100000@server.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sorry to folowup on my own post....

Problem solved: real and test db don't run on the same machine.

On the test one, postgres had the same uid as pg_shadow.usesysid for the
user...

Sorry to have bothered you all.

Reagrds
On Wed, 10 Jan 2001, Olivier PRENANT wrote:

> Hi,
>
> I just recompiled 7.1 beta from current CVS today.
>
> I pg_dump'ed my 7.02 db's and reloaded it on 7.1 with no probs apart that
> psql -l shows 2 template0 and template1...
>
> Template0 and template1 belong to user postgres and to an other who has no
> priviledges and no db!!!
>
> What makes me think it's a psql bug is that select * from pg_databases
> show 1 template0 and 1 template1.
>
> For what it's worth, it on unixware 711.
>
> BTW, when is the release due for? I'm VERY impatient. This is the best
> I've seen.
>
> Regards,,
>
>

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

In response to

  • psql -l bug at 2001-01-10 18:43:05 from Olivier PRENANT

Browse pgsql-hackers by date

  From Date Subject
Next Message Olivier PRENANT 2001-01-10 21:03:25 Re: psql -l bug
Previous Message Larry Rosenman 2001-01-10 18:55:05 Re: psql -l bug