Обсуждение: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

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

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/