Hi all,
I am continuing to investigate and I found a probable malfunctioning in
linux semaphores: I foud postgres semaphores are deleted during barman
backup process. To executing test I have created a new empty postgres
cluster in a Debian Citrix virtual machine; this is output of ipcs -s
command:
Hi Tom,
I am using only pg_ctl to start and stop my database. At the moment I do
not use any script.
Bye.
Meph
On 17 July 2015 at 16:32, Tom Lane wrote:
> mephysto writes:
> > I have some problems in a postgres cluster when I try to execute a
> backup.
> > ...
> > FATAL: semctl(983046, 3, SE
Hi Melvin,
I tried to execute pg_dump and after I tried to launch pg_start_backup and
pg_stop_backup. In both cases, I did not receive any error, so I decided to
investigate in BarMan.
Thanks for your help.
Bye.
Meph
On 17 July 2015 at 16:16, Melvin Davidson wrote:
> If this is occurring wi
mephysto writes:
> I have some problems in a postgres cluster when I try to execute a backup.
> ...
> FATAL: semctl(983046, 3, SETVAL, 0) failed: Invalid argument
> ...
> LOG: could not remove shared memory segment "/PostgreSQL.1804289383": No
> such file or directory
> LOG: semctl(786432, 0, I
If this is occurring with Barman, try doing a manual backup.
IE: pg_dump your_database > /tmp/somefile.sql
If that works, then the problem is with Barman or it's configuration.
On Fri, Jul 17, 2015 at 10:07 AM, Mephysto wrote:
> Hi Melvin,
> I am using Pstgres 9.4.4 in a virtualized Debian Linu
Hi Melvin,
I am using Pstgres 9.4.4 in a virtualized Debian Linux 8.0. I do not know
backup command because is launched by BARMAN 1.4.1. I have tried many times
to execute the backup. I have restarted and reinstalled Postgres and I also
rebooted OS many times.
Thanks for your help.
Meph
On 17 Ju
I think we need just a little bit more information.
What is the O/S?
What is the PostgreSQL version?
What is the backup command?
Does this always occur with the same command?
Did you need to restarrt PostgreSQL after this started?
On Fri, Jul 17, 2015 at 3:29 AM, mephysto wrote:
> Hi there,
>
Hi there,
I have some problems in a postgres cluster when I try to execute a backup.
This is the log of entire operation:
LOG: connection received: host=91.121.182.110 port=54957
LOG: connection authorized: user=postgres database=postgres
LOG: statement: BEGIN
LOG: statement: SET application_n
