Where is PostgreSQL server installed in Windows 8.1

Question

I want to share my PostgreSQL server with another machine but I cannot find where the database server is installed.

Can anyone tell me where the server is installed under Windows 8.1?

Possible duplicate of [Where does PostgreSQL store the database?](http://stackoverflow.com/questions/1137060/where-does-postgresql-store-the-database) — SBI, Dec 22 '15 at 12:23

score 1 · Answer 1 · answered Dec 22 '15 at 12:54

1

By default the data directory for PostgresDB in Windows is C:\Program Files\PostgreSQL\<your-version>\data

However you could go and export the databases via pg_dump or pgAdmin and restore them on the other machine.

answered Dec 22 '15 at 12:54

rzo1

score -1 · Answer 2 · answered Dec 22 '15 at 12:51

If it is installed as services, just look to services and see "path to executable".

You will find something like:

"C:\Program Files\PostgreSQL\9.3\bin\pg_ctl.exe" runservice -N "postgresql-x64-9.3" -D "O:/pgdata_9.3" -w

Where you have both executable path and datadir path (the one on -D parameter).

2 Answers2