Re: [ADMIN] database clustering

2004-06-05 Thread Joe Maldonado
I have looked at this and this is not what I was looking for. Using this the application will need to figure out how to merge records. I was looking to be able to use something like the oracle syntax of host:database:schema:table within sql to service the queries. -Joe On Fri, 20 Feb 2004 14:4

Re: [ADMIN] PosgreSQL hogging resources?

2004-06-05 Thread Jeremy Smith
Mitch, One of the issues with my site is that many of the pages use iframes, so I am actually loading up to 7 pages of varying database hungriness into the browser at the same time. I agree that pg with the triggers and procedures should be able to adequately compete with mysql in terms of speed.

[ADMIN] PL/pgSQL instalLation problem ??

2004-06-05 Thread GP
Hi All, I am trying to run the tutorial examples concerning the "Implementation of views in PostgreSQL" but I have some problems with the PL/pgSQL language installation.. The corresponding library is located in /usr/local/pgsql/lib/plpgsql.so and I set the PGLIB enviroment variable to /usr/local

[ADMIN] WAL logs and segment files

2004-06-05 Thread Eduardo Leva
Hi, guys... I'm reading the version 7.3.4 documentation and I found this: " "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment files, each 16 MB in size. Each segment is divided into 8 kB pages. The log record headers are described in access/xlog.h; record content is

[ADMIN] problems with regressive tests on rh8.0

2004-06-05 Thread www.mg.te.ua
I have linux box under redhat linux 8.0 with original kernel 2.4.20 On this box I successfully build postgresql 7.3.4 After upgrading kernel to 2.4.24 i deside to upgrade postgresql. I've successfully built 7.4.1 was build without any difficulties, but fail all of regressive test I try to build

Re: [ADMIN] Howto/wherefrom win98 install [ref:ppg]

2004-06-05 Thread Paul Gimpelj
I was wanting the postmaster itself, but cannot see any distros. so, looks like I need cygwin. thanks. - Original Message - From: "Jim Seymour" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 05, 2004 8:03 AM Subject: Re: [ADMIN] Howto/wherefrom win98 install [ref:ppg]

Re: [ADMIN] Howto/wherefrom win98 install [ref:ppg]

2004-06-05 Thread Jim Seymour
"Paul Gimpelj" <[EMAIL PROTECTED]> wrote: > > Hi, > > I searched the postgresql.org site but I don't understand how to get a > postmaster running on windows 98/2000. > > Can someone please give some pointers here. [snip] Did you find http://www.postgresql.org Docs PostgreSQL 7.4

Re: [ADMIN] E-R Tool

2004-06-05 Thread Miguel González Castaños
Hello, Db-designer is a nice tool, can work with importing Oracle databases, and use it with PG and MySQL. Hope this helps BR, Miguel Can someone suggest an E-R tool that will read a _PG_ database and create an E-R diagram - crows feet and all? Are there any that are available for free? Thanks