Thread: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

From

Anders Söderman

Date:

07 November 2010, 06:59:18

Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL to store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2 environment.

In the Setup Wizard I accept C:\Program\PostgreSQL\9.0

and I change C:\Program\PostgreSQL\9.0\data to either //R1/aa_db/PostgreSQL\9.0\data or P:\PostgreSQL\9.0\data where P:\ = //R1/aa_db/ on the computer from which I´m installing Postgresql.

R1 is the name of the Netgear disk och aa_db the Share/folder I want to store the PostgreSQL data in.

I have tried every possible combination I can think of. Sometimes the installation seems to work, but in pgAdmin “Connected?” says “No”. If I try to install PostGIS afterwards I crashes during the EnterpriseDB Stackbuilder installation.
After several hours I can´t find any useful information in the manual or on the FORUMs.
If anybody could give me a hint where I should look I would be so happy. Regards Anders Söderman Stockholm Sweden

Re: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

From

Magnus Hagander

Date:

07 November 2010, 14:33:15

2010/11/7 Anders Söderman <Anders.Soderman@gisassistans.se>:
> Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL to
> store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2
>  environment.

Note that storing the PostgreSQL data on a SMB mount is *not* safe and
not supported. I don't know how your specific disk does it, but if it
uses SMB or NFS, this is not safe. If it's an iSCSI mount, for
example, it should be safe. But it certainly looks like an SMB mount -
in which case you should rethink your strategy.

I would bet your problems are caused by this.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

From

Anders Söderman

Date:

08 November 2010, 04:16:57

Thanks for your help, Magnus. This problem was way over my head, so I´m glad I can leave it behind. I´ll will try to secure the PostgreSQL/PostGIS database using ordinary backup methods. Regards Anders Söderman Stockholm Sweden

-----Original Message-----
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: den 7 november 2010 16:33
To: Anders Söderman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

2010/11/7 Anders Söderman <Anders.Soderman@gisassistans.se>:

> Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL to

> store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2

> environment.

Note that storing the PostgreSQL data on a SMB mount is *not* safe and

not supported. I don't know how your specific disk does it, but if it

uses SMB or NFS, this is not safe. If it's an iSCSI mount, for

example, it should be safe. But it certainly looks like an SMB mount -

in which case you should rethink your strategy.

I would bet your problems are caused by this.

Magnus Hagander

Me: http://www.hagander.net/

Work: http://www.redpill-linpro.com/

Re: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

From

Sachin Srivastava

Date:

08 November 2010, 06:55:50

Hello,

On Nov 7, 2010, at 1:22 PM, Anders Söderman wrote:

Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL to store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2 environment.

In the Setup Wizard I accept C:\Program\PostgreSQL\9.0
and I change C:\Program\PostgreSQL\9.0\data to either //R1/aa_db/PostgreSQL\9.0\data or P:\PostgreSQL\9.0\data where P:\ = //R1/aa_db/ on the computer from which I´m installing Postgresql.
R1 is the name of the Netgear disk och aa_db the Share/folder I want to store the PostgreSQL data in.

I have tried every possible combination I can think of. Sometimes the installation seems to work, but in pgAdmin “Connected?” says “No”. If I try to install PostGIS afterwards I crashes during the EnterpriseDB Stackbuilder installation.
After several hours I can´t find any useful information in the manual or on the FORUMs.
If anybody could give me a hint where I should look I would be so happy. Regards Anders Söderman Stockholm Sweden

What exactly is the error message you get while installing PostgreSQL? Can you attach the installation log (%TEMP%\install-postgresql.log) or (%TEMP%\bitrock_installer_<some number>.log).

Regards,

Sachin Srivastava

EnterpriseDB, the Enterprise PostgreSQL company.

Re: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

From

Sachin Srivastava

Date:

09 November 2010, 07:38:41

Hello,

From the logs it seems, the initdb was successful, However, the database server failed to start afterwards. Can you manually start the database service? If yes try installing PostGIS from stackbuilder after that.

If no, then whats the error message you are getting?

2010/11/9 Anders Söderman <Anders.Soderman@gisassistans.se>

Hello
I´ve tried many times to install in different ways. Hopefully I removed all files from previous installations before trying again.
I don´t know if the logs are useful. I´ve tried to understand what the log says without result.
I think, right now, that I should do an PostgreSQL/PostGIS installation using all default values and then try to change the "postgresql\9.0\data" folder to the RAID-1 LAN-disk. Thanks Anders Söderman Stockholm Sweden
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Sachin Srivastava
Sent: den 8 november 2010 08:56

To: Anders Söderman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

Hello,
On Nov 7, 2010, at 1:22 PM, Anders Söderman wrote:

Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL to store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2 environment.

In the Setup Wizard I accept C:\Program\PostgreSQL\9.0
and I change C:\Program\PostgreSQL\9.0\data to either //R1/aa_db/PostgreSQL\9.0\data or P:\PostgreSQL\9.0\data where P:\ = //R1/aa_db/ on the computer from which I´m installing Postgresql.
R1 is the name of the Netgear disk och aa_db the Share/folder I want to store the PostgreSQL data in.

I have tried every possible combination I can think of. Sometimes the installation seems to work, but in pgAdmin “Connected?” says “No”. If I try to install PostGIS afterwards I crashes during the EnterpriseDB Stackbuilder installation.
After several hours I can´t find any useful information in the manual or on the FORUMs.
If anybody could give me a hint where I should look I would be so happy. Regards Anders Söderman Stockholm Sweden

What exactly is the error message you get while installing PostgreSQL? Can you attach the installation log (%TEMP%\install-postgresql.log) or (%TEMP%\bitrock_installer_<some number>.log).
--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

--
Regards,
Sachin Srivastava
EnterpriseDB, India