Re: [ADMIN] postgres, syslog and freeBSD

2008-05-30 Thread Alexander Vysokovskih
auth, authpriv, console, cron, daemon, ftp, kern, lpr, mail, mark, news, ntp, security, syslog, user, uucp and local0 through local7. Also it might be that syslog do not create this file, try to create it by self: # touch /var/log/pgsql With regards, Alexander Vysokovs

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-30 Thread Alexander Vysokovskih
h, authpriv, console, cron, daemon, ftp, kern, lpr, mail, mark, news, ntp, security, syslog, user, uucp and local0 through local7. Also it might be that syslog do not create this file, try to create it by self: # touch /var/log/pgsql With regards, Alexander Vysokovskih -- Sent via p

[ADMIN] lost /pg_xlog

2008-01-23 Thread Alexander Vysokovskih
log file 1, segment 88): No such file or directory LOG: invalid primary checkpoint record --- before that happened postgres was shutdown normally. i so understand that database is consistent, no? why we couldn't start? --- Alexander Vysokovskih ---(e

Re: [ADMIN] UNIX TIME STAMP

2007-04-03 Thread Alexander Vysokovskih
Hello, Mageshwaran. > Is there any function in postgresql7.1.3 to convert unix time stamp to > normal date and time format select date(timestamp 'epoch' + unixtime_column * interval '1 second') from Table; -- Regards, Alexander Vysokovskih