Re: [GENERAL] Database restoration performance issue on PostgreSQL 7.4.7

2006-04-03 Thread Leon Pu
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Leon Pu <[EMAIL PROTECTED]> writes: > > the database restoration on my PosgreSQL 7.4.7 Linux installation > is > > terribly poor. It takes more than one and half hour to restore a > 61M > > restored database. &g

[GENERAL] Database restoration performance issue on PostgreSQL 7.4.7

2006-04-03 Thread Leon Pu
Hi all, the database restoration on my PosgreSQL 7.4.7 Linux installation is terribly poor. It takes more than one and half hour to restore a 61M restored database. Here are my commands to backup and restore. - backup: pg_dump -d $DB_NAME > db.bak - restore: psql -d $DB_NAME < db.bak Is the pro

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

2006-03-27 Thread Leon Pu
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote: > > Hi, > > > > On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote: > > > I'd hope that RH would support at least the > > > most recent version of 7.4, since presumably that's part of

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

2006-03-24 Thread Leon Pu
--- Tom Lane <[EMAIL PROTECTED]> wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > No there is not. I actually suggest, considering your ancient > version of > > RedHat that you install from source. > > Better yet, install a more modern Red Hat release ;-) > > AS2.1 is very far into th

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

2006-03-24 Thread Leon Pu
--- Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: > Hi, > > On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote: > > > I found the newest PostgreSQL binary download on Redhat Advance > Server > > 2.1 is version 7.4.7. > > > > > http://www.postgresql.o

[GENERAL] PostgreSQL support on Redhat Advance Server 2.1

2006-03-24 Thread Leon Pu
Hi all, I found the newest PostgreSQL binary download on Redhat Advance Server 2.1 is version 7.4.7. http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/ But I want to install newer PostgreSQL in Redhat Advance Server 2.1, at least version 8.0.4. Any possibility to install 8