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
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
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 (
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
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
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
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