PostgreSQL

Revision as of 07:43, 1 June 2009 (view source) Ognjen (Talk | contribs) m (→Upgrade sa 8.1 na 8.3) ← Older edit		Revision as of 10:45, 9 June 2009 (view source) Ognjen (Talk | contribs) (→Upgrade sa 8.1 na 8.3: Dodao restore i vacuum) Newer edit →
Line 184:		Line 184:
	/etc/init.d/postogres start		/etc/init.d/postogres start
−	Uraditi restore baze. Uraditi vacuum. Podesiti postgresql.conf i pg_hba.conf. Podesiti	+	Uraditi restore baze:
−	iptables.	+
		+	psql -d postgres -f ../pgsql-old-8.1/db_all.dump
		+
		+	Uraditi vacuum:
		+
		+	vacuumdb -az
		+
		+	Podesiti postgresql.conf i pg_hba.conf. Podesiti iptables.
	==Spoljašne veze==		==Spoljašne veze==
	* [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi]		* [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi]

---

Revision as of 10:45, 9 June 2009