Task #6425 (closed)
VM: Spin out postgres setup into its own script
| Reported by: | szwells | Owned by: | szwells |
|---|---|---|---|
| Priority: | minor | Milestone: | OMERO-Beta4.3.2 |
| Component: | General | Version: | n.a. |
| Keywords: | n.a. | Cc: | |
| Resources: | n.a. | Referenced By: | n.a. |
| References: | n.a. | Remaining Time: | 0.0d |
| Sprint: | 2011-08-18 (3) |
Description
To partially satisfy #6370, a postgres setup script should be added that sets up the postgres server & databases ready for OMERO,e.g.
export PGPASSWORD=omero
FILE=.pgpass
sudo -u omero cat > ${FILE} << EOF
localhost:5432:omero:omero:omero
EOF
chmod 600 .pgpass
echo "CREATE USER omero PASSWORD 'omero'" | sudo -u postgres psql
sudo -u postgres createdb -O omero omero
sudo -u postgres createlang plpgsql omero
echo `psql -h localhost -U omero -l`
sudo sed '/127.0.0.1/s/md5/trust/' /etc/postgresql/8.4/main/pg_hba.conf >
pg_hba.conf && sudo mv pg_hba.conf /etc/postgresql/8.4/main/pg_hba.conf
sudo /etc/init.d/postgresql restart
echo `netstat -an | egrep '5432.*LISTEN'`
The corresponding entries in setup_userspace should be removed.
Change History (2)
comment:1 Changed 8 years ago by Simon Wells <szwells@…>
- Remaining Time set to 0
- Resolution set to fixed
- Status changed from new to closed
comment:2 Changed 8 years ago by szwells
- Milestone changed from Unscheduled to OMERO-Beta4.3.2
- Sprint set to 2011-08-18 (3)
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
(In [055591b7a6f48bfe540e9ba1977bffa8557efc2a/ome.git] on branch develop) Created setup_postgres.sh to increase modularity of the scripts & removed corresponding code from setup_userspace.sh (Fix #6425)