1 == User/permission stuff with pg ==
4 revoke ALL on DATABASE "XXX" from public;
6 grant CONNECT, CREATE, TEMPORARY on DATABASE "XXX" to "YYY";
7 grant CONNECT on DATABASE "XXX" to public;
8 grant TEMPORARY on DATABASE "XXX" to guest;
10 REVOKE ALL ON SCHEMA public from public;
11 GRANT USAGE ON SCHEMA public TO public;
12 GRANT ALL ON SCHEMA public TO "YYY";
17 select * from pg_database ;
21 sudo -u postgres psql "XXX" << EOF
22 CREATE LANGUAGE plpgsql;
25 sudo -u postgres psql "XXX" < /usr/share/postgresql/8.3/contrib/debversion.sql