[GENERAL] Restoring just a table or row from a backup copy.

2005-09-16 Thread Fernando Lujan
Is there a way to do that? Thanks in advance. Fernando Lujan ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Generating random values.

2005-08-18 Thread Fernando Lujan
ere's no problems with passwords which a user could remember. At least, the user will not trouble you with a password reset requirement. :D Thanks for all replies and suggestions. Fernando Lujan ---(end of broadcast)--- TIP 1: if posting/readi

Re: [despammed] [GENERAL] Generating random values.

2005-08-17 Thread Fernando Lujan
On 8/17/05, A. Kretschmer <[EMAIL PROTECTED]> wrote: > select substring(md5(random()) from 5 for 15); Thanks everybody, this solution will fullfill my needs... ;) Sincerely, Fernando Lujan ---(end of broadcast)--- TIP 9: In versions

[GENERAL] Generating random values.

2005-08-17 Thread Fernando Lujan
Hi folks, I have a table wich contains my users... I want to insert to each user a random password, so I need a random function. Is there such function in Postgres? I just found the RANDOM which generates values between 0.0 and 1.0. Any help or suggestion will be appreciated. :) Fernando Lujan

[GENERAL] Pg_autovaccum.

2005-07-28 Thread Fernando Lujan
Hi everyone, Which is the best configuration to pg_autovaccum? Are there benchmarks showing the improvements, after and before the service had started? Thanks in advance. -- Fernando Lujan ---(end of broadcast)--- TIP 9: In versions below 8.0

[GENERAL] Vaccum analyze.

2005-03-18 Thread Fernando Lujan
Hi folks, I wanna know from you, how often must I run vaccum analyze on my db? Once per day, twice... One per hour and so on... I didn't find a especific document about this question. Thanks in advance. Fernando Lujan ---(end of broadcast)---