|
⇤ ← Revision 1 as of 2006-06-29 00:38:02
Size: 552
Comment:
|
Size: 1678
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| Installing Postgres from scratch: install packages downloaded from postgresql web site located in /u2/programs/postgres_and_odbc/ on sam (do not use yum install, it will install ancient garbage 5-10 years old) |
== Installing Postgres from scratch: == install packages downloaded from postgresql web site located in /u2/programs/postgres_and_odbc/ on sam (do not use yum install, it will install ancient garbage 5-10 years old) |
| Line 9: | Line 13: |
set password for system user postgres then use postgres system account for the rest of setup create directory somewhere and move /var/lib/pgsql/data and /var/lib/pgsql/backups there. {{{ /etc/init.d/postgresql stop mkdir /u/Database/postgresql [root@sam ccdev]# mv /var/lib/pgsql/data /u/Database/postgresql [root@sam ccdev]# mv /var/lib/pgsql/backups /u/Database/postgresql [root@sam ccdev]# ln -s /u/Database/postgresql/backups /var/lib/pgsql/backups [root@sam ccdev]# ln -s /u/Database/postgresql/data /var/lib/pgsql/data /etc/init.d/postgresql start }}} create default table if does not exist, try psql without args, if complains: {{{ createdb }}} set password for default database user postgres: {{{ psql $alter user postgres password 'sql'; $\q }}} setup/change identification method {{{ vi /var/lib/pgsql/data/pg_hba.conf --change ident to password (unless you have any better idea (for example --how to use ident service or use encripted passwords ;-) }}} restart postmaster: {{{ /etc/init.d/postgresql stop /etc/init.d/postgresql start }}} ---- CategorySql |
Installing Postgres from scratch:
install packages downloaded from postgresql web site located in /u2/programs/postgres_and_odbc/ on sam
(do not use yum install, it will install ancient garbage 5-10 years old)
rpm --install /u2/programs/postgres_and_odbc/postgresql-libs-8.1.3-1PGDG.i686.rpm rpm --install /u2/programs/postgres_and_odbc/postgresql-devel-8.1.3-1PGDG.i686.rpm rpm --install /u2/programs/postgres_and_odbc/postgresql-8.1.3-1PGDG.i686.rpm rpm --install /u2/programs/postgres_and_odbc/postgresql-server-8.1.3-1PGDG.i686.rpm
set password for system user postgres then use postgres system account for the rest of setup
create directory somewhere and move /var/lib/pgsql/data and /var/lib/pgsql/backups there.
/etc/init.d/postgresql stop mkdir /u/Database/postgresql [root@sam ccdev]# mv /var/lib/pgsql/data /u/Database/postgresql [root@sam ccdev]# mv /var/lib/pgsql/backups /u/Database/postgresql [root@sam ccdev]# ln -s /u/Database/postgresql/backups /var/lib/pgsql/backups [root@sam ccdev]# ln -s /u/Database/postgresql/data /var/lib/pgsql/data /etc/init.d/postgresql start
create default table if does not exist, try psql without args, if complains:
createdb
set password for default database user postgres:
psql $alter user postgres password 'sql'; $\q
setup/change identification method
vi /var/lib/pgsql/data/pg_hba.conf --change ident to password (unless you have any better idea (for example --how to use ident service or use encripted passwords ;-)
restart postmaster:
/etc/init.d/postgresql stop /etc/init.d/postgresql start