pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan I copy data file and use it with other version of Postgresql
4+ messages / 3 participants
[nested] [flat]
* Can I copy data file and use it with other version of Postgresql
@ 2007-01-21 12:54 ABC <marblerock26@yahoo.com>
2007-01-21 14:01 ` Re: Can I copy data file and use it with other version of Postgresql Chad Wagner <chad.wagner@gmail.com>
2007-01-21 18:10 ` Re: Can I copy data file and use it with other version of Postgresql Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: ABC @ 2007-01-21 12:54 UTC (permalink / raw)
To: pgsql-admin
We are facing a probelm and its very urgent to sort it out. Please Help.
The database server unexpectedly shutdown down due to power failure. On reboot, Postgresql server fails to start giving following Error:
----------------------------------------------------------------------------------------------------------
LOG: could not create IPv6 socket: Address family not supported by protocol
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0, but the server was compiled with PG_CONTROL_VERSION 72.
HINT: It looks like you need to initdb.
----------------------------------------------------------------------------------------------------------
we are using Mandrake Linux 9.1 and two version of Postgresql Version-7.4.2 and Postgresql Version-7.3.2 is installed
The Data directory is initialised with postgresql-7.4.2.
Postgresql -7.3.2 is not used .Postgresql-7.4.2 is used for managing Postgres Server.
Can I copy the Data Files and use tht Data with other Version of Postgresql ??.
---------------------------------
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can I copy data file and use it with other version of Postgresql
2007-01-21 12:54 Can I copy data file and use it with other version of Postgresql ABC <marblerock26@yahoo.com>
@ 2007-01-21 14:01 ` Chad Wagner <chad.wagner@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Chad Wagner @ 2007-01-21 14:01 UTC (permalink / raw)
To: ABC <marblerock26@yahoo.com>; +Cc: pgsql-admin
On 1/21/07, ABC <marblerock26@yahoo.com> wrote:
>
> We are facing a probelm and its very urgent to sort it out. Please Help.
> The database server unexpectedly shutdown down due to power failure. On
> reboot, Postgresql server fails to start giving following Error:
>
> ----------------------------------------------------------------------------------------------------------
> LOG: could not create IPv6 socket: Address family not supported by
> protocol
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0,
> but the server was compiled with PG_CONTROL_VERSION 72.
> HINT: It looks like you need to initdb.
>
> ----------------------------------------------------------------------------------------------------------
>
> we are using Mandrake Linux 9.1 and two version of Postgresql
> Version-7.4.2 and Postgresql Version-7.3.2 is installed
> The Data directory is initialised with postgresql-7.4.2.
> Postgresql -7.3.2 is not used .Postgresql-7.4.2 is used for managing
> Postgres Server.
>
> Can I copy the Data Files and use tht Data with other Version of
> Postgresql ??.
>
Not in this case, you have to dump and restore. You can *usually* take the
data files from "patch" releases, say 8.2.0 to 8.2.1, but minor releases
such as 8.1 to 8.2 often do not work because of changes in data layouts,
pg_catalog changes, etc. It looks like your original data was on 7.2, best
bet is to build a 7.2 server, start up, dump and then restore to the new
server.
--
Chad
http://www.postgresqlforums.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can I copy data file and use it with other version of Postgresql
2007-01-21 12:54 Can I copy data file and use it with other version of Postgresql ABC <marblerock26@yahoo.com>
@ 2007-01-21 18:10 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2007-01-21 18:10 UTC (permalink / raw)
To: ABC <marblerock26@yahoo.com>; +Cc: pgsql-admin
ABC <marblerock26@yahoo.com> writes:
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0, but the server was compiled with PG_CONTROL_VERSION 72.
It looks to me like something has happened to your pg_control file :-(
What does pg_controldata show?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Can I copy data file and use it with other version of Postgresql
@ 2007-01-21 13:02 ABC <marblerock26@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: ABC @ 2007-01-21 13:02 UTC (permalink / raw)
To: pgsql-admin
We are facing a probelm and its very urgent to sort it out. Please Help.
The database server unexpectedly shutdown down due to power failure. On reboot, Postgresql server fails to start giving following Error:
----------------------------------------------------------------------------------------------------------
LOG: could not create IPv6 socket: Address family not supported by protocol
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0, but the server was compiled with PG_CONTROL_VERSION 72.
HINT: It looks like you need to initdb.
----------------------------------------------------------------------------------------------------------
we are using Mandrake Linux 9.1 and two version of Postgresql Version-7.4.2 and Postgresql Version-7.3.2 is installed
The Data directory is initialised with postgresql-7.4.2.
Postgresql -7.3.2 is not used .Postgresql-7.4.2 is used for managing Postgres Server.
Can I copy the Data Files and use tht Data with other Version of Postgresql ??.
---------------------------------
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-01-21 18:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-21 12:54 Can I copy data file and use it with other version of Postgresql ABC <marblerock26@yahoo.com>
2007-01-21 14:01 ` Chad Wagner <chad.wagner@gmail.com>
2007-01-21 18:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-01-21 13:02 Can I copy data file and use it with other version of Postgresql ABC <marblerock26@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox