stopping access to a database

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: stopping access to a database
Date: 2003-01-28 16:50:03
Message-ID: PL54ZWTRID64QP95PKD952WTXWQLRLRM.3e36b4bb@cal-lab
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I configuring 2 databases:

1/ One be on a https server, and all important data will be encrypted. The only use this
database will see are:
A/ Updates 2-3 times a day, max.
B/ Exporting a smaller set of 'unnormalized' tables for the database below.
2/ A publically accessible, (through PHP applications), database that has less secure data
on it and is not encrypted.

I would like to stop accesses to database 2, delete all records in the 2-4 tables, and reimport
new records. How would I do this as a user on the system, not as an admin?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-01-28 16:53:52 Re: Ref to last INSERT on a table without OIDs?
Previous Message jhihn1 2003-01-28 16:38:43 Re: Using RSYNC for replication?