Hi Rene,
I am using Postgresql 11.2. Major version is 11 and minor version is 2.
On 12/10/2019 11:24 AM, Rene Romero Benavides wrote:
Hi Shalini. The usual diagnostic info is your postgresql server
version, major and minor version, such as in 12.1 , the major version
is 12 and the minor versi
On Wed, Dec 11, 2019 at 4:17 AM Fabio Ugo Venchiarutti
wrote:
> On 10/12/2019 15:06, Tom Lane wrote:
> > =?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= writes:
> >> According to the documentation
> >> https://www.postgresql.org/docs/12/runtime-config-connection.html
> >> A backend must check co
> Vikas Sharma writes:
>> We use postgresql 9.6 and pgpool 3.7.5 and we are now asked to enable ssl
>> for 'in transit'. I have setup the ssl server side on the
>> postgresql dbs ( master and slave) and can see in pg_stat_ssl that the
>> master slave communication and connections from the applicat
On 12/10/19 3:11 PM, Erwin Brandstetter wrote:
I am looking for stable hash functions producing 8-byte or 4-byte hashes
from long text values in Postgres 10 or later.
There is md5(), the result of which can be cast to uuid. This reliably
produces practically unique, stable 16-byte values. I ha
Олег Самойлов wrote:
> My vote to change official name form PostgreSQL to PostgresQL. The
> reason is: many young people look at PostgreSQL and think that the
> short name is Postgre. Sounded awfully, especially in Russian, tied to
> fix neighbours. With PostgresQL they will think that the short n
In terms of "wasted computation", MD5, SHA1, and the others always compute
the full length before they are passed to a UUID, int, or whatever. It's a
sunk cost. It's also a minor cost considering many hash algorithms are
performed in CPU hardware now. All that's left is the truncation and cast,
whi
On Tue, 2019-12-10 at 22:11 +0100, Erwin Brandstetter wrote:
> I am looking for stable hash functions producing 8-byte or 4-byte hashes from
> long text values in Postgres 10 or later.
>
> [...]
>
> There is an old post from 2012 by Tom Lane suggesting that hashtext() and
> friends are not for u
I am looking for stable hash functions producing 8-byte or 4-byte hashes
from long text values in Postgres 10 or later.
There is md5(), the result of which can be cast to uuid. This reliably
produces practically unique, stable 16-byte values. I have usecases where
an 8-byte or even 4-byte hash wo
On 12/10/19 8:14 AM, stan wrote:
On Tue, Dec 10, 2019 at 07:46:02AM -0800, Adrian Klaver wrote:
On 12/10/19 3:21 AM, stan wrote:
I upgraded successfully on our test machine from V11 to V12 the other day.
The below indicates that this is not the case.
Now it is time to upgrade the productio
On 12/10/19 9:03 AM, stan wrote:
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
On 10/12/2019 16:11, Adrian Klaver wrote:
On 12/10/19 7:32 AM, stan wrote:
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
Hi Stan
Check security make sure V12 postgres?? has the correct
On 12/10/19 8:24 AM, stan wrote:
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
On 10/12/2019 16:11, Adrian Klaver wrote:
On 12/10/19 7:32 AM, stan wrote:
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
Hi Stan
Check security make sure V12 postgres?? has the correct
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
> On 10/12/2019 16:11, Adrian Klaver wrote:
> > On 12/10/19 7:32 AM, stan wrote:
> >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> >>> Hi Stan
> >>>
> >>> Check security make sure V12 postgres?? has the correct credential
Thomas Kellerer writes:
> assume the following table:
> create table test
> (
> id integer not null generated always as identity,
> data integer not null
> );
> The following insert works fine:
> insert into test (id, data)
> values (default,1);
> However, a mult
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
> On 10/12/2019 16:11, Adrian Klaver wrote:
> > On 12/10/19 7:32 AM, stan wrote:
> >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> >>> Hi Stan
> >>>
> >>> Check security make sure V12 postgres?? has the correct credential
will the service start from the command line without creating the stats
directory???
to my understanding after every shutdown pg_stat_tmp is deleted and
recreated during startup
starting manually, yet the service will not normally points to a
credentials or path issue
https://www.postgresql.org/
On 10/12/2019 16:11, Adrian Klaver wrote:
> On 12/10/19 7:32 AM, stan wrote:
>> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
>>> Hi Stan
>>>
>>> Check security make sure V12 postgres has the correct credentials
>>>
>> OK,
>>
>> postgres@stantest:/var/run/postgresql$ ls -ld
>> drwxrw
On Tue, Dec 10, 2019 at 07:46:02AM -0800, Adrian Klaver wrote:
> On 12/10/19 3:21 AM, stan wrote:
> > I upgraded successfully on our test machine from V11 to V12 the other day.
>
> The below indicates that this is not the case.
>
> > Now it is time to upgrade the production machine. One f the l
On 12/10/19 7:32 AM, stan wrote:
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
Hi Stan
Check security make sure V12 postgres has the correct credentials
OK,
postgres@stantest:/var/run/postgresql$ ls -ld
drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 .
Looks correct to me.
Th
On 12/10/19 12:15 AM, Thomas Kellerer wrote:
Patrick FICHE schrieb am 10.12.2019 um 08:56:
-Original Message-
From: Thomas Kellerer
assume the following table:
create table test
(
id integer not null generated always as identity,
data integer not null
);
Vikas Sharma writes:
> We use postgresql 9.6 and pgpool 3.7.5 and we are now asked to enable ssl
> for 'in transit'. I have setup the ssl server side on the
> postgresql dbs ( master and slave) and can see in pg_stat_ssl that the
> master slave communication and connections from the application ar
On 12/10/19 5:21 AM, Олег Самойлов wrote:
PGUSER doesn't work with initdb and pg_ctl initdb. Lets explain, where this can
be important. For instance in MacOS the most convenient way to manage
PostgresQL is homebrew.
To install PostgresQL:
brew install postgresql
To upgrade:
brew upgrade pos
On 12/10/19 5:27 AM, Олег Самойлов wrote:
My vote to change official name form PostgreSQL to PostgresQL. The reason is:
many young people look at PostgreSQL and think that the short name is Postgre.
Sounded awfully, especially in Russian, tied to fix neighbours. With PostgresQL
they will think
On 12/10/19 3:21 AM, stan wrote:
I upgraded successfully on our test machine from V11 to V12 the other day.
The below indicates that this is not the case.
Now it is time to upgrade the production machine. One f the lessons
learned in doing this is to do "make install" on all the extensions us
Hi Oner
It appears that you looking for a way to detect and kill of idle
connections or process that are running for a long time Correct??
If that is the case use statement_timeout setting and then use Pg_Agent and
this script to kill off idle connections
SELECT pg_terminate_backend(pid)
FROM p
Greetings,
We use postgresql 9.6 and pgpool 3.7.5 and we are now asked to enable ssl
for 'in transit'. I have setup the ssl server side on the
postgresql dbs ( master and slave) and can see in pg_stat_ssl that the
master slave communication and connections from the application are showing
ssl = 't
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> Hi Stan
>
> Check security make sure V12 postgres has the correct credentials
>
OK,
postgres@stantest:/var/run/postgresql$ ls -ld
drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 .
Looks correct to me.
This sundirectory 12-main.pg_
On 10/12/2019 15:06, Tom Lane wrote:
=?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= writes:
According to the documentation
https://www.postgresql.org/docs/12/runtime-config-connection.html
A backend must check connection to the client by tcp_keepalive messages.
(Config option tcp_keepalives_
=?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= writes:
> According to the documentation
> https://www.postgresql.org/docs/12/runtime-config-connection.html
> A backend must check connection to the client by tcp_keepalive messages.
> (Config option tcp_keepalives_idle).
> But this is don't wor
On Tue, Dec 10, 2019 at 06:48:23AM -0500, stan wrote:
> I just went to do soem work on our test/sandbox instance. I had upgraded
> this ssytem to V12 a few days agao. I found that it was not running:
>
> Here is the last thing in the log:
>
> 2019-12-06 14:16:06.149 EST [3764] LOG: received fast
My vote to change official name form PostgreSQL to PostgresQL. The reason is:
many young people look at PostgreSQL and think that the short name is Postgre.
Sounded awfully, especially in Russian, tied to fix neighbours. With PostgresQL
they will think that the short name is Postgres and this is
PGUSER doesn't work with initdb and pg_ctl initdb. Lets explain, where this can
be important. For instance in MacOS the most convenient way to manage
PostgresQL is homebrew.
To install PostgresQL:
brew install postgresql
To upgrade:
brew upgrade postgresql
this will upgrade soft and to upgr
According to the documentation
https://www.postgresql.org/docs/12/runtime-config-connection.html
A backend must check connection to the client by tcp_keepalive messages.
(Config option tcp_keepalives_idle).
But this is don't work if the backend is busy.
Simple example:
psql localhost
set tcp_
I just went to do soem work on our test/sandbox instance. I had upgraded
this ssytem to V12 a few days agao. I found that it was not running:
Here is the last thing in the log:
2019-12-06 14:16:06.149 EST [3764] LOG: received fast shutdown request
2019-12-06 14:16:06.154 EST [3764] LOG: abortin
I upgraded successfully on our test machine from V11 to V12 the other day.
Now it is time to upgrade the production machine. One f the lessons
learned in doing this is to do "make install" on all the extensions used
in the existing DB before doing the pg_dropcluster.
On the production machine I a
Am 09.12.19 um 23:37 schrieb github kran:
Great, thanks Andreas, So this seems to be a good feature using the
core concept of replication. Can I use this extension and do the major
upgrade without paying ?.
yes, this extension is free.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Sup
Patrick FICHE schrieb am 10.12.2019 um 08:56:
>> -Original Message-
>> From: Thomas Kellerer
>>
>> assume the following table:
>>
>> create table test
>> (
>> id integer not null generated always as identity,
>> data integer not null
>> );
>>
>> However, a mu
36 matches
Mail list logo
