Hi,
Please share the steps to implement the Kerberos with postgresql for user
authentication purpose. Also share the document if any.
Thanks,
Brajendra
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
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 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
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 Jul 9, 2020, at 15:53, Laurent FAILLIE wrote:
>
> if possible free or not too expensive.
Like all of us.
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
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 :
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
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
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
> 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
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
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 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
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
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
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
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 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)
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 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
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 |
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
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
25 matches
Mail list logo
