Good memory you have and you exactly right.
Yes... the replication is using posgres's normal transactions ie 2 phase
commits and it works like a dream.
When moving data during replication, the locks are happening at record
level, and its intrinsic to the postgres transaction machinery.
ie
Ha ha... thx Tino
Yes, I think this is way to go, strange how my mind climbs the wrong tree
sometimes :)
I actually need to aquire a transaction across several dB's, check if the
conditions are right, and then modify some tables, write and remove some
triggers.
Transactions in postgres are 2
Hi,
[EMAIL PROTECTED] wrote:
Ha ha... thx Tino
Yes, I think this is way to go, strange how my mind climbs the wrong
tree sometimes :)
I actually need to aquire a transaction across several dB's, check if
the conditions are right, and then modify some tables, write and remove
some triggers.
Thx Russel,
I want to control it from software, changing network access via pg_hba with
software doesnt feel right.
possible case
Say I have a Group called Normal_Rights and one called Zero_Rights.
So dB runs as... Normal_Rights(User A, User B, User C, User D)
[EMAIL PROTECTED] schrieb:
Thx Russel,
I want to control it from software, changing network access via pg_hba
with software doesnt feel right.
possible case
Say I have a Group called Normal_Rights and one called Zero_Rights.
So dB runs as...
Hi there,
Is is possible to stop all user access to postgres, but still give access to
admin?
Just temporarily, not a security setup.
Something like, stop all users but allow user x and y.
thx
---(end of broadcast)---
TIP 5: don't forget to
[EMAIL PROTECTED] wrote:
Hi there,
Is is possible to stop all user access to postgres, but still give
access to admin?
Just temporarily, not a security setup.
Something like, stop all users but allow user x and y.
You could restart in single user mode, or alter pg_hba.conf to allow the
Am Montag, 22. Januar 2007 10:32 schrieb [EMAIL PROTECTED]:
Is is possible to stop all user access to postgres, but still give access
to admin?
Make the appropriate adjustments to pg_hba.conf.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
