| From: | Pablo Varasa <pvarasa(at)prisacom(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | db "hot switch" |
| Date: | 2003-02-14 11:39:06 |
| Message-ID: | 20030214123112.042B.PVARASA@prisacom.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I want to actualize my postgresql version stopping the server
the minimum time possible. I was thinking in turn the database to
read-only state (selects will work normally), make a dump, restore the
dump in the new installation and stop the server only the time needed to
stop old postmaster and load the new one. The problem is that i don't
know how to set readonly state. In mysql for example i left only select
privilege on all users (first i backup users), but in pgsql i can't
revoke or grant privileges to all users on *all databases* easily and i
don't know how to backup only users without a pg_dumpall.
¿Any suggestions? Thnx in advance
----------------------------
Pablo Varasa Paredes
Dept. de sistemas
Prisacom - Grupo Prisa
mailto:pvarasa(at)prisacom(dot)com
C/ Ribera del Sena s/n 28042 MADRID
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mohd Ghalib Akhtar | 2003-02-14 11:39:49 | how to restore SQL Dump |
| Previous Message | Ken Guest | 2003-02-14 11:20:33 | Re: uppercase = lowercase |