Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Roland Hughes
On Tuesday 09 June 2009 08:55:18 am Tino Schwarze wrote: > On Tue, Jun 09, 2009 at 07:57:34AM -0500, Roland Hughes wrote: > > This has not been the case with 64-bit OpenSuSE. A fresh re-install of > > the OS required I recreate the database from backup. Postgres would NOT > > recognize or salvage

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Alvaro Herrera
Roland Hughes wrote: > H > > something seems wrong with my subscription to this list. I'm getting all > emails twice. No, it's expected; you get one from the CC and another copy from the list. You can either fix it and your end by de-duping (procmail recipes) or by a setting in Majordo

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Roland Hughes
On Tuesday 09 June 2009 09:42:45 am Tino Schwarze wrote: > > > > With RDB on OpenVMS, designed correctly, you lose nothing. Users and > > rights identifiers are provided by the OS as it integrates into the > > AUTHORIZE system. Single and multi-file databases are scattered about the > > entirety o

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Scott Mead
On Tue, Jun 9, 2009 at 10:31 AM, Roland Hughes wrote: > > With RDB on OpenVMS, designed correctly, you lose nothing. Users and rights > identifiers are provided by the OS as it integrates into the AUTHORIZE > system. Single and multi-file databases are scattered about the entirety of > the Files-1

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Tino Schwarze
Hi Roland, On Tue, Jun 09, 2009 at 09:31:43AM -0500, Roland Hughes wrote: > > > While it shouldn't be much data, it is also non-robust. With robust > > > databases, you can create as many databases as you want in as many places > > > as you want. A "fresh install" means that you only have to "te

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Roland Hughes
Are you posting twice or is this just something with my setup? I get your messages at least twice. On Tuesday 09 June 2009 09:18:50 am Scott Mead wrote: > On Tue, Jun 9, 2009 at 10:10 AM, Roland Hughes > > wrote: > > On Tuesday 09 June 2009 08:55:18 am Tino Schwarze wrote: > > > You just need

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Roland Hughes
On Tuesday 09 June 2009 09:17:10 am Tino Schwarze wrote: > On Tue, Jun 09, 2009 at 09:10:20AM -0500, Roland Hughes wrote: > > On Tuesday 09 June 2009 08:55:18 am Tino Schwarze wrote: > > > On Tue, Jun 09, 2009 at 07:57:34AM -0500, Roland Hughes wrote: > > > > This has not been the case with 64-bit

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Scott Mead
On Tue, Jun 9, 2009 at 10:10 AM, Roland Hughes wrote: > On Tuesday 09 June 2009 08:55:18 am Tino Schwarze wrote: > > > > > > > You just need to preserve everything from Postgres' data directory > > > (which shouldn't be much data). > > > > > While it shouldn't be much data, it is also non-robust.

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Tino Schwarze
On Tue, Jun 09, 2009 at 09:10:20AM -0500, Roland Hughes wrote: > On Tuesday 09 June 2009 08:55:18 am Tino Schwarze wrote: > > On Tue, Jun 09, 2009 at 07:57:34AM -0500, Roland Hughes wrote: > > > This has not been the case with 64-bit OpenSuSE. A fresh re-install of > > > the OS required I recreate

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Scott Mead
On Tue, Jun 9, 2009 at 9:05 AM, Roland Hughes wrote: > > > > I'm trying to avoid the pain of unload/recreate/reload when upgrading > OS > > > > versions. In many cases, they don't even change the Postgres version. > > > > Unloading multiple TB of binary data to text then reloading is a major > > >

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Tino Schwarze
On Tue, Jun 09, 2009 at 07:57:34AM -0500, Roland Hughes wrote: > This has not been the case with 64-bit OpenSuSE. A fresh re-install of the > OS > required I recreate the database from backup. Postgres would NOT recognize > or > salvage the directory on a TB drive containing tablespace. I d

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Roland Hughes
H something seems wrong with my subscription to this list. I'm getting all emails twice. On Tuesday 09 June 2009 06:40:06 am Scott Mead wrote: > On Mon, Jun 8, 2009 at 1:23 PM, Roland Hughes > > wrote: > > Hello, > > > > I have had a question for some time and cannot seem to find an a

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Roland Hughes
Well, This has not been the case with 64-bit OpenSuSE. A fresh re-install of the OS required I recreate the database from backup. Postgres would NOT recognize or salvage the directory on a TB drive containing tablespace. On Tuesday 09 June 2009 04:50:07 am Tino Schwarze wrote: > Hi Roland,

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Scott Mead
On Mon, Jun 8, 2009 at 1:23 PM, Roland Hughes wrote: > Hello, > > I have had a question for some time and cannot seem to find an answer. > > Is there a way to add pre-existing tablespace to a fresh Postgres install? > > Typically I create tablespace on some TB drives and place all databases > the

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Stuart Bishop
On Tue, Jun 9, 2009 at 12:23 AM, Roland Hughes wrote: > Hello, > > I have had a question for some time and cannot seem to find an answer. > > Is there a way to add pre-existing tablespace to a fresh Postgres install? > > Typically I create tablespace on some TB drives and place all databases > ther

Re: [ADMIN] Add pre-existing tablespace to new installation

2009-06-09 Thread Tino Schwarze
Hi Roland, On Mon, Jun 08, 2009 at 12:23:06PM -0500, Roland Hughes wrote: > I have had a question for some time and cannot seem to find an answer. > > Is there a way to add pre-existing tablespace to a fresh Postgres install? > > Typically I create tablespace on some TB drives and place all dat