Dmitry Koterov, 22.01.2014 22:35:
> I googled 1 hour approximately, but have not found a ready solution
> for this. So maybe this feature is in PostgreSQL todo-list, or
> something similar exists somewhere...
>
> Before the actual question, I'd like to give a small analogy. What I
> mostly love in
On Fri, Jan 24, 2014 at 11:28 AM, Tatsuo Ishii wrote:
> > I don't think pgpool adds the lost node on its own (once the node is live
> > or available again).
>
> That's one of my TODOs. If we limit it to the standby nodes, it will
> be safe. I hope this is added to next major version of pgpool-II.
On 23/01/14 14:46, Bill Moran wrote:
>
> Some quickie background: I'm on a project to migrate a fairly large
> database from MySQL to PostgreSQL (~2T). As a result of a number of
> factors, I have to do it in one shot and I have a limited time window
> in which things can be down while I switch i
> I don't think pgpool adds the lost node on its own (once the node is live
> or available again).
That's one of my TODOs. If we limit it to the standby nodes, it will
be safe. I hope this is added to next major version of pgpool-II.
> Plus if you have a 3 node replication you need to have
> you
On Thu, Jan 23, 2014 at 7:16 PM, Sameer Kumar wrote:
>
>
> On Fri, Jan 24, 2014 at 1:38 AM, Susan Cassidy
> wrote:
>>
>> pgpool-II may do what you want. Lots of people use it.
>
>
> I don't think pgpool adds the lost node on its own (once the node is live or
> available again). Plus if you hav
Currnently there is no automatic failover for postgresql. If I were
to build something to do this I'd start with repmgr:
http://www.repmgr.org/
On Wed, Jan 22, 2014 at 2:35 PM, Dmitry Koterov
wrote:
> Hello.
>
> I googled 1 hour approximately, but have not found a ready solution for
> this. So m
On Fri, Jan 24, 2014 at 7:08 AM, Adrian Klaver wrote:
> On 01/23/2014 02:55 PM, Susan Cassidy wrote:
>
>> I'm having a problem connecting to postgres via a CGI program. I can
>> connect just fine using the same connect string in a non-cgi perl
>> program as in the perl cgi program. The error I g
On Fri, Jan 24, 2014 at 1:38 AM, Susan Cassidy <
susan.cass...@decisionsciencescorp.com> wrote:
> pgpool-II may do what you want. Lots of people use it.
>
I don't think pgpool adds the lost node on its own (once the node is live
or available again). Plus if you have a 3 node replication you need
On 01/23/2014 02:55 PM, Susan Cassidy wrote:
I'm having a problem connecting to postgres via a CGI program. I can
connect just fine using the same connect string in a non-cgi perl
program as in the perl cgi program. The error I get is this:
ERROR: Unable to connect to dbname testdb2,
I'm having a problem connecting to postgres via a CGI program. I can
connect just fine using the same connect string in a non-cgi perl program
as in the perl cgi program. The error I get is this:
ERROR: Unable to connect to dbname testdb2, err: could not connect to
server: Permission denied
Is t
On Thu, Jan 23, 2014 at 8:31 AM, Andreas Lubensky wrote:
> Hello,
> When implementing a database backend with libpq I realized that it seems
> to be impossible to declare a cursor on a prepared statement. Is this
> correct? What is the reason for this limitation?
I can't think of any but it can b
pgpool-II may do what you want. Lots of people use it.
On Wed, Jan 22, 2014 at 1:35 PM, Dmitry Koterov wrote:
> Hello.
>
> I googled 1 hour approximately, but have not found a ready solution for
> this. So maybe this feature is in PostgreSQL todo-list, or something
> similar exists somewhere...
Sorry, answered wrong posting.
On Thu, Jan 23, 2014 at 6:31 AM, Andreas Lubensky wrote:
> Hello,
> When implementing a database backend with libpq I realized that it seems
> to be impossible to declare a cursor on a prepared statement. Is this
> correct? What is the reason for this limitation?
>
pgpool-II may do what you want.
On Thu, Jan 23, 2014 at 6:31 AM, Andreas Lubensky wrote:
> Hello,
> When implementing a database backend with libpq I realized that it seems
> to be impossible to declare a cursor on a prepared statement. Is this
> correct? What is the reason for this limitation?
Some quickie background: I'm on a project to migrate a fairly large
database from MySQL to PostgreSQL (~2T). As a result of a number of
factors, I have to do it in one shot and I have a limited time window
in which things can be down while I switch it over.
As one of many, many things I'm consid
Victor Yegorov writes:
> I'm looking at a plan: http://explain.depesz.com/s/sPv
> And I have a question. Why in the following snippet `Sort` node
> reports 128818 rows, although
> child node returned only 352?
It's under a mergejoin, which evidently is rescanning its right input
a lot due to dup
Hello,
When implementing a database backend with libpq I realized that it seems
to be impossible to declare a cursor on a prepared statement. Is this
correct? What is the reason for this limitation?
--
with best regards,
Andreas Lubensky
--
Sent via pgsql-general mailing list (pgsql-general@
Greetings.
I'm looking at a plan: http://explain.depesz.com/s/sPv
And I have a question. Why in the following snippet `Sort` node
reports 128818 rows, although
child node returned only 352?
"-> Sort (cost=37.06..37.94 rows=352 width=20) (actual time=4.441..16.971
rows=128818 loops=1)
" So
On 23/01/2014 05:24, Harvey, Allan AC wrote:
> Hi all,
>
> Was wondering if someone has experience with bommbooinvoice and
> postgres as the backend. Hoping for some off list help if the
> combination does actually work.
I looked at it a few years ago, and there were issues then - as I recall
it
19 matches
Mail list logo
