Hi,
I have a Atlassian Confluence Wiki that depends on postgres, but I haven't
much experience with postgres other than for this purpose.
A few days ago, the hard disk filled, so all services stopped working.
When the admin realised this he increased the disk size (its in a cloud, so
that was eas
Which is still later datetime than the /var/log/postgres... log.
Connection attempt shows the same log
postgres@atlassian:/home/myuser$ psql
psql: FATAL: the database system is starting up
Nothing in the syslog that seems connected.
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460
is starting up
2017-01-28 23:00:01 AEDT FATAL: the database system is starting up
2017-01-29 07:14:00 AEDT FATAL: the database system is starting up
I also still can't connect.
postgres@atlassian:/home/tbadmin$ psql
psql: FATAL: the database system is starting up
*Brian Mills*
CTO
0001000500A3
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460 or 03 8376 6327 *|* *Sydney* 02 8064 3600 *|*
*Brisbane* 07 3173 1570
Level 1 *|* 600 Chapel Street *|* South Yarra*|* VIC *|* 3141 *|*
Australia
<https://www.facebook.com/TryBooking/> <https://tw
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:
> >
postgres?
The log mentions this:
2017-01-27 20:36:18 AEDT LOG: last completed transaction was at log time
2017-01-24 02:08:00.023064+11
(which is moments before, or possibly as the disk filled up doing a db
backup dump)
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460 or 03 8376 6327
might have something wrong about the process.
Any thoughts on the above log?
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460 or 03 8376 6327 *|* *Sydney* 02 8064 3600 *|*
*Brisbane* 07 3173 1570
Level 1 *|* 600 Chapel Street *|* South Yarra*|* VIC *|* 3141 *|*
Australia
&
