On Sat, Mar 9, 2013 at 10:51 AM, Gregg Jaskiewicz wrote:
> Performance related question.
> With Linux (centos 6.3+), 64bit, ext4 in mind, how would you guys go about
> distributing write load across disks.
>
> Lets say I have quite few disks, and I can partition them the way I want, in
> mirror co
thanks a lot. One final question on this.
if the streaming fails as in our case, we missed 4 days worth of data. We
archive the log files on the primary. if we were to restart , what should
be starting the point ?
Do we need to get all the archived logs to the pg_xlogs from the date ( in
our c
I worked upon this link you sent. It ends up giving error "This applcation
can not start because SSLEAY32.dll is missing." I want to connect in any
form whether it is ODBC or direct. If you know then please help me. I am
stuck here. Thank you
--
View this message in context:
http://postgresql.1
you provide inadequate information to provide anything more than a guess...
Are you sure your issue isn't simply a client display consideration -
basically word-wrapping?
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/crosstab-creating-multiple-rows-for-same
Adrian Klaver-3 wrote
> My opinion, it would take more time to concoct regexes that cover all
> the corner cases than to write a script that walks the through the data
> , finds the problem data and flags them.
ISTM that using regular expressions is necessary regardless of whether you
put them i
On Sat, Mar 9, 2013 at 4:05 PM, akp geek wrote:
> Appreciate your findings. taking your points and doing things now. We can
> upgrade. Which version is more stable 9.2 or 9.1
They're two entirely different branches. They should both be equally
stable. However, if you're looking for the most s
Appreciate your findings. taking your points and doing things now. We can
upgrade. Which version is more stable 9.2 or 9.1
We use GIST indexes quite a bit. and we gis also
I recently compiled postgres 9.2 ..
Regards
On Sat, Mar 9, 2013 at 5:09 PM, Lonni J Friedman wrote:
> On Sat, Mar 9,
On Sat, Mar 9, 2013 at 1:51 PM, akp geek wrote:
> thank you. As you mentioned, I understood that I am starting the streaming
> scratch which is not what I wanted to do.
>
> Here is what I am planning to .
>
> Our replication process was down since March5th.
>
> 1. Is it Ok to get all wals from Mar
thank you. As you mentioned, I understood that I am starting the streaming
scratch which is not what I wanted to do.
Here is what I am planning to .
Our replication process was down since March5th.
1. Is it Ok to get all wals from March5th till now to standby pg_xlog
2. take pg_basebackup
3. exp
I have a long-running multi-row UPDATE that is deadlocking with a
single-row UPDATE:
2013-03-09 11:07:51 CST ERROR: deadlock detected
2013-03-09 11:07:51 CST DETAIL: Process 18851 waits for ShareLock on
transaction 10307138; blocked by process 24203.
Process 24203 waits for ShareLock on
Hello,
I'm running a specialized search engine that indexes a few tens of millions
of web pages, keeping everything in Postgres, and one problem I'm starting
to see is poor cache hit rates. My database has two or three tables just
for the text of the scraped pages, with one row every time a page i
Hi Gregg
yes, keep the indexes on a separate channel. Much depends on how the
data is mapped and accessed, sometimes even distributing the data
itself onto different spaces may do good.
If you use a lot of logging (say you feed a massive pgFouine
activity), you would want to have that on yet anot
Performance related question.
With Linux (centos 6.3+), 64bit, ext4 in mind, how would you guys go about
distributing write load across disks.
Lets say I have quite few disks, and I can partition them the way I want,
in mirror configuration (to get some hardware failure resilience). Should I
separ
That process merely sets up a new server, it doesn't start streaming,
unless the server has been configured correctly. You state that the
slave crashed after two hours. How did you make this determination?
All you seem to be doing is setting up the slave from scratch
repeatedly, and assuming tha
It sounds like all you did was setup the slave from scratch with a
fresh base backup, without understanding or debugging what caused
everything to break. Clearly whatever was wrong on March 5 is still
wrong, and nothing has been fixed. The first step in debugging this
problem is to look at and/or
Hi all -
I am in desperate need of your help. The replication/streaming
stopped working on March5th. I followed the following procedure to restart
the streaming. After running it for couple of hours , the database is
crashing on the slave. This is on our production server. Thanks for yo
On 03/07/2013 12:42 PM, Ray Stell wrote:
> What Tom said works for me. Here is a page that gives an example and I think
> it demonstrates that the root CA does not allow everybody in the gate, the
> chain has to be in place:
>
> http://stackoverflow.com/questions/1456034/trouble-understanding-
17 matches
Mail list logo
