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/

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/

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.

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 <http://www.enterprisedb.com&gt;, the Enterprise PostgreSQL<http://www.enterprisedb.com&gt;
company.

--
Regards,
Sachin Srivastava
EnterpriseDB, India