Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> You're absolutely right, the mapping work very well.
Great, glad to hear it.
> I've created 2 "service user" on Active Directory (postgres and
> postgres_dev), and generated the keytab like this:
>
> ktpass -out
Dear Stephen,
You're absolutely right, the mapping work very well.
I've created 2 "service user" on Active Directory (postgres and postgres_dev),
and generated the keytab like this:
ktpass -out postgres_pg1.keytab -princ postgres/pgdomt1.ad@ad.com -mapUser
AD\postgres -pass 'UserPass1'
On 4/29/19 7:02 AM, Daulat Ram wrote:
Hello team,
I have a database name “kbdb” that is having a schema “kb” and I want to
execute the test.sql file inside this schema,
Please help how we can do that.
You can do as Daniel suggested but be aware that it is equivalent to:
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> If I understand, the mapping can be done in the pg_ident.conf file ?
No, you do the mapping in AD.
Look at the '/princ' and '/mapuser' options used in the ktpass command
here:
Dear Stephen,
If I understand, the mapping can be done in the pg_ident.conf file ?
Thank you very much for your workaround,
Jean-Philippe
De : Stephen Frost
Envoyé : 29 avril 2019 10:22
À : Jean-Philippe Chenel
Cc : pgsql-general@lists.postgresql.org
Objet :
>>I have a database name “kbdb” that is having a schema “kb” and I want to
>>execute the test.sql file inside >>this schema,
set schema 'your_schema';
Cheers,
Daniel
Hi. Today we run pg_ctl promote on a slave server (10.7) and started
using it as a master. The OS also got upgraded FreeBSD 10.4 -> FreeBSD
11.2. And you guessed it, most varchar indexes got corrupted because
system local changed in subtle ways. So I created the extension amcheck
and reindexed
Hello team,
I have a database name "kbdb" that is having a schema "kb" and I want to
execute the test.sql file inside this schema,
Please help how we can do that.
Regards,
Daulat
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> I've configured the GSSAPI authentication with MS Active Directory and it
> works very well.
Glad to hear that.
> The problem is that we have a dev and prod environment and each server must
> be configured with gssapi again the
El día Monday, April 29, 2019 a las 10:24:34AM +0200, Christoph Moench-Tegeder
escribió:
> ## Matthias Apitz (g...@unixarea.de):
>
> > The server in question is SLES12-SP3 and I can't update to SP4 at the
> > moment. I have installed the following pkg:
>
> > # rpm -qa | egrep 'postgre|libpq' |
## Matthias Apitz (g...@unixarea.de):
> The server in question is SLES12-SP3 and I can't update to SP4 at the
> moment. I have installed the following pkg:
> # rpm -qa | egrep 'postgre|libpq' | sort
> libpq5-10.6-1.6.1.x86_64
Ah, right, there's also a postgresql10 in SP3.
> How can I
El día sábado, abril 27, 2019 a las 04:11:06p. m. +0200, Christoph
Moench-Tegeder escribió:
> ## Matthias Apitz (g...@unixarea.de):
>
> > To get Perl's DBD::Pg compiled now I really do need the pg_config tool,
> > but I can't figure out how to get it. I see the following RPM (the ones
> > with
On Mon, 29 Apr 2019 at 19:20, Shai Cantor wrote:
> Some notes I haven't shared or were not clear enough on the previous post.
>
> Data is inserted using the copy command only and in an offline manner.
> Meaning, no user action creates or updates the data. An offline job runs is.
> Number of
Thanks a lot for your feedback.
We're gonna user PG 11 on AWS RDS.
I will do some workload simulations.
Some notes I haven't shared or were not clear enough on the previous post.
1. *Data is inserted using the copy command only* and in an offline
manner. Meaning, no user action creates or
14 matches
Mail list logo
