PostgreSQL Cookbook: Difference between revisions
Jump to navigation
Jump to search
| Line 27: | Line 27: | ||
* Make sure that the PostgreSQL port (default 5432) is open on the host machine. | * Make sure that the PostgreSQL port (default 5432) is open on the host machine. | ||
* Edit `data\pg_hba.conf` in the PosgreSQL installation directory to give the remote machine access. (Requires the PostgreSQL server to be restarted.)<ref>[http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html The pg_hba.conf File] PostgreSQL documentation</ref> | * Edit `data\pg_hba.conf` in the PosgreSQL installation directory to give the remote machine access. (Requires the PostgreSQL server to be restarted.)<ref>[http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html The pg_hba.conf File] PostgreSQL documentation</ref> <ref>[http://postgresql.nabble.com/IP-range-in-pg-hba-conf-td4973998.html IP range in pg_hba.conf?] (PostgreSQL forums)<br />There is an explanation of CIDR masks at the end of the thread.</ref> | ||
* Confirm that that the PostgreSQL service is running. | * Confirm that that the PostgreSQL service is running. | ||
** '''Start Menu''' > '''Services''' | ** '''Start Menu''' > '''Services''' | ||
Revision as of 14:48, 21 March 2015
Installation on Windows
Search for the "PostgreSQL Windows". There is an installer available. It's pretty straightforward.
Creating a database
Use the pgAdmin III program.
- First create a Login Role for the database. Set the database's owner to the new (or existing) login role:
Object browser > Server Groups > [server] > Login Roles > (right click) > New Login Role - Create the database
Object browser > Server Groups > [server] > Databases > (right click) > New Database
Restarting the server
The PostgreSQL service name includes the version number.
With powershell run with Administrator privileges, navigate to the bin\ directory in the PostgreSQL installation directory.
> .\wp_ctl.exe restart -w -D "c:\ProgramData\PostgreSQL\9.4\data\"
-wWait for the server to stop and start.-DPath to data directory. The version number may be different depending on the installation.
Allowing remote access for pgAdmin III
- Make sure that the PostgreSQL port (default 5432) is open on the host machine.
- Edit
data\pg_hba.confin the PosgreSQL installation directory to give the remote machine access. (Requires the PostgreSQL server to be restarted.)[1] [2] - Confirm that that the PostgreSQL service is running.
- Start Menu > Services
- Check the status of the postgresql service. (Its name will end with the version number.)
Notes
- ↑ The pg_hba.conf File PostgreSQL documentation
- ↑ IP range in pg_hba.conf? (PostgreSQL forums)
There is an explanation of CIDR masks at the end of the thread.