Обсуждение: 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 databasesDatabase | Owner | Encoding -----------+----------+-----------ler | ler | SQL_ASCIIpostgres | postgres | SQL_ASCIItemplate0 | postgres |SQL_ASCIItemplate1 | 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)
* 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
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)