[win32] 8.3.5 -> 8.3.7 install trouble

Started by Kevin Fieldabout 17 years ago9 messagesgeneral

kevinjamesfield@gmail.com

about 17 years ago

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.

berdam

berdamzinho@yahoo.com.br

about 17 years ago

In reply to: Kevin Field (#1)

Res: [win32] 8.3.5 -> 8.3.7 install trouble

asssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
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)."

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
http://br.maisbuscados.yahoo.com

Will Rutherdale (rutherw)

rutherw@cisco.com

about 17 years ago

In reply to: berdam (#2)

Case sensitivity problems with user name

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

John R Pierce

pierce@hogranch.com

about 17 years ago

In reply to: Will Rutherdale (rutherw) (#3)

Re: 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";

berdam

berdamzinho@yahoo.com.br

about 17 years ago

In reply to: John R Pierce (#4)

Res: Case sensitivity problems with user name

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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Will Rutherdale (rutherw)

rutherw@cisco.com

about 17 years ago

In reply to: John R Pierce (#4)

Re: Case sensitivity problems with user name

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";

Raymond O'Donnell

rod@iol.ie

about 17 years ago

In reply to: Will Rutherdale (rutherw) (#6)

Re: Case sensitivity problems with user name

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
------------------------------------------------------------------

Raymond O'Donnell

rod@iol.ie

about 17 years ago

In reply to: berdam (#5)

Re: Res: Case sensitivity problems with user name

On 24/03/2009 20:25, Berdam wrote:

aergggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg

berdam

berdamzinho@yahoo.com.br

about 17 years ago

In reply to: berdam (#5)

Re: Res: Case sensitivity problems with user name

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

-----------------------------------------------------