| 12 | jazz@oceandb:~$ sudo -u postgres psql template1 |
| 13 | Welcome to psql 8.3.4, the PostgreSQL interactive terminal. |
| 14 | |
| 15 | Type: \copyright for distribution terms |
| 16 | \h for help with SQL commands |
| 17 | \? for help with psql commands |
| 18 | \g or terminate with semicolon to execute query |
| 19 | \q to quit |
| 20 | |
| 21 | template1=# create user PG_USER with password '${PASSWORD}' createdb createuser; |
| 22 | CREATE ROLE |
| 23 | template1=# alter user postgres with password '${PASSWORD}'; |
| 24 | ALTER ROLE |
| 25 | template1=# \q |
| 26 | jazz@oceandb:~$ sudo vi /etc/apache2/conf.d/phppgadmin |
| 27 | jazz@oceandb:~$ sudo apache2ctl restart |
| 28 | }}} |
| 29 | {{{ |
| 30 | #!diff |
| 31 | --- /etc/apache2/conf.d/phppgadmin |
| 32 | +++ /etc/apache2/conf.d/phppgadmin |
| 33 | === |
| 34 | @@ -9,8 +9,8 @@ |
| 35 | order deny,allow |
| 36 | deny from all |
| 37 | -allow from 127.0.0.0/255.0.0.0 ::1/128 |
| 38 | -# allow from all |
| 39 | +# allow from 127.0.0.0/255.0.0.0 ::1/128 |
| 40 | +allow from all |
| 41 | |
| 42 | <IfModule mod_php5.c> |