Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

BlackBerry Wireless Handheld) - Original Message - From: Brian Modra epai...@googlemail.com To: Su, Alan Cc: pgsql-admin@postgresql.org pgsql-admin@postgresql.org Sent: Wed Dec 16 02:43:46 2009 Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool 2009/12/15 Su, Alan

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

you need any sort of GUI front end to the application? Or is it just reporting via email? -Original Message- From: Brian Modra [mailto:epai...@googlemail.com] Sent: Friday, December 11, 2009 3:09 PM To: Su, Alan Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Looking for Good

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

/report_disclosure.html If your settings do not permit you to access this link directly, please use your internet browser to visit this website address. -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South

Re: [ADMIN] encoding shp2pgsql/ client encoding

anybody help me? Thanks. Regards MisterX -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org

Re: [ADMIN] Just wanted to say thanks for a great tool

Manager/Software Architect/DBA Web Services at Public Affairs 217-333-0382 -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ -- Sent via pgsql-admin

Re: [ADMIN] Need help in enabling remote connection

./pg_ctl -D data_folder reload This doesn't work.  What else should i do to make remote connection work? I'm lost!  Please help! Thanks a lot, Shruthi -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince

Re: [ADMIN] Urgent Help required

and dumping just that table? What does \d {table name} tell you? What does ps -ef|grep post show? Although the log looks like it is restarting itself, have you tried shutting down the database (and restarting it)? Many Thanks Neha. -- Brian Modra Land line: +27 23 5411 462 Mobile: +27

[ADMIN] server disk space

your help. Thanks Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] server disk space

...@consistentstate.com: On Sunday 06 September 2009 00:05:04 Brian Modra wrote: Hi, I'm maintaining a fairly large online database, and am trying to free up disk space. Its got to 98% full. I am certain that the postgresql data files are responsible for more than 97% of this partition's usage. The WAL

Re: [ADMIN] RAID for the DB filesystem

-10 than fewer SAS drives in a RAID-5. if someone is worried about wasting disk space tell them to worry about something else, like losing data. -- Brian Modra   Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South

Re: [ADMIN] RAID for the DB filesystem

-10 than fewer SAS drives in a RAID-5. if someone is worried about wasting disk space tell them to worry about something else, like losing data. -- Brian Modra   Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South

[ADMIN] RAID for the DB filesystem

Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

[ADMIN] large cache

considering configuring a large cache, requiring larger than 16GB, and allowing it to spill over into swap space on a single 300GB SAS drive. Is this a good idea? Thanks Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box

[ADMIN] Fwd: large cache

considering configuring a large cache, requiring larger than 16GB, and allowing it to spill over into swap space on a single 300GB SAS drive. Is this a good idea? Thanks Brian -- Brian Modra   Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2

Re: [ADMIN] Problem with GeomFromText('POINT(...

solution please. Thank you. Discover the new Windows Vista Learn more! -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 183 8059 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa -- Sent via pgsql-admin

[ADMIN] WAL backups

want to be able to do historical recoveries to any point in time if necessary. I'm interested to hear from other's about hardware for backup. I'm thinking of a second dedicated server offsite (near me), with a large, large disk. Thanks. Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27

Re: [ADMIN] how to create cluster(loadbanacing) of postgresql server

by *MailScanner* http://www.mailscanner.info/, and is believed to be clean. -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 183 8059 6 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa

Re: [ADMIN] Backup of live database

integrity, so even a WAL restore won't help because the base files themselves are corrupt in the tar file? On 16/01/2008, Joshua D. Drake [EMAIL PROTECTED] wrote: Brian Modra wrote: The documentation about WAL says that you can start a live backup, as long as you use WAL backup also. I'm

[ADMIN] Backup of live database

Hi, If tar reports that a file was modified while it was being archived, does that mean that the file was archived correctly, or is it corrupted in the archive? Does tar take a snapshot of the file so that even if it is modified, at least the archive is safe? Thanks -- Brian Modra Land line

Re: [ADMIN] Backup of live database

The documentation about WAL says that you can start a live backup, as long as you use WAL backup also. I'm concerned about the integrity of the tar file. Can someone help me with that? On 16/01/2008, Joshua D. Drake [EMAIL PROTECTED] wrote: Brian Modra wrote: Hi, If tar reports that a file

[ADMIN] Vacuum taking an age

taking the service offline early on Sunday morning... thanks in advance Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 183 8059 6 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa ---(end of broadcast

Re: [ADMIN] Vacuum taking an age

really need to.) On 04/01/2008, Scott Marlowe [EMAIL PROTECTED] wrote: On Jan 3, 2008 6:48 AM, Brian Modra [EMAIL PROTECTED] wrote: Hi, I have a pretty live table: rows being inserted and updated more than once 1 per second, though far, far more inserts than updates. There are currently