PostgreSQL Cookbook: Difference between revisions
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
== Restarting the server == | == Restarting the server == | ||
* Run '''pgAdmin III'''. | |||
=== Restarting manually === | |||
<div class="alert-warning">I am including the information below because it's the most commonly documented method. It did not work reliably on Windows, however. It seems like not every process would be killed, and that some of them would still be attached to port 5432. The service could not be restarted after the server was stopped.</div> | |||
The PostgreSQL service name includes the version number. | The PostgreSQL service name includes the version number. | ||
| Line 28: | Line 35: | ||
* '''Start Menu''' > '''Services''' ''(command line: `services.msc`)'' | * '''Start Menu''' > '''Services''' ''(command line: `services.msc`)'' | ||
* Check the status of the postgresql service. (Its name will end with the version number.) | * Check the status of the postgresql service. (Its name will end with the version number.) | ||
== Allowing remote access for pgAdmin III == | == Allowing remote access for pgAdmin III == | ||
Revision as of 00:32, 22 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
- Run pgAdmin III.
Restarting manually
I am including the information below because it's the most commonly documented method. It did not work reliably on Windows, however. It seems like not every process would be killed, and that some of them would still be attached to port 5432. The service could not be restarted after the server was stopped.
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.[1]
This appears to stop the PostgreSQL service & requires the service to be manually restarted.
- Start Menu > Services (command line:
services.msc) - Check the status of the postgresql service. (Its name will end with the version number.)
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.)[2] [3] - Confirm that that the PostgreSQL service is running in the Services control panel.
Notes
- ↑ pg_ctl (PostgreSQL documentation)
- ↑ 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.