Revision [2031]
Last edited on 2008-10-21 00:26:39 by WikiAdminAdditions:
First off, create the user. Notice if the database's owner is a different user (role), one must grant privileges to individual tables. There is no "schema.*" here. Very annoying.
# You will need table grant here.
GRANT ALL ON t1 TO webuser;
# You will need table grant here.
GRANT ALL ON t1 TO webuser;
Deletions:
Revision [2030]
Edited on 2008-10-21 00:21:09 by WikiAdminAdditions:
For my case, I'm connecting from non-localhost, so I need to tell postgresql to listen on the internal network
%%(postgresql.conf)
listen_addresses = 'localhost, 192.168.x.10'
$dbconn = pg_connect("host=192.168.x.10 dbname=d2 user=webuser password=xxxxx")
%%(postgresql.conf)
listen_addresses = 'localhost, 192.168.x.10'
$dbconn = pg_connect("host=192.168.x.10 dbname=d2 user=webuser password=xxxxx")
