Title: RE: [ADMIN] PostgreSQL 8.1.4 - INITDB - database postgres ?
I agree with Michael, I would leave the postgres DB in place. I currently run 8.0.1 which does not create the postgres DB automatically and make a point to create it to use as my "maintenance" DB for such things as pgAdmin con
8.0.1, I keep trying to push the vendor but as of yet to no avail.
Thanks again to Thomas and Jim for your replies.
Tim
-Original Message-
From: Jim Nasby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2006 1:05 PM
To: mcelroy, tim
Cc: 'Thomas Mack'; &#x
hanks,
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Thomas Mack
Sent: Tuesday, August 08, 2006 7:54 AM
To: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Start-up script for Solaris
Am Dienstag, 8. August 2006 13:27 schrieb
Title: Start-up script for Solaris
Good morning,
Curious if anyone out there has a start-up script for Solaris? A version of the Linux /etc/init.d/postgresql one. I recently installed postgres on a Solaris 9 box and although I can start up postgres it fails to log to the log file as directe
Title: RE: [ADMIN] growth of a postgresql database
The contrib/dbsize module will accomplish what you want. I use release 8.0.1 and it works for me.
It provides the size of the DB, you could cron a job to take readings at various times and calculate the growth that way.
Tim
-Orig
Title: RE: [ADMIN] Restore of pg_dump taking a long time...
I have found that the following steps have increased the speed of my restores:
1. dropdb
2. createdb
3. Increase maintenance_work_mem as Tom mentioned. I do this at restore/runtime
4. Increase work_mem as Tom mentioned. I do this
Title: Fatal: 2149478 (UNCLASSIFIED)
Not sure
what type of system you are running postgres on but that error may mean that
you have to bump up the SHMMAX setting in the kernel. In Linux it is set in the file /etc/sysctl.conf and in UNIX
it is set in the file /etc/system. I know in Linux y
Title: RE: [ADMIN] backups
Thanks Scott, great idea. Does one use pg_restore to restore the files that pg_dumpall creates?
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 3:35 PM
To: mcelroy, tim
Cc: 'Bruno Wolf
: Wednesday, May 10, 2006 3:12 PM
To: mcelroy, tim
Cc: 'Scott Marlowe'; 'pgsql-admin@postgresql.org'
Subject: Re: backups
On Wed, May 10, 2006 at 11:56:20 -0400,
"mcelroy, tim" <[EMAIL PROTECTED]> wrote:
> Thanks for the quick answer Sc
Title: RE: [ADMIN] backups
Great, exactly the answer I was looking for. Thank you again Scott.
Tim
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 12:12 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org
ng that to tape enough? I just don't want to get bit in the butt if I tell him to not back something up that should be backed up.
Tim
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 11:57 AM
To: mcelroy, tim
Cc: 'pgsql-admin@postgre
Title: dbsize & pg_dump
Greetings,
Does the
pg_dump command ‘backup’ the pg_xlog files?
Thank you,
Tim
Title: RE: [ADMIN] Regarding start postgresql startservice
I use the /etc/init.d/postgresql {start|stop|status|restart|condrestart|condstop|reload|force-reload} command on my Linux boxes and it works great.
I recently installed PG on a couple Solaris boxes and found that the install did no
Title: dbsize & pg_dump
Please
disregard this question. I’m using
pg_dump –F c which compresses the data a it backs it up.
Tim
-Original
Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of mcelroy, tim
Sent: Tuesday, April 25, 2006 4:40
PM
To: &#
Title: dbsize & pg_dump
Good afternoon,
Probably an easy question but why are the file sizes differ so much between these two tools?
For example:
A backup using pg_dump of our largest DB creates a file 384MB in size
Using the following SQL code utilizing dbsize I get the following:
FIX
Title: RE: [ADMIN] Postmaster errors
Great, thank you for the additional info.
Tim
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 02, 2006 1:05 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject:
Title: RE: [ADMIN] Postmaster errors
That was it, a fellow admin is watching the postmaster with OpenNMS
Thanks for the tip!
Tim
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 02, 2006 11:10 AM
To: mcelroy, tim
Cc
Title: Postmaster errors
Good morning,
Has anyone encountered these errors? They repeat every five (5) minutes in my log file. Is there something I may have set incorrectly in my postgresql.conf file? Odd as I find them in my DEV & QA logs but not Production
2006-02-02 10:52:33 EST US
Title: RE: [ADMIN] Kerberos 5 build error
Ok, thank you.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 27, 2006 3:39 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Kerberos 5 b
PROTECTED]]
Sent: Friday, January 27, 2006 2:54 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Kerberos 5 build error
"mcelroy, tim" <[EMAIL PROTECTED]> writes:
>> What platform is this, and where does it actually keep its
ibdir path set correctly.
Tim
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 27, 2006 2:17 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Kerberos 5 build error
"mcelroy, tim" <[
Title: Kerberos 5 build error
Greetings,
Has anyone run into this issue? I'm trying to configure PostgreSQL 8.01 in
order to retrofit the pgAdmin3 admin module. In my configure script I use
--with-krb5 and have also added the following upon reading other
suggestions: --with-libs=/usr/kerberos
Title: krb5_encrypt error
Greetings,
Has anyone run into this issue? I'm trying to configure PostgreSQL 8.01 in order to retrofit the pgAdmin3 admin module. In my configure script I use --with-krb5 and have also added the following upon reading other suggestions: --with-libs=/usr/kerberos/
23 matches
Mail list logo
