Re: [GENERAL] how to clear server log

this is the server log file, how many days server log files need to be keep as a mimumum ? thanks On Tue, Feb 23, 2010 at 1:49 PM, Amy Smith vah...@gmail.com wrote: All do you clean up the server file by removing them use find $logfile -mtime +$NUMBER_DAYS_TO_KEEP -type f -print -exec rm

[GENERAL] how to clear server log

All do you clean up the server file by removing them use find $logfile -mtime +$NUMBER_DAYS_TO_KEEP -type f -print -exec rm -f {} \; in postgres ? How to remove the archive log files in postgres ? is the same way as remove backup files and server log files ? thanks Amy

[GENERAL] postgres

All how to get rid of the postmaster that is still running, but I deleted the $PGDATA cluster file, so it can not stop it. but I can not use the port again for new cluster. PLEASAE HELP. Amy

[GENERAL] port question

I have installed a v8.4 and first port using localhost is ok. but the second one using different port will get error when connect using IP address. Is that only one port is allowed for one server ? please help - need expert's advice. thanks Amy

[GENERAL] postgres external table

all is there a external table create method ( similar to oracle external table ) ? where to find the information ? thanks Amy

[GENERAL] postgres

all how to set up PGTAB file ? any example for PGTAB=/opt/postgres/utilities/conf/pgtab thanks

[GENERAL] PSQL COMMAND LINE

all when type \i c:\test.sqI - an error occurred - no permission on file, but I have read/write access in c:\ any idea ? Amy

[GENERAL] postgres

all Any kind of parameter in solaris root section need to be checked before install postgres in Solaris thanks Amy

[GENERAL] postgres issue

all For dba, do you create a dba user and grant all privilege to 'dba user', so you can create table, etc ? For a team, do you create user for all team member and tie to a group ? Not sure the set up for postgres also what is best way to create a production and test region using the same