PostgreSQL Windows 8.4 tablespaces on remote servers

From: Michael O'Donnell <odonnellm(at)usgs(dot)gov>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL Windows 8.4 tablespaces on remote servers
Date: 2010-11-09 19:21:35
Message-ID: OFA6169429.20E2A6DE-ON872577D6.00692C88-872577D6.006A58B8@usgs.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am a relatively new user of PostgreSQL and I would like to create a
tablespace on a remote 2008 standard x86 server. I am using a 2008 x64 R2
server to host the PostgreSQL service. The host is a VM and the NTFS is
not.

I am able to create tablespaces on the Postgres server in various places.
Afterword, I can successfully add databases to these tablespaces. However,
when I try to create a tablespace on a different server, I can create part
of the tablespace but it seems there is an error with creating the
directories that are automatically generated. However, I do not get an
error during the create tablespace step. If I proceed to generate a
database on this table space, there is an error that certain folders do
not exist.

I have permissions set up for the service account and the database account
for the folder on the remote server where I would like to create the
tablespace. Based on what I have read, I only need to have the service
account have permissions, but I have tried to open it up entirely for
testing. I can create files and folders from the postgres server when
navigating to the other server disk, and I have double checked the
security settings for all relevant accounts.

What I am trying to figure out is why I cannot do this and whether I have
to use UNC paths. I have found some information on blogs, but no
solutions. I have found very little information in the manuals as to how
one sets up a tablespace on a remote server and whether UNC paths are
required or not.

Can anyone provide me with suggestions?

Thank you,
mike

Browse pgsql-admin by date

  From Date Subject
Next Message Lou Picciano 2010-11-09 21:12:19 Re: PostgreSQL Windows 8.4 tablespaces on remote servers
Previous Message Kasia Tuszynska 2010-11-09 18:14:23 trouble creating a tablespace on win2k8r2 with pg9.0