Re: [ADMIN] Database size, and table size

2005-10-21 Thread hubert depesz lubaczewski
On 10/22/05, Roger Strandberg / Hamsta <[EMAIL PROTECTED]> wrote: I wondering about file size of a table. dont wonder :) install dbsize module from postgresql contrib, and check. depesz

[ADMIN] Database size, and table size

2005-10-21 Thread Roger Strandberg / Hamsta
Hi.   I wondering about file size of a table.   The table has 43000 pages and in documentation is say's its around 8kb. It makes it supose to be around 336Mb on disk. The table is simple just: org_no varchar (12) Name varachar(225)   But when i create a tablespace on a mfs disk and just load

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Kirby Ubben
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Browne wrote: >[EMAIL PROTECTED] ("Joshua D. Drake") writes: > >>>You are looking for synchronous replication as opposed to async? >>> Currently i have Slony working, but am not satisfied with how it accomplishes replication, or it's in

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Chris Browne
[EMAIL PROTECTED] ("Joshua D. Drake") writes: >> You are looking for synchronous replication as opposed to async? >> >> >Currently i have Slony working, but am not satisfied with how it >> >accomplishes replication, or it's interface, and am curious what >> >others are using to accomplish replicat

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Joshua D. Drake
> You are looking for synchronous replication as opposed to async? > > >Currently i have Slony working, but am not satisfied with how it > >accomplishes replication, or it's interface, and am curious what > >others are using to accomplish replication? There is also Mammoth Replicator: http://ww

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Chris Travers
Kirby Ubben wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have installed a product called Quasar for accounting needs at our company, which is back ended by PostgreSQL. It is a requirement that the database is replicated, real time, to a secondary machine and PostgreSQL database, in

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Andrew Sullivan
On Fri, Oct 21, 2005 at 11:28:36AM -0500, Kirby Ubben wrote: > Currently i have Slony working, but am not satisfied with how it > accomplishes replication, or it's interface, and am curious what > others are using to accomplish replication? What do you find unsatisfactory (or, for that matter, dis

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Jim C. Nasby
Unfortunately, the only syncronous replication I know of is http://pgfoundry.org/projects/pgcluster/, which is statement-based. That means it's got some substantial drawbacks... On Fri, Oct 21, 2005 at 11:28:36AM -0500, Kirby Ubben wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > >

[ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Kirby Ubben
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have installed a product called Quasar for accounting needs at our company, which is back ended by PostgreSQL. It is a requirement that the database is replicated, real time, to a secondary machine and PostgreSQL database, in case of failure of th

Re: [ADMIN] Integration PostgreSQL with Oracle.

2005-10-21 Thread Goulet, Dick
Alfredo,       Well I'm no Java guru by any stretch of the imagination..  One possibility would be to go to http://www.oracle.com/technology//index.html.  There's a Java developers mailing list, similar to this one, that can help you and a discussion forum. From: Alfredo Rico [mailto:[EMAI

Re: [ADMIN] copy command

2005-10-21 Thread Hannes Dorbath
On 21.10.2005 01:05, Sidar López Cruz wrote: how to copy data from file with fixed columns width to postgresql table? About 3-4 lines in your favorite scripting language should do. Besides this many frontends can do, EMS PG Manager being one of them. -- Regards, Hannes Dorbath