Search Postgresql Archives

Re: storing postgres data on dropbox

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 06/18/2017 01:00 PM, Martin Mueller wrote:
Did you mean  that "/users/martin/Library ApplicationSupport/Postgres/var9.5/base/" is above  or below the data directory?  As I understand it Postgres is the highest Postgres specific directory. It contains just one child directory, var-9.5, which has a lot of subdirectories, including 'base'. So I assume that "base" is the "entire Postgres directory". Is that correct

Pretty sure the answer is no. I am going to say the Postgres data directory is /users/martin/Library ApplicationSupport/Postgres/var9.5/.

Take a look at this link:

https://www.postgresql.org/docs/9.6/static/storage-file-layout.html

and see if what is under:

/users/martin/Library ApplicationSupport/Postgres/var9.5/

looks similar.

*** It would also help to know how you installed Postgres? ***





3) You will need to make sure you are copying/syncing the entire
Postgres data directory:

https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_9.6_static_storage-2Dfile-2Dlayout.html&d=DwICaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=lQpZV77iEes6tm1L3zsHQm9eceGhQh8UV4IOgzDvapg&s=MpRqOYUdfX_Z4OK9-AFg2b7glEe4lY2aYupB6508ZjQ&e=

 From you original post the directory you mentioned:

/users/martin/Library ApplicationSupport/Postgres/var9.5/base/

looks to be below the top level data directory.

While I remember, how are you installing/updating Postgres on your machines?



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux