Revision [3755]
Last edited on 2010-07-20 18:45:16 by KenFongAdditions:
~ [[PostgresqlSize Database or table size]]
OR
If vacuum full is not possible,
vacuumdb -a -z
OR
If vacuum full is not possible,
vacuumdb -a -z
Revision [2028]
Edited on 2008-10-21 00:10:51 by WikiAdminAdditions:
~ [[PostgresqlPHPSample PHP Connect Sample]]
Revision [2024]
Edited on 2008-10-20 22:19:00 by WikiAdminAdditions:
CREATE DATABASE d1 WITH OWNER=some_user ENCODING='UTF8' ;
Deletions:
Revision [2019]
Edited on 2008-10-20 22:02:20 by WikiAdminAdditions:
~ [[PostgresqlRoles Users and Roles]]
Revision [2016]
Edited on 2008-10-20 21:50:48 by WikiAdminAdditions:
~ [[PostgresqlBackup Backup and Restore]]
Deletions:
pg_dumpall | gzip > pgsql.dmp.gz
Revision [2015]
Edited on 2008-10-20 21:50:00 by WikiAdminAdditions:
===PostgreSQL topics===
Revision [2012]
Edited on 2008-10-20 21:48:38 by WikiAdminAdditions:
~ [[PostgresqlInstall Installation]]
Deletions:
Revision [2011]
Edited on 2008-10-20 21:48:26 by WikiAdminAdditions:
~ [[Postgresql Installation]]
~ [[PostgresqlTuning Tuning]]
~ [[PostgresqlTuning Tuning]]
Deletions:
Installing postgres from source
./configure
gmake
gmake install
useradd postgres
mkdir -p /usr/local/pgsql/data
chown postgres:postgres /usr/local/pgsql/data
su - postgres
initdb -D /usr/local/pgsql/data
postmaster -D /usr/local/pgsql/data > logfile 2>&1 &
createdb test
psql test
cd postgresql-version/contrib/tsearch2
make
make install
Revision [2010]
Edited on 2008-10-20 21:46:14 by WikiAdminAdditions:
==Query running processes==
select * from pg_stat_activity;
select * from pg_stat_activity;
