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