PostgreSQL Windows 8.4 tablespaces on remote servers

Поиск
Список
Период
Сортировка
От Michael O'Donnell
Тема PostgreSQL Windows 8.4 tablespaces on remote servers
Дата
Msg-id OFA6169429.20E2A6DE-ON872577D6.00692C88-872577D6.006A58B8@usgs.gov
обсуждение исходный текст
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kasia Tuszynska
Дата:
Сообщение: trouble creating a tablespace on win2k8r2 with pg9.0
Следующее
От: Lou Picciano
Дата:
Сообщение: Re: PostgreSQL Windows 8.4 tablespaces on remote servers