PostgreSQL Windows 8.4 tablespaces on remote servers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]