Re: Can PostgreSQL create new WAL files instead of reusing old ones?

2018-06-22 Thread Andres Freund
Hi, On 2018-06-22 11:41:45 -0400, Adam Brusselback wrote: > > Is there some way to make it auto-detect when it should be enabled? If > not, please document that it should be used on ZFS and any other file > system with CoW properties on files. > In addition to this, wondering what type of

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

2018-06-22 Thread Adrian Klaver
On 06/22/2018 09:50 AM, Moreno Andreo wrote: Il 22/06/2018 15:18, Adrian Klaver ha scritto: Are you sure that the entries where not encrypted with a different key because I can't replicate.(More comments below): (other replies below, inline) I'm almost sure (you're never absolutely sure :-)

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

2018-06-22 Thread Moreno Andreo
Il 22/06/2018 15:18, Adrian Klaver ha scritto: On 06/22/2018 01:46 AM, Moreno Andreo wrote: Il 21/06/2018 23:31, Adrian Klaver ha scritto: On 06/21/2018 08:36 AM, Moreno Andreo wrote: Hi, while playing with pgcrypto I ran into a strange issue (postgresql 9.5.3 x86 on Windows 7) Having

Re: Can PostgreSQL create new WAL files instead of reusing old ones?

2018-06-22 Thread Adam Brusselback
> Is there some way to make it auto-detect when it should be enabled? If not, please document that it should be used on ZFS and any other file system with CoW properties on files. In addition to this, wondering what type of performance regression this would show on something like ext4 (if any).

Re: Can PostgreSQL create new WAL files instead of reusing old ones?

2018-06-22 Thread Vick Khera
On Wed, Jun 20, 2018 at 1:35 PM, Jerry Jelinek wrote: > As Dave described in his original email on this topic, we'd like to avoid > recycling WAL files since that can cause performance issues when we have a > read-modify-write on a file that has dropped out of the cache. > > I have implemented a

Re: Can PostgreSQL create new WAL files instead of reusing old ones?

2018-06-22 Thread Jerry Jelinek
Thomas, Thanks for taking a look at this. I'll work on getting a patch together for the master branch. I'll also take a look at the other question you raised and get back to you once I have more information. Thanks again, Jerry On Thu, Jun 21, 2018 at 10:20 PM, Thomas Munro <

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

2018-06-22 Thread Adrian Klaver
On 06/22/2018 01:46 AM, Moreno Andreo wrote: Il 21/06/2018 23:31, Adrian Klaver ha scritto: On 06/21/2018 08:36 AM, Moreno Andreo wrote: Hi, while playing with pgcrypto I ran into a strange issue (postgresql 9.5.3 x86 on Windows 7) Having a table with a field dateofbirth text I made

Re: Copies or tables in schema or copiyng of database - database versioning

2018-06-22 Thread Adrian Klaver
On 06/22/2018 01:12 AM, Łukasz Jarych wrote: Hi Guys, I want to create copies of tables in postgresql to use them by each user in coherent way, So version 1 will be schema1, version 2 will be schema2 (with copies of tables from version 1). How to perfom it ? Using pg dump and creating new

Re: SQL Query never ending...

2018-06-22 Thread DiasCosta
Hello Tom, good evening. Thank you for your prompt answer and help. It was enough to ANALYZE the temp tables to achieve a magnificent result:  37 seconds. I'm portuguese. It's a shame you live so far from me. So I can't put a box of bottles of Porto wine at your door. I also thank David

Re: Question about getting values from range of dates

2018-06-22 Thread Thiemo Kellner
Hi Mike Zitat von Mike Martin : I have entries for files in database which lack specific values (xml files not generated) These values can be obtained by what are called DTC read files, where the values are the same in the last DTC read file before date of file and the next DTC read file (by

Question about getting values from range of dates

2018-06-22 Thread Mike Martin
Hi I am looking for suggestions about the best way to resolve this problem. Scenario I have entries for files in database which lack specific values (xml files not generated) These values can be obtained by what are called DTC read files, where the values are the same in the last DTC read file

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

2018-06-22 Thread Moreno Andreo
Il 21/06/2018 23:31, Adrian Klaver ha scritto: On 06/21/2018 08:36 AM, Moreno Andreo wrote: Hi, while playing with pgcrypto I ran into a strange issue (postgresql 9.5.3 x86 on Windows 7) Having a table with a field dateofbirth text I made the following sequence of SQL commands update

Copies or tables in schema or copiyng of database - database versioning

2018-06-22 Thread Łukasz Jarych
Hi Guys, I want to create copies of tables in postgresql to use them by each user in coherent way, So version 1 will be schema1, version 2 will be schema2 (with copies of tables from version 1). How to perfom it ? Using pg dump and creating new schemas (or databases is a better idea)? Or it is

Re: using pg_basebackup for point in time recovery

2018-06-22 Thread Michael Paquier
On Thu, Jun 21, 2018 at 04:50:38PM -0700, David G. Johnston wrote: > Generally only actual bug fixes get back-patched; but I'd have to say > this looks like it could easily be classified as one. Everybody is against me here ;) > Some comments on the patch itself: > > "recover up to the wanted

Re: using pg_basebackup for point in time recovery

2018-06-22 Thread Michael Paquier
On Thu, Jun 21, 2018 at 04:42:00PM -0400, Ravi Krishna wrote: > Same here even though I use Mac mail. But it is not yahoo alone. > Most of the web email clients have resorted to top posting. I miss > the old days of Outlook Express which was so '>' friendly. I think > Gmail allows '>' when you