db "hot switch"

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

Responses

Browse pgsql-general by date

  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