I"m running postgres DB on docker & database replication have been enabled.
After configuring repmgr not able to switch over/failover operation.DB &
errors details are provided below.
Please help on this.
* ssh -o Batchmode=yes -q -o ConnectTimeout=10 10.0.0.76
/usr/lib/postgresql/9.4/bin/repmg
The dynamic_shared_memory_type was set to POSIX . Because of this it was
using tmpfs /dev/shm. When the query was running I saw the file system was
filling. So I extended the file system and luckily the query worked for
that time
On Thu, Jun 4, 2020, 5:12 PM Thomas Munro wrote:
> >> Do you see
Can someone please help on this
On Wed, Jun 3, 2020, 11:27 PM Sonam Sharma wrote:
> I have set the dynamic_shared_memory_type to none which was set as POSIX.
> For now we are not seeing the error... Can someone please explain what is
> the impact of setting it as none .
>
> On W
Updated jdbc version also
On Wed, Jun 3, 2020, 11:46 PM Sonam Sharma wrote:
>
>
> On Wed, Jun 3, 2020, 11:29 PM Adrian Klaver
> wrote:
>
>> On 6/3/20 7:58 AM, Sonam Sharma wrote:
>> > Hi Team,
>> >
>> > Getting below error when any query is runn
On Wed, Jun 3, 2020, 11:29 PM Adrian Klaver
wrote:
> On 6/3/20 7:58 AM, Sonam Sharma wrote:
> > Hi Team,
> >
> > Getting below error when any query is running from jdbc side :
> >
> > Error : could not open memory segment "/PostgreSQL.1511679208" : No s
I have set the dynamic_shared_memory_type to none which was set as POSIX.
For now we are not seeing the error... Can someone please explain what is
the impact of setting it as none .
On Wed, Jun 3, 2020, 8:28 PM Sonam Sharma wrote:
> Hi Team,
>
> Getting below error when any query i
Hi Team,
Getting below error when any query is running from jdbc side :
Error : could not open memory segment "/PostgreSQL.1511679208" : No such
file or directory
Yesterday I have extended the /dev/shm filesystem and the query ran. But
today again the issue is repeating.
Can someone please help
Can someone please share steps or any link for how to do set up postgres
replication using patroni. And also to test automatic failover.
Thanks in advance,
Sonam
Yes, you are right. It's for connection failover from application end. I
have set up db replication using repmgr. Version : 9.5
On Fri, Apr 17, 2020, 8:15 PM Julien Rouhaud wrote:
> On Fri, Apr 17, 2020 at 4:02 PM Adrian Klaver
> wrote:
> >
> > On 4/17/20 6:31 AM, Sona
I have setup db replication. And added below parameter in jdbc file . The
connection is failing and it's throwing error like db doesn't exist on
secondary server.
jdbc:postgresql://:50001,
172.29.195.216:50001/crowd?targetServerType=master&reWriteBatchedInserts=true
.PSQLException: FATAL: datab
Hello,.
Do you have similar setup like Oracle RAC in postgres core . I found in edb
but didn't find anything in postgres core. We are looking for setting up
replication with no outage and other node will be up , if the primary is
down. Any help would be great 😊
I have setup replication using repmgr. Wanted to know how much time the
slave node will take to become new primary ?? If any document, can someone
please share of auto failover. With automatic failover, how much time the
slave takes to become new primary .
Thanks..
We have pg_read_all_stats role from v9.6. do we have a similar role for
v9.5 and lower versions ?
I have a trigger, like many other triggers that fire after
update and checks a field of the OLD set. For some reason this trigger
throw this error:
ERROR: record "old" has no field "ivo_sts_cd" CONTEXT: SQL statement
"UPDATE dbo.T8071_CAI_IVO_HDR SET IVO_STS_CD = 1 where
T616_VBU_NBR=old.T616_
Version is 11.2 .. took schema dump using pg_dump -d -n (schma) / gunzip
..
The error I am getting while running restore.
On Wed, Feb 5, 2020, 2:03 PM Rob Sargent wrote:
>
>
> On 2/5/20 1:24 AM, Sonam Sharma wrote:
>
> I am copying schema data to qa box from prod.its failing a
I am copying schema data to qa box from prod.its failing and giving below
error :
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exi
Thanks Adrian, it worked :)
On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver
wrote:
> On 1/2/20 5:47 AM, Tom Lane wrote:
> > Sonam Sharma writes:
> >> I took a schema dump using : pg_dump -n schema dbname .
> >> When I restored this , it doesn't contain th
I took a schema dump using : pg_dump -n schema dbname .
When I restored this , it doesn't contain the constraints and indexes. Can
someone please help how to take a dump including all
How to grant table import access in postgres ?
.html
>>
>> Alter Table oldschema.table Set Schema newschema
>>
>> On Thu, Dec 5, 2019 at 9:31 AM Sonam Sharma wrote:
>>
>>> Hi Justin,
>>>
>>> What can be done to move the data..
>>>
>>> On Thu, Dec 5, 2019, 7
s does not move data
>
> On Thu, Dec 5, 2019 at 5:07 AM Sonam Sharma wrote:
>
>> Can someone please help in schema copy in same database ?
>>
>> I have taken db dump of current schema and in the ddl file , I have
>> edited it with new schema.
>> Will this work?
>>
>
Can someone please help in schema copy in same database ?
I have taken db dump of current schema and in the ddl file , I have edited
it with new schema.
Will this work?
Can someone please help me with the command to restore a single table using
psql.
Took the backup using below command :
pg_dump -t (tablename) dbname > tablename.sql
I have created indexes with certain set of columns. Now I want to remove
one of the column and add new column. Can this done without dropping the
index?
I have created one role reader and granted usage on schema and select all
tables role.
I have created one more user and have
Grant reader to sonam.
But still user Sonam is not able to read the tables..
Anything I am missing please let me know ..
How auto vaccum and vaccum are different ?
How analyze and auto analyze are different ?
We were running load on a table which yesterday took 3 mins and today it
took 30 mins. The autovaccum and autoanalyze are happening daily . But the
manual vaccum and analyze ran on 26th.
Can someone please help
Can someone please help me in how to list all the triggers with their
respective tables and the trigger body
How repmgr and pglogical are different and which one is more efficient way
of replication ?
Can someone please help
I have enabled the archiving and the archive path is getting filled
frequently. can I delete the logs from archive path after taking backup ?
We have a query which is running slow and it's taking 26secs to complete..
we have run the analyzer also and it's taking the same time.
Any tool is there for query optimization or any suggestions.
My query plan looks like this :
CTE Scan on approvalwflscreen (cost=8736.21..8737.25 rows=52 width=
Thanks Paul, I am able to set up. Does pg_auto_failover only works on v10
and v11.
I am having 9.5 on production.
On Wed, Sep 25, 2019, 11:40 PM Paul Jungwirth
wrote:
> On 9/25/19 8:55 AM, Sonam Sharma wrote:
> > My user has permission to touch inside the Fs.
> > I am not ge
My user has permission to touch inside the Fs.
I am not getting why it is checking for /backup.
Any suggestions on this , what else I can check
On Wed, Sep 25, 2019, 12:15 AM bricklen wrote:
>
>
> On Tue, Sep 24, 2019 at 8:41 AM Sonam Sharma wrote:
>
>> I was setting up pg_a
Hi Rob,
I have no where mentioned /backup. I have manually create backup inside /
folder to check why it's giving the error. The /backup folder is empty
only.
On Tue, Sep 24, 2019, 11:15 PM Rob Sargent wrote:
>
>
> > On Sep 24, 2019, at 11:38 AM, Sonam Sharma wrote:
>
Hi Rob,
Os : Linux rhel x86_64
Postgres version : 11.2
Installed the rpm of pg_auto_failover and then set up the monitor, primary.
Secondary is failing with given error
On Tue, Sep 24, 2019, 10:11 PM Rob Sargent wrote:
>
>
> > On Sep 24, 2019, at 9:41 AM, Sonam Sharma wrote:
&
Can someone please help
-- Forwarded message -
From: Sonam Sharma
Date: Tue, Sep 24, 2019, 9:11 PM
Subject: Pg_auto_failover
To: pgsql-general
I was setting up pg_auto_failover. Have successfully set up and monitor and
primary instance. While setting up secondary it's fa
I was setting up pg_auto_failover. Have successfully set up and monitor and
primary instance. While setting up secondary it's failing with below :
ERROR Failed to ensure empty directory "//backup" : Permission denied
Error Failed initialise standby server , see above for details.
Where is it loca
31 PM Adrian Klaver
wrote:
> On 9/18/19 7:56 AM, Sonam Sharma wrote:
> > Adrian,
> >
> > Postgres version : 10.7
> > Os version : Linux Redhat 7.4
>
> If you are installing from the PGDG repos then the package is there:
>
>
> https://yum.postgresql.org/10/re
Hi,
When I am setting up keeper ,
[postgres@lablnxdb001 ~]$ pg_autoctl run --pgdata /opt/primary
08:51:03 INFO Managing PostgreSQL installation at "/opt/primary"
08:51:03 INFO PostgreSQL is running in "/opt/primary" on port 6433
08:51:03 ERROR default_version or installed_version for ext
Adrian,
Postgres version : 10.7
Os version : Linux Redhat 7.4
On Wed, Sep 18, 2019, 8:01 PM Adrian Klaver
wrote:
> On 9/18/19 7:19 AM, Sonam Sharma wrote:
> > Can someone please guide me in installing pg_auto_failover.. where can I
> > get the rpm package for this ?
>
Can someone please guide me in installing pg_auto_failover.. where can I
get the rpm package for this ?
It's done. I have done it from path 😃.
Thanks
On Thu, Sep 5, 2019, 2:27 PM Andreas Joseph Krogh
wrote:
> PÃ¥ torsdag 05. september 2019 kl. 10:53:01, skrev Sonam Sharma <
> sonams1...@gmail.com>:
>
> I have installed postgres with the source code option using configure
&
It's saying gmake *** No rule to make Target uninstall.
On Thu, Sep 5, 2019, 2:27 PM Andreas Joseph Krogh
wrote:
> PÃ¥ torsdag 05. september 2019 kl. 10:53:01, skrev Sonam Sharma <
> sonams1...@gmail.com>:
>
> I have installed postgres with the source code option using c
I have installed postgres with the source code option using configure
--prefix and then make install. Can someone please help in uninstalling
this. How to uninstall the postgres now. The installation was done as
postgres user.
Thanks, will try both answers.
On Wed, Aug 28, 2019, 12:38 PM ROS Didier wrote:
> Hi
>
> It is possible to use background workers with the pg_background extension.
>
>
>
> Best Regards
>
> Didier ROS
>
> EDF
>
>
>
> *De :* sonams1...@gmail.com [mailto:sonams1...@gmail.com]
> *Envoyé :* mercredi
Is there any option to run reindex or vaccum in background?
Every time the session gets logged off in between.
I have upgraded my postgres database to 9.2 to 10.9.
After upgrade getting below error :
Java.lang.illegalstateexception: 3 rows retrieved for single property
server is.Checksum.
Can some one please help on this issue?
I took the backup using pg_dump with gzip option and restored it with psql.
On Wed, Jul 17, 2019, 10:39 PM David G. Johnston
wrote:
> On Wed, Jul 17, 2019 at 10:03 AM Sonam Sharma
> wrote:
>
>> I have restored database and the db size of source was around 55gb and
>> afte
I have restored database and the db size of source was around 55gb and
after restore the db size of Target is 47gb.
How to confirm if restore was successful or not ?
The table count is also same.
are is often the largest bottleneck, not the database.
>
>
> /Nicklas
>
>
>
> On 5/31/19 1:03 PM, Sonam Sharma wrote:
>
> ADding to this, this no of records are present on this table : 19087314
>
> On Fri, May 31, 2019 at 4:28 PM Sonam Sharma wrote:
>
>> Hi Tea
ADding to this, this no of records are present on this table : 19087314
On Fri, May 31, 2019 at 4:28 PM Sonam Sharma wrote:
> Hi Team ,
>
> when i am trying to do select on one table , its hanging and not giving
> any output.
> Can someone please advice what should I check for this ?
>
Hi Team ,
when i am trying to do select on one table , its hanging and not giving any
output.
Can someone please advice what should I check for this ?
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are using
db2.
On Mon, Mar 11, 2019, 8:21 PM Adrian Klaver
wrote:
> On 3/11/19 4:31 AM, Sonam Sharma wrote:
> > Hi All,
> >
> > We are planning to migrate our database into any open source DB.
&
Hi All,
We are planning to migrate our database into any open source DB.
Can someone please help me in knowing which one will be better among
POSTGRESQL and MYSQL.
In what terms postgres is better than MYSQL.
Regards,
Sonam
Hi,
Can we do master to master replication in Postgres.
Regards,
Sonam
On Wed, Oct 3, 2018 at 6:21 PM Sonam Sharma wrote:
> Hello Ben,
>
> When we do \l+ , it is different than source, when we load backup from
> target server.
>
Backup is taken using pg_dump and its loaded as psql db name
>
> Regards,
>
> Sonam
>
>
>
&g
it has been straight efficient writes rather than a
> bunch of updates and deletes which create "holes" in the physical file
> space.
>
> It helps if you are more detailed as to what you've observed if you want a
> more specific answer.
>
> - - Ben Scherrey
>
I have restored the database from backup dump but the size of source and
target databases are different. What can be the reason for this ?
Regards,
Sonam
getting below error from application side :
Last acquisition attempt exception:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
the port no is set correct :
[postgres@lxsqlptgs
No, I didn't. The version is not compatible with application, so need to
downgrade it
On Thu, Aug 23, 2018, 4:56 PM Andreas Kretschmer
wrote:
> On 23 August 2018 12:51:08 CEST, Sonam Sharma
> wrote:
> >Hello,
> >
> >My postgres version is 10.4 and I want to downg
Hello,
My postgres version is 10.4 and I want to downgrade it to 9.5.
and one is at 9.2 and need to upgrade it to 9.5.
Can someone please help how to do this.
Unable to find anything online
Thank you! Can you please help me with any advantages/disadvantages.. my db
size is less than 10gb. I am very new to this.
On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver
wrote:
> On 08/19/2018 10:53 AM, Sonam Sharma wrote:
> >
> >
> >
> >
> > I am planning to mig
I am planning to migrate my db from db2 to postgresql. Before that I wanted
to know is postgresql better than db2? Is it completely free ? Any
performance issues or any limitations?
62 matches
Mail list logo