postgres-tutorialfor the Network tags field.
postgres, during installation. This user doesn't yet have a password, so you need to set one.
adminpackextension to enable the server instrumentation that you installed earlier. The console prints
CREATE EXTENSIONwhen successful.
\qto exit PSQL.
exitto exit the root shell.
pg_hba.conf. This tutorial uses the
nanoeditor, but you can substitute your favorite editor. For PostgreSQL version 9.3, you can enter:
Control+xand then use the
Returnkey to accept the prompts to save the file. Note that nano might not clear the console screen properly, so if you have trouble reading the text in the console after closing nano, enter
clearto clear the screen.
#listen_addresses = 'localhost'.
#character to uncomment the line.
'*'setting enables Postgres to listen on all IP addresses. This is a commonly used setting. When you set the IP address in
hba.confin the previous step, you restricted access to the database to only your computer.
postgres-tutorial) that you used for the instance.
/32suffix, for example:
5432for the value.
Applicationfolder, and paste pgAdmin into this folder.
http://or other characters.
appspot.comURL, remain available.