installing_postgresql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
installing_postgresql [2007/05/21 10:47] – bott | installing_postgresql [2010/09/06 13:07] (current) – Delete obsolete page dbs | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | [[user-comments: | ||
- | PostgreSQL can be downloaded from http:// | ||
- | |||
- | Latest tests were performed with postgresql-8.0.3. | ||
- | |||
- | user$ su | ||
- | bash# ./configure --prefix=/ | ||
- | bash# cd /opt/ | ||
- | bash# mkdir data | ||
- | bash# chown postgres: | ||
- | bash# su postgres | ||
- | | ||
- | | ||
- | - set listen_address =' | ||
- | | ||
- | | ||
- | bash# cd / | ||
- | bash# cd /opt && PGUSER=postgres PGDATABASE=template1 bin/psql | ||
- | pg# \i / | ||
- | pg# \i / | ||
- | pg# \q | ||
- | bash# PGUSER=postgres bin/ | ||
- | bash# PGUSER=postgres bin/ | ||
- | bash# PGUSER=postgres bin/ | ||
- | bash# PGUSER=postgres bin/ | ||
- | At some point, you'll also want to change your postgres password (postgres user, not system user). Make sure to save it since you'll need it later in the install. | ||
- | bash# su postgres | ||
- | bash# bin/psql | ||
- | bash# alter user postgres password 'my password'; |
installing_postgresql.1179758857.txt.gz · Last modified: 2022/02/10 13:33 (external edit)