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
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 |