psql -l bug
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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
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.
For more info (don't think it's a bug) I see two templates db too.
BTW, when is the release due for? I'm VERY impatient. This is the best
I've seen.
I'm looking forword to seeing the release of 7.1.
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------
* Olivier PRENANT <ohp@pyrenet.fr> [010110 12:47]:
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.
I'm also on UW711, and do *NOT* see the bug:
Password:
List of databases
Database | Owner | Encoding
-----------+----------+-----------
ler | ler | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(4 rows)
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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
As I said previously.. I apologies, this was all my fault.
Please discard...
Oh my, When will we have an RC???
On Wed, 10 Jan 2001, Larry Rosenman wrote:
* Olivier PRENANT <ohp@pyrenet.fr> [010110 12:47]:
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.I'm also on UW711, and do *NOT* see the bug:
Password:
List of databases
Database | Owner | Encoding
-----------+----------+-----------
ler | ler | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(4 rows)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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
--
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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
* Olivier PRENANT <ohp@pyrenet.fr> [010110 15:03]:
As I said previously.. I apologies, this was all my fault.
Please discard...
Oh my, When will we have an RC???
SOON. I'm running the BETA,....
LER
On Wed, 10 Jan 2001, Larry Rosenman wrote:
* Olivier PRENANT <ohp@pyrenet.fr> [010110 12:47]:
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.I'm also on UW711, and do *NOT* see the bug:
Password:
List of databases
Database | Owner | Encoding
-----------+----------+-----------
ler | ler | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(4 rows)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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)--
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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749