Обсуждение: [win32] 8.3.5 -> 8.3.7 install trouble
I went to upgrade an installation and was stopped with (approximately) the following message after clicking Next on the step where I told it to use the same data directory: "The existing data directory (date time: floating-point numbers) is not compatible with this server (date time: 64-bit integers)." This is with the EDB postgresql-8.3.7-1-windows.exe that I found on postgresql.org. Apparently for 8.3.5 I had found a .zip file containing an .msi. I think the new text threw me--I remember the install being easy, and the .msi mentioned stuff about Group Policy and other advanced options and I thought, "Well, I don't need anything that fancy." Just a warning in case someone else was thinking they were compatible.
asd
fas
dfasdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffddddddddddddddsssssssaaaaaaaaaaaaaaaaaaaaaaaaa
asdf
asdf
asdasdfasdfasdfasdfasdfasdfsa
fas
df
asdf
asdf
asd
fas
df
asdf
asdf
asd
fasdfasdfasdfasdfsad
Uberdam Cavaletti
Formado em Tecnologia da Informação - Unoesc - Xxe
Pós-graduado em desenvolvimento Java - Unoesc - Xxe
http://www.curricular.com.br/berdam
Visite
http://passandoveneno.blogspot.com
----------------------------------------------------------------------------------------
De: Kev <kevinjamesfield@gmail.com>
Para: pgsql-general@postgresql.org
Enviadas: Terça-feira, 24 de Março de 2009 9:24:53
Assunto: [GENERAL] [win32] 8.3.5 -> 8.3.7 install trouble
I went to upgrade an installation and was stopped with (approximately)
the following message after clicking Next on the step where I told it
to use the same data directory:
"The existing data directory (date time: floating-point numbers) is
not compatible with this server (date time: 64-bit integers)."
This is with the EDB postgresql-8.3.7-1-windows.exe that I found on
postgresql.org. Apparently for 8.3.5 I had found a .zip file
containing an .msi. I think the new text threw me--I remember the
install being easy, and the .msi mentioned stuff about Group Policy
and other advanced options and I thought, "Well, I don't need anything
that fancy."
Just a warning in case someone else was thinking they were compatible.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes
Hi.
I have a little problem with user names and Postgres commands.
Due to quirks in corporate account management using ADS, some user names come out as, say, Mickey when you log into Linux instead of mickey. This unfortunate user tries to run Postgres commands and gets for instance:
$ psql
psql: FATAL: database “Mickey” does not exist
$ id
uid=123456(Mickey) gid=…
$ pg_dump >dump.out
pg_dump: [archiver (db)] connection to database “Mickey” failed: FATAL: database “Mickey” does not exist
$ psql mickey mickey
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.
. . .
I have set up pg_hba.conf with lines like
local all all trust
host all all 127.0.0.1/32 trust
I tried modifying pg_ident.conf but couldn’t get any results.
When I try going into psql as user postgres to change the user name, I get this problem:
postgres=# alter user mickey rename to Mickey;
ERROR: role “mickey” already exists
What can I do so that the default user is accepted? I would like the user to be able to just type:
$ psql
and get in successfully.
Any help would be appreciated.
-Will
Will Rutherdale (rutherw) wrote: > When I try going into psql as user postgres to change the user name, I > get this problem: > > postgres=# alter user mickey rename to Mickey; > > ERROR: role “mickey” already exists > you might try... alter user "mickey" rename to "Mickey";
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
De: John R Pierce <pierce@hogranch.com>
Para: Will Rutherdale (rutherw) <rutherw@cisco.com>
Cc: pgsql-general@postgresql.org
Enviadas: Terça-feira, 24 de Março de 2009 17:21:20
Assunto: Re: [GENERAL] Case sensitivity problems with user name
Will Rutherdale (rutherw) wrote:
> When I try going into psql as user postgres to change the user name, I get this problem:
>
> postgres=# alter user mickey rename to Mickey;
>
> ERROR: role “mickey” already exists
>
you might try...
alter user "mickey" rename to "Mickey";
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes
Yes, that worked, thanks. After also doing this: alter database "mickey" rename to "Mickey"; it solved the problem. Pardon my newness to Postgres. -Will -----Original Message----- From: John R Pierce [mailto:pierce@hogranch.com] Sent: 24 March 2009 16:21 To: Will Rutherdale (rutherw) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Case sensitivity problems with user name Will Rutherdale (rutherw) wrote: > When I try going into psql as user postgres to change the user name, I > get this problem: > > postgres=# alter user mickey rename to Mickey; > > ERROR: role "mickey" already exists > you might try... alter user "mickey" rename to "Mickey";
On 24/03/2009 20:38, Will Rutherdale (rutherw) wrote: > Pardon my newness to Postgres. We've all been there at some point! - except of course for Tom Lane. :-) Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On 24/03/2009 20:25, Berdam wrote: > aergggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg ? ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
asdsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss Berdam escreveu: > aergggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > > > > > > ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg > ------------------------------------------------------------------------ > *De:* John R Pierce <pierce@hogranch.com> > *Para:* Will Rutherdale (rutherw) <rutherw@cisco.com> > *Cc:* pgsql-general@postgresql.org > *Enviadas:* Terça-feira, 24 de Março de 2009 17:21:20 > *Assunto:* Re: [GENERAL] Case sensitivity problems with user name > > Will Rutherdale (rutherw) wrote: > > When I try going into psql as user postgres to change the user name, > I get this problem: > > > > postgres=# alter user mickey rename to Mickey; > > > > ERROR: role “mickey” already exists > > > > you might try... > > alter user "mickey" rename to "Mickey"; > > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org > <mailto:pgsql-general@postgresql.org>) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > ------------------------------------------------------------------------ > Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 > <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/> > - Celebridades > <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/celebridades/> > - Música > <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/m%C3%BAsica/> > - Esportes > <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/esportes/> -- ----------------------------------------------------- Uberdam Cavaletti Formado em Tecnologia da informação - Unoesc - Xxe Pós graduado em Desenvolvimento Java - Unoesc - Xxe Acesse http://www.curricular.com.br/berdam Acesse http://passandoveneno.blogspot.com -----------------------------------------------------