Re: [GENERAL] pg_dump crashing ... solved

2016-03-20 Thread Matthias Schmitt
Hello, thank you for your answers. > On 20 Mar 2016, at 16:56, Adrian Klaver wrote: > > So what happens if you either?: > > 1) In the root crontab, change the command to: > > /Users/…/bin/pg_dump -p 5433 mydatabase_1_0_0 -U mmpostgres > > /my_backup_path/mydatabase_1_0_0.dump This will make

Re: [GENERAL] pg_dump crashing

2016-03-20 Thread Thomas Munro
On Mon, Mar 21, 2016 at 4:18 AM, Matthias Schmitt wrote: > Hello, > > sorry for the late response. > >> On 15 Mar 2016, at 18:59, rob stone wrote: >> >> I'm running Debian 4.3.5-1 (2016-02-06) x86_64 GNU/Linux. >> >> Backups are done via a shell script using double hyphen syntax, as in >> e.g.:-

Re: [GENERAL] pg_dump crashing

2016-03-20 Thread Adrian Klaver
On 03/20/2016 08:24 AM, Matthias Schmitt wrote: > Hello, > >> On 16 Mar 2016, at 14:55, Adrian Klaver wrote: >> >> On 03/15/2016 08:10 AM, Matthias Schmitt wrote: >>> Hello, >>> >>> since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. >>> Everything is fine except the daily

Re: [GENERAL] pg_dump crashing

2016-03-20 Thread Matthias Schmitt
Hello, > On 16 Mar 2016, at 14:55, Adrian Klaver wrote: > > On 03/15/2016 08:10 AM, Matthias Schmitt wrote: >> Hello, >> >> since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. >> Everything is fine except the daily backup. When calling pg_dump as part of >> a cron job pg

Re: [GENERAL] pg_dump crashing

2016-03-20 Thread Matthias Schmitt
Hello, sorry for the late response. > On 15 Mar 2016, at 18:59, rob stone wrote: > > I'm running Debian 4.3.5-1 (2016-02-06) x86_64 GNU/Linux. > > Backups are done via a shell script using double hyphen syntax, as in > e.g.:- > > pg_dump --port=5433 --dbname=mydatabase_1_0_0 --username=mmppos

Re: [GENERAL] pg_dump crashing

2016-03-19 Thread Adrian Klaver
On 03/15/2016 08:10 AM, Matthias Schmitt wrote: Hello, since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. Everything is fine except the daily backup. When calling pg_dump as part of a cron job pg_dump crashes: 2016-03-15 01:00:02 CETFATAL: semctl(23232524, 3, SETVAL, 0

Re: [GENERAL] pg_dump crashing

2016-03-15 Thread rob stone
On Tue, 2016-03-15 at 16:10 +0100, Matthias Schmitt wrote: > Hello, > > since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian > 8.3. Everything is fine except the daily backup. When calling pg_dump > as part of a cron job pg_dump crashes: > > 2016-03-15 01:00:02 CETFATAL:  semctl(2

Re: [GENERAL] pg_dump crashing

2016-03-15 Thread Michael Paquier
On Tue, Mar 15, 2016 at 4:10 PM, Matthias Schmitt wrote: > since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. > Everything is fine except the daily backup. When calling pg_dump as part of a > cron job pg_dump crashes: > > 2016-03-15 01:00:02 CETFATAL: semctl(23232524, 3,

[GENERAL] pg_dump crashing

2016-03-15 Thread Matthias Schmitt
Hello, since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. Everything is fine except the daily backup. When calling pg_dump as part of a cron job pg_dump crashes: 2016-03-15 01:00:02 CETFATAL: semctl(23232524, 3, SETVAL, 0) failed: Invalid argument 2016-03-15 01:00:02 CE