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 po
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 s
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)
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
Ok-- again subscribed to hackers till your questions answered.
I think you missed some of the documentation. On the first page, click on
documentation, on that (intro) page, click on 'how it works'... it will tell
you about primary keys.
Use this script to make a test table
CREATE TABLE te
Couldnt find a replication system that worked and did what I wanted, so I made
one.
If you would like to give my humble creation a try...
http://spar.orgfree.com/index.html
Its working for me oh yes... its free... naturally :)
Regards
Johnny
Couldnt find a replication system that worked and did what I wanted, so I made
one.
If you would like to give my humble creation a try...
http://spar.orgfree.com/index.html
Regards
Johnny
