Re: [GENERAL] how to clear server log

[Amy Smith]

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 -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] how to clear server log

[Amy Smith]

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

[Amy Smith]

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

[Amy Smith]

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

[Amy Smith]

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

[GENERAL] postgres

[Amy Smith]

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

thanks

[GENERAL] PSQL COMMAND LINE

[Amy Smith]

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

[Amy Smith]

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

thanks
Amy

[GENERAL] postgres issue

[Amy Smith]

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
database ?

How to use mount for differnt region.

any help is appreciate.


Amy