[services-cvs] CVS services/etc/swinst/postgres

CVS User miham root at tempel.bibl.u-szeged.hu
2004. Nov. 19., P, 22:49:26 CET


Update of /var/lib/cvs/services/etc/swinst/postgres
In directory tempel:/tmp/cvs-serv27691/etc/swinst/postgres

Modified Files:
	pg_hba.conf-patch swinst_create.sql 
Log Message:
Nah, ujabb adag modositas:
* www-data postgres-user jelszotlan
* letrehozzuk az adatbazis-strukturat is
* aktualizalt pg_hba.conf


--- /var/lib/cvs/services/etc/swinst/postgres/pg_hba.conf-patch	2004/11/09 15:01:50	1.1
+++ /var/lib/cvs/services/etc/swinst/postgres/pg_hba.conf-patch	2004/11/19 21:49:26	1.2
@@ -4,7 +4,7 @@
  #
  # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
  # Database administrative login by UNIX sockets
-+local	swinst      www-data					    password
++local	swinst      www-data					    trust
  local   all         postgres                                        ident sameuser
  #
  # All other connections by UNIX sockets
--- /var/lib/cvs/services/etc/swinst/postgres/swinst_create.sql	2004/11/19 20:50:29	1.1
+++ /var/lib/cvs/services/etc/swinst/postgres/swinst_create.sql	2004/11/19 21:49:26	1.2
@@ -2,37 +2,9 @@
 -- PostgreSQL database dump
 --
 
+BEGIN;
 SET client_encoding = 'SQL_ASCII';
 SET check_function_bodies = false;
-
-SET SESSION AUTHORIZATION 'swinst';
-
---
--- TOC entry 2 (OID 0)
--- Name: swinst; Type: DATABASE; Schema: -; Owner: swinst
---
-
-CREATE DATABASE swinst WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';
-
-
-\connect swinst swinst
-
-SET client_encoding = 'SQL_ASCII';
-SET check_function_bodies = false;
-
-SET SESSION AUTHORIZATION 'postgres';
-
---
--- TOC entry 4 (OID 2200)
--- Name: public; Type: ACL; Schema: -; Owner: postgres
---
-
-REVOKE ALL ON SCHEMA public FROM PUBLIC;
-GRANT ALL ON SCHEMA public TO PUBLIC;
-
-
-SET SESSION AUTHORIZATION 'swinst';
-
 SET search_path = public, pg_catalog;
 
 --
@@ -243,14 +215,4 @@
 ALTER TABLE ONLY licenserecords
     ADD CONSTRAINT "$2" FOREIGN KEY (pid) REFERENCES packages(pid) ON UPDATE CASCADE;
 
-
-SET SESSION AUTHORIZATION 'postgres';
-
---
--- TOC entry 3 (OID 2200)
--- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
---
-
-COMMENT ON SCHEMA public IS 'Standard public schema';
-
-
+COMMIT;





További információk a(z) Services-cvs levelezőlistáról