Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-26 Thread Yaroslav Tykhiy
On 25/09/2010, at 1:11 AM, Craig Ringer wrote: On 24/09/2010 8:40 PM, Raymond O'Donnell wrote: On 24/09/2010 13:21, kongs...@stud.ntnu.no wrote: What version of PG was it? The "PG_VERSION" file = 8.3 OK, well at least it's not an ancient version that's not available any more. :-) As Cra

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-24 Thread Craig Ringer
On 24/09/2010 8:40 PM, Raymond O'Donnell wrote: On 24/09/2010 13:21, kongs...@stud.ntnu.no wrote: What version of PG was it? The "PG_VERSION" file = 8.3 OK, well at least it's not an ancient version that's not available any more. :-) As Craig said, the best thing is to get hold of a copy of

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-24 Thread Raymond O'Donnell
On 24/09/2010 13:21, kongs...@stud.ntnu.no wrote: What version of PG was it? The "PG_VERSION" file = 8.3 OK, well at least it's not an ancient version that's not available any more. :-) As Craig said, the best thing is to get hold of a copy of 8.3 that matches the architecture of the old s

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-24 Thread kongsgar
What version of PG was it? The "PG_VERSION" file = 8.3 -Håvard Wahl Kongsgård Siterer Raymond O'Donnell : On 24/09/2010 08:24, kongs...@stud.ntnu.no wrote: To specify: I have a copy of the data in "/usr/local/pgsql/data" from my old, but I don't have access to the old system anymore so I can

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-24 Thread Craig Ringer
On 24/09/2010 3:24 PM, kongs...@stud.ntnu.no wrote: To specify: I have a copy of the data in "/usr/local/pgsql/data" from my old, but I don't have access to the old system anymore so I cannot simply do a "pg_dumpall" from there. I believe I could copy the content of "/usr/local/pgsql/data" into

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-24 Thread kongsgar
To specify: I have a copy of the data in "/usr/local/pgsql/data" from my old, but I don't have access to the old system anymore so I cannot simply do a "pg_dumpall" from there. I believe I could copy the content of "/usr/local/pgsql/data" into "/usr/local/pgsql/data" on my new system. But is

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-23 Thread Alan Hodgson
On September 23, 2010 01:49:50 pm kongs...@stud.ntnu.no wrote: > Hi, > I have a copy of "/usr/local/pgsql/data" from old server. Is it > possible to do a dump of the sql databases in this directory, so that > I can easily migrate them to my current system? > You should be able to launch a postmas

Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-23 Thread Bruce Momjian
kongs...@stud.ntnu.no wrote: > Hi, > I have a copy of "/usr/local/pgsql/data" from old server. Is it > possible to do a dump of the sql databases in this directory, so that > I can easily migrate them to my current system? Yes, run pg_dumpall, save it, and load it into the new system. You rea

[GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-23 Thread kongsgar
Hi, I have a copy of "/usr/local/pgsql/data" from old server. Is it possible to do a dump of the sql databases in this directory, so that I can easily migrate them to my current system? -Håvard Wahl Kongsgård -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make cha