On Tue, 2020-06-09 at 20:26 -0400, PEDRO PABLO SEVERIN HONORATO wrote:
> I installed Postgres downloading the file posgresql-12.2-1-windows-x64 from
> the website https://www.postgresql.org/download/windows/.
>
> The python37.dll I copied to the System32 folder was located in
> C:\Users\develop
Thank you very much for your replies.
Regarding the server logs, I didn't find anything but healthy log when the
server start which says that it is going to recover from the same point in WAL
which was last sent.
Regarding bugfixes, I will try to update ASAP - but wouldn't a restart of the
serv
Hi Michael,
Thanks for your response.
Please find answers for your questions
How many rows did these tables have before partitioning? --> We starts
test with 0 rows in partition table.
Why did you decide to partition?
--> These tables are
> On 9. Jun 2020, at 21:30, Michael Lewis wrote:
>
>> On Tue, Jun 9, 2020 at 12:34 PM Sebastian Dressler
>> wrote:
>> - Add an index on top of the whole PK
>> - Add indexes onto other columns trying to help the JOIN
>> - Add additional statistics on two related columns
>>
>> Another idea I h
Thank you, Adrian. Will read about all this. By the way, the issue
reappeared. For some reason, I had to reinstall Anaconda and had to delete
the "PYTHONHOME" variable because I could not launch conda.
Seems that they both fight for the same variable name?
Is there a way to set it to two different
On 6/9/20 6:17 PM, PEDRO PABLO SEVERIN HONORATO wrote:
Thanks Adrian, this actually helped me. I was looking for the "language
pack" thing without any success and thanks god that you pointed me in
the right direction :)
What I don't understand is the following. After installing the language
p
Thanks Adrian, this actually helped me. I was looking for the "language
pack" thing without any success and thanks god that you pointed me in the
right direction :)
What I don't understand is the following. After installing the language
pack with stack builder, added a variable named "PYTHONHOME"
On 6/9/20 5:26 PM, PEDRO PABLO SEVERIN HONORATO wrote:
Hi Adrian,
I installed Postgres downloading the file posgresql-12.2-1-windows-x64
from the website https://www.postgresql.org/download/windows/.
Did you go through the steps here?:
https://www.enterprisedb.com/edb-docs/d/postgresql/user-
On 6/9/20 4:35 PM, Peter wrote:
On Tue, Jun 09, 2020 at 12:34:38PM -0700, Adrian Klaver wrote:
And that can very well be done properly with an incremental filesystem
backup software plus some 20 lines of shellscript.
Read the caveats here:
https://www.postgresql.org/docs/12/backup-file.ht
Hi Adrian,
I installed Postgres downloading the file posgresql-12.2-1-windows-x64 from
the website https://www.postgresql.org/download/windows/.
The python37.dll I copied to the System32 folder was located
in C:\Users\developer\Anaconda3.
After trying this, I installed python 3.7.0 and copied the
Greetings,
* Peter (p...@citylink.dinoex.sub.org) wrote:
> On Tue, Jun 09, 2020 at 03:42:48PM -0400, Stephen Frost wrote:
> ! * Peter (p...@citylink.dinoex.sub.org) wrote:
> ! > This professional backup solution also offers support for postgres.
> ! > Sadly, it only covers postgres up to Rel.9, an
On 6/9/20 5:09 PM, PEDRO PABLO SEVERIN HONORATO wrote:
Hello!
I'm cracking my head while trying to make python language work within
postges. I executed "*create extension plpython3u*" but I get this error:
"*ERROR: could not load library "C:/Program
Files/PostgreSQL/12/lib/plpython3.dll": Th
Hello!
I'm cracking my head while trying to make python language work within
postges. I executed "*create extension plpython3u*" but I get this error:
"*ERROR: could not load library "C:/Program
Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not be
found. SQL state: 58P01*"
L
On Tue, Jun 09, 2020 at 12:34:38PM -0700, Adrian Klaver wrote:
! The backup solution is?
https://www.bareos.com/
! Fine rant below. Go forth and work your wonders.
I don't need to, anymore. I did that, for about 20 years - people
I used to work for as a consultant (major banks and insurance sho
On Wed, 10 Jun 2020 at 09:05, Michael Lewis wrote:
>>
>> the join selectivity functions have yet to learn about extended statistics.
>
>
> That is very interesting to me. So, extended statistics would help to
> properly estimate the result set coming out of a single table when comparing
> each o
On 2020-06-09 23:30, Dan shmidt wrote:
We have a setup in which there are several master nodes replicating to a
single slave/backup node. We are using Postgres 11.4.
Recently, one of the nodes seems to be stuck and stopped replicating.
I did some basic troubleshooting and couldn't find the root
I don't know if it would be relevant to this problem, but you are missing
almost 1 full year of bug fixes. 11.4 was released on 20 June last year.
Upgrading minor versions asap is recommended.
I do see this in the release notes from 11.8 last month (
https://www.postgresql.org/docs/release/11.8/)-
>
> the join selectivity functions have yet to learn about extended statistics.
>
That is very interesting to me. So, extended statistics would help to
properly estimate the result set coming out of a single table when
comparing each of those columns to one or many values, but not when joining
up
On Wed, 10 Jun 2020 at 07:31, Michael Lewis wrote:
>
> On Tue, Jun 9, 2020 at 12:34 PM Sebastian Dressler
> wrote:
>>
>> - Add an index on top of the whole PK
>> - Add indexes onto other columns trying to help the JOIN
>> - Add additional statistics on two related columns
>>
>> Another idea I ha
On 6/9/20 12:02 PM, Peter wrote:
On Tue, Jun 09, 2020 at 01:27:20AM -0400, Tom Lane wrote:
! Adrian Klaver writes:
! > On 6/8/20 7:33 PM, Peter wrote:
! >> That "cp" is usually not synchronous. So there is the possibility
! >> that this command terminates successfully, and reports exitcode zero
On Tue, Jun 09, 2020 at 01:27:20AM -0400, Tom Lane wrote:
! Adrian Klaver writes:
! > On 6/8/20 7:33 PM, Peter wrote:
! >> That "cp" is usually not synchronous. So there is the possibility
! >> that this command terminates successfully, and reports exitcode zero
! >> back to the Postgres, and then
On Tue, Jun 9, 2020 at 8:35 AM Ishan Joshi wrote:
> I have using postgresql server v12.2 on CentOS Linux release 7.3.1611
> (Core).
>
>
>
> My application is working fine with non partition tables but recently we
> are trying to adopt partition table on few of application tables.
>
> So we have
Greetings,
* Peter (p...@citylink.dinoex.sub.org) wrote:
> This professional backup solution also offers support for postgres.
> Sadly, it only covers postgres up to Rel.9, and that piece of software
> wasn't touched in the last 6 or 7 years.
Then it certainly doesn't work with the changes in v12
On 6/9/20 10:55 AM, Peter wrote:
On Mon, Jun 08, 2020 at 09:21:47PM -0700, Adrian Klaver wrote:
!
! On 6/8/20 7:33 PM, Peter wrote:
! >
! > Actually, the affair had some good side: as usual I was checking
! > my own designs first and looking for flaws, and indeed I found one:
! > If you do copy o
On Tue, Jun 9, 2020 at 12:34 PM Sebastian Dressler
wrote:
> - Add an index on top of the whole PK
> - Add indexes onto other columns trying to help the JOIN
> - Add additional statistics on two related columns
>
> Another idea I had was to make use of generated columns and hash the PKs
> together
On Mon, Jun 08, 2020 at 09:21:47PM -0700, Adrian Klaver wrote:
!
! On 6/8/20 7:33 PM, Peter wrote:
! >
! > Actually, the affair had some good side: as usual I was checking
! > my own designs first and looking for flaws, and indeed I found one:
! > If you do copy out the archive logs not directly
Helloes,
I do have a set of tables which contain user data and users can choose to have
columns as constrained VARCHAR, limit is typically 100. While users can also
choose from different types, quite often they go the VARCHAR route.
Furthermore, they can pick PKs almost freely. As a result, I q
Andreas Kretschmer writes:
> Am 09.06.20 um 10:44 schrieb Praveen Kumar K S:
>> Thanks. Will this approach replicate DDL changes ?
No.
>
> sure.
>
>
> Regards, Andreas
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
Hi Team,
I have using postgresql server v12.2 on CentOS Linux release 7.3.1611 (Core).
My application is working fine with non partition tables but recently we are
trying to adopt partition table on few of application tables.
So we have created List partition on 6 table. 2 out of 6 tables have
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> On 6/9/20 4:15 AM, Stephen Frost wrote:
> >* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> >>I use pg_backrest, but it does not look promising for running on BSD:
> >>https://fluca1978.github.io/2019/03/04/pgbackrest_FreeBSD.html
On 6/9/20 4:15 AM, Stephen Frost wrote:
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
I use pg_backrest, but it does not look promising for running on BSD:
https://fluca1978.github.io/2019/03/04/pgbackrest_FreeBSD.html
That's an unfortunately ancient post, really, considering
Greetings,
* Chris Stephens (cstephen...@gmail.com) wrote:
> yes, shortly after i sent this out to the list, one of our security
> administrators suggested ldapscheme. I just tested and ldapurl works as
> well.
>
> the security admin explained it like this:
>
> "since we are using port 636 I kn
yes, shortly after i sent this out to the list, one of our security
administrators suggested ldapscheme. I just tested and ldapurl works as
well.
the security admin explained it like this:
"since we are using port 636 I know that it needs the TLS connection in
place before LDAP commands. starttl
Right. In that case, the function I ended up with is this:
create or replace function still_needs_backup(bool, bool)
returns BOOLEAN as $$
BEGIN
PERFORM 1 from item where shouldbebackedup=$1 and backupperformed=$2;
IF FOUND THEN
RETURN TRUE;
ELSE
RETURN FALSE;
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> I use pg_backrest, but it does not look promising for running on BSD:
> https://fluca1978.github.io/2019/03/04/pgbackrest_FreeBSD.html
That's an unfortunately ancient post, really, considering that
pgbackrest has now been fully rewri
Am 09.06.20 um 10:44 schrieb Praveen Kumar K S:
Thanks. Will this approach replicate DDL changes ?
sure.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Thanks. Will this approach replicate DDL changes ?
On Tue, Jun 9, 2020 at 1:36 PM Andreas Kretschmer
wrote:
>
>
> Am 09.06.20 um 09:55 schrieb Praveen Kumar K S:
> > Can I achieve master/slave streaming replication by setting WAL_LEVEL
> > to logical on master ? Are there any drawbacks of it ?
>
Am 09.06.20 um 09:55 schrieb Praveen Kumar K S:
Can I achieve master/slave streaming replication by setting WAL_LEVEL
to logical on master ? Are there any drawbacks of it ?
yes, no problem. the wal's would be a bit larger, that's all.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Suppo
Hello,
I had setup one master and hot-slave by setting WAL_LEVEL=replica
But I use a debezium plugin and it requires to connect to master with
WAL_LEVEL=logical and it is mandatory. Can I achieve master/slave streaming
replication by setting WAL_LEVEL to logical on master ? Are there any
drawback
>
> I think you need to be more specific as to what "this" means.
>
> Looking again after Andrian's comment are you trying to write, in the
> script file:
>
> datetime_diff('start time as string'::timestamp, 'end time as
> string'::timestamp, HOUR)
>
> and get PostgreSQL to recognize the value HOUR
40 matches
Mail list logo