Re: [GENERAL] bdr manual cleanup required

I really couldn't say with the available information. Can you set provide a step-by-step process by which you set up these nodes? ​

Re: [GENERAL] Function in PostgreSQL

Sachin Srivastava wrote: > Do you know if it is possible to create a function in postgres that has > errors in the syntax of the > creation sql? It would help our conversion process if we could get all of our > various functions > present in postgres even if they aren’t in 100% working shape. Is

[GENERAL] Function in PostgreSQL

Hi, Do you know if it is possible to create a function in postgres that has errors in the syntax of the creation sql? It would help our conversion process if we could get all of our various functions present in postgres even if they aren’t in 100% working shape. Is there any way to ignore

Re: [GENERAL] bdr manual cleanup required

Le 09/12/2015 05:18, Craig Ringer a écrit : Are you adding more than one node at once? BDR isn't currently smart enough to handle that. Make sure to wait until one node is fully synced up before adding another. ​ In other words, one shall not attemp to add a new node if the other nodes are

Re: [GENERAL] Postgresql INET select and default route ?

Tim Smith wrote: > create table test(a inet); > insert into test values ('0.0.0.0/0'); > insert into test values ('10.1.2.3'); > => select * from test; > a > --- > 0.0.0.0/0 > 10.1.2.3 > (2 rows) > > > This works as expected . > => select * from test where a <<= '10.1.2.3'; >

[GENERAL] Postgresql INET select and default route ?

Hi, create table test(a inet); insert into test values ('0.0.0.0/0'); insert into test values ('10.1.2.3'); => select * from test; a --- 0.0.0.0/0 10.1.2.3 (2 rows) This works as expected . => select * from test where a <<= '10.1.2.3'; a -- 10.1.2.3 (1 row)

[GENERAL] HELP!!! The WAL Archive is taking up all space

Hi all, Please help... I have 1 master PostgreSQL and 1 standby PostgreSQL. Both servers has the same OS Linux Debian Wheezy, the same hardware. Both server hardware: CPU: 24 cores RAM: 128GB Disk-1: 800GB SAS (for OS, logs, WAL archive directory) Disk-2: 330GB SSD (for PostgreSQL data

Re: [GENERAL] Deletion Challenge

Steve Crawford wrote: If I understand correctly the value of "click" always advances and within a "click" the "cash_journal_id" always advances - not necessarily by single steps so within a fairian_id, ordering by "click" plus "cash_journal_id" would return the records in order from which you

Re: [GENERAL] Deletion Challenge

Adrian Klaver wrote: On 12/05/2015 08:08 AM, Berend Tober wrote: /* Deletion Challenge I want to delete all but the most recent transaction, per person, from a table that records a transaction history because at some point the transaction history grows large enough to adversely effect

[GENERAL] Feature Request: Faceting for full text search

Hello, Is it OK if I add feature request "faceting for FTS" to roadmap? Regards, Mirek Svoboda | +420 608 224 486 | Skype: xsvobo10

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On Wednesday, December 09, 2015 07:55:09 AM FattahRozzaq wrote: > archive_mode = on > archive_command = 'cp -i %p /home/postgres/archive/master/%f' > > > The WAL archive folder is at /home/postgres/archive/master/, right? > This directory consumes around 750GB of Disk-1. > Each segment in the

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/09/2015 11:15 AM, Alan Hodgson wrote: On Wednesday, December 09, 2015 07:55:09 AM FattahRozzaq wrote: archive_mode = on archive_command = 'cp -i %p /home/postgres/archive/master/%f' The WAL archive folder is at /home/postgres/archive/master/, right? This directory consumes around 750GB

Re: [GENERAL] Deletion Challenge

On Wed, Dec 9, 2015 at 1:31 PM, Adrian Klaver wrote: > On 12/09/2015 12:24 AM, Berend Tober wrote: > >> Adrian Klaver wrote: >> >>> On 12/05/2015 08:08 AM, Berend Tober wrote: >>> /* Deletion Challenge I want to delete all but the most recent

Re: [GENERAL] Deletion Challenge

The two general solutions are the "keep the last one" proposed by Adrian "keep the last N" that I sent. But it might be worth stepping back a bit. You said you are having performance problems that you feel would be improved by removing only a million rows which doesn't sound like that much to me.

Re: [GENERAL] Regexp_replace question / help needed

Hi, I guess capture will help you look at http://www.postgresql.org/docs/9.0/static/functions-matching.html SELECT regexp_replace('http://test.com/test/testfile.php', '^(.*)/(.*\.php)$', E'\\1=\\2', 'g') 2015-12-09 22:58 GMT+01:00 Christopher Molnar : > Hello, > > I

Re: [GENERAL] Regexp_replace question / help needed

Christopher Molnar writes: > I have a string (like 40,000 with different length and number of > components) of them in a field named "externalurl". I need to replace the > final "/" of the string with "=" while preserving the filename and > extension following the

Re: [GENERAL] Regexp_replace question / help needed

Christopher Molnar writes: > Hello, > > I am running into a problem and need some pointers on regexp_replace - I > can't seem to find an answer in any of the online resources. > > I have a string (like 40,000 with different length and number of components) > of

[GENERAL] Regexp_replace question / help needed

Hello, I am running into a problem and need some pointers on regexp_replace - I can't seem to find an answer in any of the online resources. I have a string (like 40,000 with different length and number of components) of them in a field named "externalurl". I need to replace the final "/" of the

Re: [GENERAL] Deletion Challenge

On 12/09/2015 12:24 AM, Berend Tober wrote: Adrian Klaver wrote: On 12/05/2015 08:08 AM, Berend Tober wrote: /* Deletion Challenge I want to delete all but the most recent transaction, per person, from a table that records a transaction history because at some point the transaction history

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/09/2015 04:38 PM, FattahRozzaq wrote: Quick information, After I realize, the line "archive_command=/bin/true" is a bad decision, I have revert it back. Now I'm really confused and panic. I don't know what to do, and I don't really understand the postgresql.conf I'm a network engineer, I

[GENERAL] Overhead changing varchar(2000) to text

Hi! I do have several tables that uses varchar(2000) as store for remarks. Lately, one customer need to store more than 2000 characteres, and I'm considering changing from varchar(2000) to text. What is the overhead? Is there any place where I can learn about storage impacto for each data

Re: [GENERAL] Overhead changing varchar(2000) to text

On Wed, Dec 9, 2015 at 5:17 PM, Kevin Grittner wrote: > On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter > wrote: > >> I do have several tables that uses varchar(2000) as store for remarks. >> Lately, one customer need to store more than 2000

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

Hi John, I really don't know why I should keep the wal archives. I implement streaming replication into 1 server (standby server). I'm really newbie to PostgreSQL but the boss pushed me to handle it and implement it in production

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/09/2015 04:27 PM, FattahRozzaq wrote: Hi John, I really don't know why I should keep the wal archives. So who set up the archiving and why? Is archive recovery set up on the standby?: http://www.postgresql.org/docs/9.4/interactive/archive-recovery-settings.html I implement streaming

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

> FattahRozzaq hat am 10. Dezember 2015 um 01:27 > geschrieben: > > > Hi John, > > I really don't know why I should keep the wal archives. That's the problem! But that's your part, not our. If you need a Backup with PITR-capability you have to create a so called

Re: [GENERAL] Regexp_replace question / help needed

Thank you both. Problem solved - worked perfectly. On Wed, Dec 9, 2015 at 5:41 PM, Jerry Sievers wrote: > Christopher Molnar writes: > > > Hello, > > > > I am running into a problem and need some pointers on regexp_replace - I > can't seem

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/9/2015 4:27 PM, FattahRozzaq wrote: I really don't know why I should keep the wal archives. I implement streaming replication into 1 server (standby server). I'm really newbie to PostgreSQL but the boss pushed me to handle it and implement it in production f*&%*$%%$#%$#

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

Hi John, Really thanking you for spend time typing and responding my email. I think the archive_command returns success, I can see the archive directory piling up 16MB every 2 minutes. Maybe the pgarchivecleanup is the solution to cleanup the contents of archive folder? How to properly do it?

Re: [GENERAL] Overhead changing varchar(2000) to text

On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter wrote: > I do have several tables that uses varchar(2000) as store for remarks. > Lately, one customer need to store more than 2000 characteres, and I'm > considering changing from varchar(2000) to text. > > What is the

Re: [GENERAL] Overhead changing varchar(2000) to text

Thanks. After reading, I've run some tests and found no storage changes in tables moving from varchar(2000) to text. Actually, the biggest change is that I don't have to keep another constraint between app and database - if I want to increase the user perceived space, now I just have to change

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

Quick information, After I realize, the line "archive_command=/bin/true" is a bad decision, I have revert it back. Now I'm really confused and panic. I don't know what to do, and I don't really understand the postgresql.conf I'm a network engineer, I should handle the network and also postgresql

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/8/2015 4:55 PM, FattahRozzaq wrote: ...I want to limit the total size use by WAL archive to around 200-400 GB...? for what purpose are you keeping a wal archive ? if its for PITR (point in time recovery), you need ALL WAL records since the start of a base backup up to the point in time