Re: [ADMIN] Indexes on Large Tables

2003-02-07 Thread Donald Fraser
- Original Message - From: "Curt Sampson" <[EMAIL PROTECTED]> To: "Donny Drummonds" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 5:13 AM Subject: Re: [ADMIN] Indexes on Large Tables > On Mon, 3 Feb 2003, Donny Drummonds wrote: > > > If I do not index the co

Re: [ADMIN] incremental backup of postgres database?

2003-02-07 Thread Gary Stainburn
On Friday 07 Feb 2003 4:05 pm, Palle Girgensohn wrote: > Hi! > > What would be the best suggestion for incremental backup of a rather large > database, where the bulk data volume consists of large objects. Since > backup will be transmitted over a 2 Mbit/s internet line, we need to > minimize the d

Re: [ADMIN] incremental backup of postgres database?

2003-02-07 Thread Palle Girgensohn
--On fredag, februari 07, 2003 16.49.38 + Gary Stainburn <[EMAIL PROTECTED]> wrote: On Friday 07 Feb 2003 4:05 pm, Palle Girgensohn wrote: Hi! What would be the best suggestion for incremental backup of a rather large database, where the bulk data volume consists of large objects. Since bac

[ADMIN] pg_proc and pg_triggers

2003-02-07 Thread Yudha Setiawan
  Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] pg_proc - pg_triggers

2003-02-07 Thread Yudha Setiawan
Dear Master,   As Developer we've been developing a simple tools for PostgreSQL under Windows, Just helping on Daily operation for our "IT-Operation Dept.". Someday I'll share that's tools for milist, i promise. But know we need to know how could we connecting two tables, between pg_proc an

Re: [ADMIN] Sql Management Tool to download

2003-02-07 Thread Jyry Kuukkanen
I have used phpPgAdmin and have been pretty much happy with it. http://phppgadmin.sourceforge.net/ --jq On Wed, 5 Feb 2003 [EMAIL PROTECTED] wrote: > Hi, > > We are using postgresql for linux for the past 1 and half yr. > Our database gets increasing in no. of tables, datas ...etc. > We wa

Re: [ADMIN] Problem installing Postgresql 7.3.1 on RedHat 8.0

2003-02-07 Thread Rajesh Kumar Mallah
installing from pgsql 7.3.2 tarball is not that difficult. regds mallah. On Wednesday 05 February 2003 05:41 am, Sales wrote: > Hi , > > While installing Postgres-libs- 7.3.1 binaries on RedHat 8.0 , I get a > dependency problem. RPM reports dependency error postgresql-libs=7.2.2 > requi

Re: [ADMIN] Vacuum full hang => strace

2003-02-07 Thread Rajesh Kumar Mallah
sorry gaetano, i am not knowledgable enough to help you in this situation anymore. regds mallah. On Monday 03 February 2003 03:07 pm, Gaetano Mendola wrote: > <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > are u sure VACUUM FULL is hanging? > > > > r

Re: [ADMIN] pg_proc - pg_triggers

2003-02-07 Thread Stephan Szabo
On Fri, 7 Feb 2003, Yudha Setiawan wrote: > As Developer we've been developing a simple tools > for PostgreSQL under Windows, Just helping on Daily operation for our > "IT-Operation Dept.". Someday I'll share that's tools for milist, i > promise. But know we need to know how could we connecting tw

[ADMIN] incremental backup of postgres database?

2003-02-07 Thread Palle Girgensohn
Hi! What would be the best suggestion for incremental backup of a rather large database, where the bulk data volume consists of large objects. Since backup will be transmitted over a 2 Mbit/s internet line, we need to minimize the data flow for each nightly backup. The compressed database dump

[ADMIN] incremental backup of postgres database?

2003-02-07 Thread Palle Girgensohn
Hi! What would be the best suggestion for incremental backup of a rather large database, where the bulk data volume consists of large objects. Since backup will be transmitted over a 2 Mbit/s internet line, we need to minimize the data flow for each nightly backup. The compressed database dump

[ADMIN] noatime.

2003-02-07 Thread Leslie
Hi All , This is my first post to the list. We are wondering if any of you have successfully implemented the setting of the "noatime" attribute on an ext2 filesystem. Specifically to (try) reduce disk I/O on Postgres database files. We are looking to implement this on a server running postgres w

Re: [ADMIN] Sql Management Tool to download

2003-02-07 Thread Jerry Asher
Robert Treat wrote: http://techdocs.postgresql.org/oresources.php look under Administration Tools and ERD tools. Another tool to consider is rhdb-admin -- it's a nice x-windows utility that comes from redhat for rhdb. In fact, near as I can tell, rhdb is pg with a few patches and with rhdb

Re: [ADMIN] Problem installing Postgresql 7.3.1 on RedHat 8.0

2003-02-07 Thread Lamar Owen
On Friday 07 February 2003 09:13, Rajesh Kumar Mallah wrote: > installing from pgsql 7.3.2 tarball is not that difficult. There are other things at work here; in any case, this does not answer his question. He wants an answer to his RPM question. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [ADMIN] Problem installing Postgresql 7.3.1 on RedHat 8.0

2003-02-07 Thread Lamar Owen
On Tuesday 04 February 2003 19:11, Sales wrote: > While installing Postgres-libs- 7.3.1 binaries on RedHat 8.0 , I get a > dependency problem. RPM reports dependency error postgresql-libs=7.2.2 > required . Which package did RPM say required it? -- Lamar Owen WGCR Internet Radio 1 Peter 4:

[ADMIN] PostgreSQL 7.2 + PAM = authentication failure?

2003-02-07 Thread Charles Hornberger
Hello -- I'm trying to get PostgreSQL to use PAM for authentication and hitting a big, blank brick wall. I'd appreciate any advice anyone can give. (What I'm trying to accomplish is to allow regular users to connect to the database server from elsewhere on the network using their existing system p