KfWiki : PostreSql

HomePage :: Categories :: PageIndex :: RecentChanges :: RecentlyCommented :: Login/Register
HomePage » Database » PostreSql


PgSQL install
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 


PgSQL vacuum
When the database is in trouble, do a full database vacuum in standalone mode.

postgres -D /usr/local/pgsql/data some_database
vacuum full;

There are 327 comments on this page. [Display comments]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki
Page was generated in 0.1811 seconds