Hi Team,
I Need help or any suggestion on below mentioned issue.
Previously we are running postgresql-10with postgis 2.5.3 and now we are
updated to postgresql-12 and postgis-3.0.1, and in postgresql-10 one query
is taking 20 sec and same query is taking upto 80 sec. thanks in advance
Regards
I restored a snapshot and I can drop the tables there, so we'll likely
proceed to swap the replicas over tomorrow. I have this corrupted
instance i can continue to debug on if necessary. There seem to be some
other issues now that we're investigating, like a max(timestamp) query on
the old insta
On Thu, Jul 9, 2020 at 5:32 PM Tom Lane wrote:
> Alvaro Herrera writes:
> > On 2020-Jul-09, Michel Pelletier wrote:
> >> I don't seem to have either:
> >>
> >> dev=> select * from pg_depend where classid = 297108 or refclassid =
> 297108;
> >> classid | objid | objsubid | refclassid | refobjid |
On Thu, Jul 9, 2020 at 5:26 PM Alvaro Herrera
wrote:
> On 2020-Jul-09, Michel Pelletier wrote:
>
> > Hi Tom, thanks for getting back so quick:
> >
> > I don't seem to have either:
> >
> > dev=> select * from pg_depend where classid = 297108 or refclassid =
> 297108;
> > classid | objid | objsubi
Alvaro Herrera writes:
> On 2020-Jul-09, Michel Pelletier wrote:
>> I don't seem to have either:
>>
>> dev=> select * from pg_depend where classid = 297108 or refclassid = 297108;
>> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
>> -+---+--+---
>> On Jul 9, 2020, at 14:08, Christopher Browne wrote:
>
>> On Thu, 9 Jul 2020 at 12:59, Jeremy Schneider
>> wrote:
>
>>
>> > On Jul 6, 2020, at 19:06, Paul McGarry wrote:
>> >
>> > I don't think I can use setval(), because it risks making sequences go
>> > backwards, eg:
>> >
>> > 1)
On 2020-Jul-09, Michel Pelletier wrote:
> Hi Tom, thanks for getting back so quick:
>
> I don't seem to have either:
>
> dev=> select * from pg_depend where classid = 297108 or refclassid = 297108;
> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
> -+---+
On Thu, Jul 9, 2020 at 4:18 PM Tom Lane wrote:
> Michel Pelletier writes:
> > On a 12.3 AWS RDS instance, I get the following error when trying to drop
> > either of two tables:
>
> > dev=> drop table current_flight;
> > ERROR: invalid non-zero objectSubId for object class 297108
> > dev=> drop
Hi all,
I’m trying to work out a procedure for a safe zero data loss switchover
under (high) load, which allows the old master to be reconnected without
the use of pgrewind.
Would the following be sane?
- open connection to database
- smart shutdown master
- terminate all other connections
- wai
Michel Pelletier writes:
> On a 12.3 AWS RDS instance, I get the following error when trying to drop
> either of two tables:
> dev=> drop table current_flight;
> ERROR: invalid non-zero objectSubId for object class 297108
> dev=> drop table flight;
> ERROR: invalid non-zero objectSubId for obje
On a 12.3 AWS RDS instance, I get the following error when trying to drop
either of two tables:
dev=> drop table current_flight;
ERROR: invalid non-zero objectSubId for object class 297108
dev=> drop table flight;
ERROR: invalid non-zero objectSubId for object class 297108
I can create and drop
Christopher Browne writes:
> On Thu, 9 Jul 2020 at 12:59, Jeremy Schneider
> wrote:
>
>>
>> > On Jul 6, 2020, at 19:06, Paul McGarry wrote:
>> >
>> > I don't think I can use setval(), because it risks making sequences go
>> backwards, eg:
>> >
>> > 1) Check values
>> > DB1sequence: 1234
>> >
On Thu, 9 Jul 2020 at 12:59, Jeremy Schneider
wrote:
>
> > On Jul 6, 2020, at 19:06, Paul McGarry wrote:
> >
> > I don't think I can use setval(), because it risks making sequences go
> backwards, eg:
> >
> > 1) Check values
> > DB1sequence: 1234
> > DB2sequence: 1233 (1 behind)
> > 2) setval('D
> On Jul 6, 2020, at 19:06, Paul McGarry wrote:
>
> I don't think I can use setval(), because it risks making sequences go
> backwards, eg:
>
> 1) Check values
> DB1sequence: 1234
> DB2sequence: 1233 (1 behind)
> 2) setval('DB2sequence',1234);
>
> but if between (1) and (2) there are 2 nextv
Mainly for HA and DR but it can help also for the future if a load balancing is
possible. But it's not mandatory yet.
Thanks
Le jeudi 9 juillet 2020 à 17:30:35 UTC+2, Ron a
écrit :
For high availability, for load sharing or for disaster recovery?
On 7/9/20 8:53 AM, Laurent FAILLIE
For high availability, for load sharing or for disaster recovery?
On 7/9/20 8:53 AM, Laurent FAILLIE wrote:
Hello,
I've been asked by one of my customer to know which are the possible
clustering solution for PostgreSQL ?
Active/passive ?
Active/active ?
if possible free or not too expensive
On Thu, 9 Jul 2020 at 10:15, Brajendra Pratap Singh <
singh.bpratap...@gmail.com> wrote:
> Hi Niels,
>
> Thanks for your prompt response and I apologise for the incomplete
> information.
> Actually we are trying to implement the Kerberos authentication while
> anyone trying to connect with postgre
Hi Niels,
Thanks for your prompt response and I apologise for the incomplete
information.
Actually we are trying to implement the Kerberos authentication while
anyone trying to connect with postgresql DB user/role.
Plz help us here with document.
Postgresql-DB version : 9.6/10/11/12
OS version :
Hi Laurent,
take a look at Patroni: https://github.com/zalando/patroni
It's free and reliable.
Cheers,
Paul
> On 09. Jul, 2020, at 15:53, Laurent FAILLIE wrote:
>
> Hello,
>
> I've been asked by one of my customer to know which are the possible
> clustering solution for PostgreSQL ?
>
> A
> On Jul 9, 2020, at 15:53, Laurent FAILLIE wrote:
>
> if possible free or not too expensive.
Like all of us.
Hello,
I've been asked by one of my customer to know which are the possible clustering
solution for PostgreSQL ?
Active/passive ?Active/active ?
if possible free or not too expensive.
Thanks
Laurent
On Thu, Jul 9, 2020 at 11:22 AM Niels Jespersen wrote:
>
>
>
>
> *Fra:* Brajendra Pratap Singh
> *Emne:* Kerberos-Postgresql implementation for user authentication
>
>
>
>
> Please share the steps to implement the Kerberos with postgresql for user
> authentication purpose. Also share the document
Fra: Brajendra Pratap Singh
Sendt: 9. juli 2020 09:05
Til: pgsql-gene...@postgresql.org
Emne: Kerberos-Postgresql implementation for user authentication
Hi,
Please share the steps to implement the Kerberos with postgresql for user
authentication purpose. Also share the document if any.
Thank
On Wed, 2020-07-08 at 14:09 +, Yorwerth, Adam wrote:
> We’re trying to solve a problem that relies on BigSerial and txid (as
> returned by txid_current() ) values being issued consistently.
>
> Is it possible for two transactions to interleave their issuance of these two
> variables?
>
> Fo
Hi,
Please share the steps to implement the Kerberos with postgresql for user
authentication purpose. Also share the document if any.
Thanks,
Brajendra
25 matches
Mail list logo
