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: | Raw Message | Whole Thread | 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 |