Re: [GENERAL] Users functions library

2008-07-13 Thread Karsten Hilbert
On Sat, Jul 12, 2008 at 11:14:27PM -0300, Alejandro D. Burne wrote: Hi, I need to write a function that gives me a password string, no just a numbers-characters string; something like people wrote in php, its based on determined syllables and numbers. I think it be useful to other people, is

Re: [GENERAL] Users functions library

2008-07-13 Thread Alejandro D. Burne
2008/7/13 Pavel Stehule [EMAIL PROTECTED]: Hello safe it to pgfoundry http://pgfoundry.org/ regards Pavel Stehule May be to much for including in pgfoundry, I think to build a place to share code developed in postgres functions (plpgsql, plpython, etc) and to categorize them. I can help to

Re: [GENERAL] Users functions library

2008-07-13 Thread Pavel Stehule
2008/7/13 Alejandro D. Burne [EMAIL PROTECTED]: 2008/7/13 Pavel Stehule [EMAIL PROTECTED]: Hello safe it to pgfoundry http://pgfoundry.org/ regards Pavel Stehule May be to much for including in pgfoundry, I think to build a place to share code developed in postgres functions (plpgsql,

[GENERAL] Reminder - PDXPUG Day

2008-07-13 Thread gabrielle
OSCON and PDXPUG Day are just one week away! PDXPUG Day scheduled speakers: http://pugs.postgresql.org/view/pdxpugtalksview Sign up here: http://spreadsheets.google.com/viewform?key=paoTJ9uEi8vIqumUzwzrCAwemail=true Please sign up for free admission to the after-party at the Gotham Tavern, and

[GENERAL] Pg booth staffing at OSCON

2008-07-13 Thread gabrielle
OSCON is fast approaching - just one more week! I need some people to help out with booth staffing for Thursday. Sign up here: http://wiki.postgresql.org/wiki/Oscon_2008_signup Staffing the booth is a ton o' fun and a great way to meet people! Thank you! gabrielle PS: Michael - what kind of

[GENERAL] REQUIREMENTS FOR POSTGRESQL DATABASE

2008-07-13 Thread aravind chandu
Hello, I just need the information related to the requirements of postgresql database like how much size it occupies on the disk (when it is installed) irrespective of tables size and how much RAM is needed for better performance of the database say, I have 4gb ram will it use

Re: [GENERAL] REQUIREMENTS FOR POSTGRESQL DATABASE

2008-07-13 Thread Danyelle Gragsone
In the future could you please refrain from using caps in your subject line. It looks like you are screaming. thx

Re: [GENERAL] Default fill factor for tables?

2008-07-13 Thread Pavan Deolasee
On Sat, Jul 12, 2008 at 2:25 AM, Roberts, Jon [EMAIL PROTECTED] wrote: -- I can find very little information on hot updates but I found this: http://archives.postgresql.org/pgsql-patches/2006-11/msg00059.php It states, This design optimizies the updates when none of the index columns are

[GENERAL] Restoring Database from Data directory backup.

2008-07-13 Thread J Ottery
Using XP Pro and Postgres 8.3 I made a backup of the Data directory of the Postgres Installation to another place on the hard disk. Now the customer has uninstalled postgres then reinstalled a new one. Of course the original tables are all gone. Is there a method of retrieving the original tables

Re: [GENERAL] Restoring Database from Data directory backup.

2008-07-13 Thread J Ottery
On Jul 14, 12:57 pm, J Ottery [EMAIL PROTECTED] wrote: Using XP Pro and Postgres 8.3 I made a backup of the Data directory of the Postgres Installation to another place on the hard disk. Now the customer has uninstalled postgres then reinstalled a new one. Of course the original tables are

Re: [GENERAL] [pgsql-advocacy] Pg booth staffing at OSCON

2008-07-13 Thread Michael Alan Brewer
On Sun, Jul 13, 2008 at 7:31 PM, gabrielle [EMAIL PROTECTED] wrote: PS: Michael - what kind of balloons should I provide for you? :) I'll be bringing my own, thanks. ;) Looking forward to seeing y'all at OSCON! :) ---Michael Brewer [EMAIL PROTECTED] -- Sent via pgsql-general mailing list

Re: [GENERAL] Requirements For Postgresql Database

2008-07-13 Thread Shane Ambler
aravind chandu wrote: Hello, I just need the information related to the requirements of postgresql database like how much size it occupies on the disk (when it is installed) irrespective of tables size and how much RAM is needed for better performance of the database say, I have 4gb ram will

Re: [GENERAL] Restoring Database from Data directory backup.

2008-07-13 Thread Klint Gore
J Ottery wrote: Using XP Pro and Postgres 8.3 I made a backup of the Data directory of the Postgres Installation to another place on the hard disk. Now the customer has uninstalled postgres then reinstalled a new one. Of course the original tables are all gone. Is there a method of retrieving

Re: [GENERAL] Top N within groups?

2008-07-13 Thread Klint Gore
Martijn van Oosterhout wrote: On Fri, Jul 11, 2008 at 01:24:28PM +1000, Klint Gore wrote: [thinking out loud] Can someone familiar with the source for DISTINCT ON comment on how hard it would be to add another parameter to return more than one row? From a programming point of view, it