Re: [GENERAL] Recovery Assistance

2017-01-28 Thread Brian Mills
I presume this is a binary log file for the database. Am I able to recover to a point in time using this log file? What I would do in SQL Server would be recover to a point in time, say a bit before the last completed transaction time the log mentions, then take a backup. Is that possible in post

Re: [GENERAL] Recovery Assistance

2017-01-28 Thread Brian Mills
I have a consistent sql dump from 24 hour previous. The file level backup was done with rsync -a of full data directory after the issue occurred so could reset as I learned. Brian On Sun, 29 Jan 2017 at 9:18 am, Adrian Klaver wrote: > On 01/28/2017 01:55 PM, Brian Mills wrote: > > Yes, its th

Re: [GENERAL] using hstore to store documents

2017-01-28 Thread Rita
sorry for the late reply. My table schema is very simple DROP TABLE xmltest; create table xmltest( id serial,-- dont really need the serial data xml NOT null ); INSERT INTO xmltest (data, id) VALUES (

Re: [GENERAL] Recovery Assistance

2017-01-28 Thread Adrian Klaver
On 01/28/2017 01:55 PM, Brian Mills wrote: Yes, its the last one in the directory, pg_xlog directory ...more files... -rw--- 1 postgres postgres 16777216 Jan 21 10:05 0001000500A1 -rw--- 1 postgres postgres 16777216 Jan 22 21:29 0001000500A2 -rw--- 1 postgr

Re: [GENERAL] Recovery Assistance

2017-01-28 Thread Brian Mills
Yes, its the last one in the directory, pg_xlog directory ...more files... -rw--- 1 postgres postgres 16777216 Jan 21 10:05 0001000500A1 -rw--- 1 postgres postgres 16777216 Jan 22 21:29 0001000500A2 -rw--- 1 postgres postgres 16777216 Jan 24 02:08 0001000

Re: [GENERAL] Recovery Assistance

2017-01-28 Thread rob stone
Hello Brian, On Sun, 2017-01-29 at 07:16 +1100, Brian Mills wrote: > Hi, > > No, it hasn't changed since the first time I looked at it.  > > root@atlassian:/home/tbadmin# ps ax | grep post >  1364 ?        Ss     0:00 /usr/lib/postfix/master >  5198 pts/3    S      0:00 su postgres >  5221 pts/3

Re: [GENERAL] Recovery Assistance

2017-01-28 Thread Brian Mills
Hi, No, it hasn't changed since the first time I looked at it. root@atlassian:/home/tbadmin# ps ax | grep post 1364 ?Ss 0:00 /usr/lib/postfix/master 5198 pts/3S 0:00 su postgres 5221 pts/3S 0:00 /usr/lib/postgresql/9.3/bin/postgres -D /etc/postgresql/9.3/main 522