Hello
I am new in the field of Database Management. Most of times i worked with
Software development and Database Design.
I need some advice regarding database management.
I have three Database (DB) servers at different locations. suppose A, B and
C as three servers. where as Z is a central server
Shakeel, this can be done using symmetricDS.
cheers
//Sandeep
--- On Wed, 4/11/09, ABBAS SHAKEEL wrote:
> From: ABBAS SHAKEEL
> Subject: [ADMIN] Syncronizing Databases at different Remote Location
> To: pgsql-admin@postgresql.org
> Date: Wednesday, 4 November, 2009, 3:48 PM
> HelloI am new
Thanks Sandeep I will have a look to it and will inform you about success or
failure.
On Wed, Nov 4, 2009 at 4:03 PM, sandeep kumar wrote:
> Shakeel, this can be done using symmetricDS.
>
> cheers
> //Sandeep
>
>
>
>
> --- On Wed, 4/11/09, ABBAS SHAKEEL wrote:
>
> > From: ABBAS SHAKEEL
> > Sub
> Vladimir Rusinov wrote:
> > We are having a lot of ' in transaction' processes in
> production
> > database. This does not seems to be big problem now, since they are
> not
> > taking any big locks. But I'm aware that sometime it can become a
This *is* a big problem since your application is
Hello,
I guess you a bit lucky here. I worked on exactly the same problem for a
requirement in my project. And i've winded it up just today. I'm using
Java for my application, but i'm doing this particular task outside Java,
using shell directly. (It is a 3-line shell script) And then call thi
Is there a way to find out "which of the 1000 relations" that msx_fsm
will be kept track for. (I am using the default..and vacuumdb
suggested increasing max_fsm_relations)
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql
Thanks Shurti That looks cool I will inform you also shortly about success
or success :)
On Wed, Nov 4, 2009 at 8:03 PM, Shruthi A wrote:
> Hello,
>
> I guess you a bit lucky here. I worked on exactly the same problem for a
> requirement in my project. And i've winded it up just today. I'm us
Hi PGadmin list,
I would like to know how can I overwrite the existing permission( on a
default table space) defined in postgresql. cfg with :"set
default_tablespace =x" for a user, trying : "revoke all on tablespace
x from user" doesn't seems to help , the session level "set default ..."
If I were to use autovacuum on 8.1 , and If I specify the "ignore'
tables in pg_autovacuum,
1. will the XID wraparound counter be reset after autovacuum finishes
2. If some of the ignore tables are never dropped or deleted in the
future...how do the transaction semantics work with the rows in thes
Anj Adu escribió:
> If I were to use autovacuum on 8.1 , and If I specify the "ignore'
> tables in pg_autovacuum,
>
> 1. will the XID wraparound counter be reset after autovacuum finishes
No.
I think you really need to get off 8.1.
--
Alvaro Herrerahttp://www.Co
Thanks..i will stick to vacuumdb in 8.1 (which works fine..just takes
a couple of days to finish)
Migration is an option..but our databases are enormous..(> 800G) and
we have several of them
On Wed, Nov 4, 2009 at 12:00 PM, Alvaro Herrera
wrote:
> Anj Adu escribió:
>> If I were to use autovacuum
11 matches
Mail list logo
