> 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 basebackup and continously W
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
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?
What
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*&%*$%%$#%$#&# (forgive me)
They
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 s
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 d
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 f*&%*$%%$#%$#&# (forgive me)
They don't hire a database expert, I do
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
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 characteres, and I'm
>> considering changing from varcha
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 overhead?
None -- they are sto
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
ty
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 to find an answer in any of the online resources.
> >
>
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 them in a field named "externalur
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 "&file=" while preserving the filename and
> extension following the "/".
> The closest I can get
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&file=\\2', 'g')
2015-12-09 22:58 GMT+01:00 Christopher Molnar :
> Hello,
>
> I am running into a problem
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
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.
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 transaction, per person, from
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 gr
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
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 o
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 /ho
Hello,
Is it OK if I add feature request "faceting for FTS" to roadmap?
Regards,
Mirek Svoboda | +420 608 224 486 | Skype: xsvobo10
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 performa
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 directory
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
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';
>
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)
This
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
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
errors
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?
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 no
32 matches
Mail list logo
