[Pgpool-general] [pgPool]
Micka
mickamusset at gmail.com
Thu Feb 24 13:26:22 UTC 2011
> indeed,
>
> What do you think about :
>
> STATEMENT: SELECT pgpool_recovery('basebackup.sh', 'localhost',
> '/usr/local/pgsql/standby')
> ERROR: WAL level not sufficient for making an online backup
> HINT: wal_level must be set to "archive" or "hot_standby" at server start.
> STATEMENT: SELECT pg_start_backup('Streaming Replication', true)
> ERROR: WAL level not sufficient for making an online backup
> HINT: wal_level must be set to "archive" or "hot_standby" at server start.
> mkdir: cannot create directory `/usr/local/pgsql/standby/pg_xlog': File
> exists
> rm: cannot remove `/usr/local/pgsql/standby/recovery.done': No such file or
> directory
> ERROR: WAL level not sufficient for making an online backup
> HINT: wal_level must be set to "archive" or "hot_standby" at server start.
> STATEMENT: SELECT pg_stop_backup()
> ERROR: WAL level not sufficient for making an online backup
> HINT: wal_level must be set to "archive" or "hot_standby" at server start.
> ERROR: pgpool_recovery failel
>
>
>
>
> On Thu, Feb 24, 2011 at 2:06 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> > It seems, that I missed the part of installing postrgresql for php .
>> >
>> > But when I click now on Recovery for the standby server I got :
>> >
>> > Error Code e1012
>> > pcp_recovery_node command error occurred.
>>
>> To analyze the problem, I recommend to look into:
>>
>> - Pgpool log
>> - PostgreSQL log
>>
>> Can you show me?
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > On Wed, Feb 23, 2011 at 4:49 PM, Micka <mickamusset at gmail.com> wrote:
>> >
>> >> Well,
>> >>
>> >>
>> >> It seems that :
>> >>
>> >> http://172.17.100.12/pgpoolAdmin-3.0.2/nodeStatus.php
>> >>
>> >> return a 500 internal server error.
>> >>
>> >> And I think the error is here :
>> >> for ($i = 0; $i < $nodeCount; $i++) {
>> >> echo "for $i <br>";
>> >> if ($node_alive == false) {
>> >> echo "node alive <br>";
>> >> if (($isReplicationMode || $isMasterSlaveMode) &&
>> >> NodeActive($i))
>> >> array_push($nodeInfo[$i], 'return');
>> >> else
>> >> array_push($nodeInfo[$i], 'none');
>> >> } else if( $isParallelMode ) {
>> >> array_push($nodeInfo[$i], 'none');
>> >> } else {
>> >> echo "dead node ".$nodeInfo[$i][2]."<br>";
>> >> switch($nodeInfo[$i][2]) {
>> >> case 1:
>> >> case 2:
>> >> if($isReplicationMode || $isMasterSlaveMode) {
>> >> array_push($nodeInfo[$i],
>> 'disconnect');
>> >> } else {
>> >> array_push($nodeInfo[$i], 'none');
>> >> }
>> >> echo "success 2<br>";
>> >> break;
>> >> case 3:
>> >> if($isReplicationMode || $isMasterSlaveMode) {
>> >> if(NodeActive($i)) {
>> >> array_push($nodeInfo[$i],
>> >> 'return');
>> >> } else {
>> >> array_push($nodeInfo[$i], 'recovery');
>> >> }
>> >> } else {
>> >> array_push($nodeInfo[$i], 'none');
>> >> }
>> >> break;
>> >> }
>> >> }
>> >> echo print_r($nodeInfo)."<br>";
>> >> $nodeInfo[$i][5] = NodeStandby($i);
>> >> }
>> >> echo "test_final";
>> >> print_r($nodeInfo);
>> >>
>> >> It prints me that :
>> >>
>> >> for 0
>> >> dead node 2
>> >> success 2
>> >> Array ( [0] => Array ( [0] => [1] => 5432 [2] => 2 [3] => 0.500 [4] =>
>> >> disconnect ) [1] => Array ( [0] => [1] => 5433 [2] => 3 [3] => 0.500 )
>> ) 1
>> >>
>> >> It seems that the function NodeStandby do something wrong, because the
>> for
>> >> loop didn't increment $i at all.
>> >> Otherwise It will print "for 1"
>> >>
>> >> What do you think ?
>> >>
>> >>
>> >> On Wed, Feb 23, 2011 at 3:52 PM, Micka <mickamusset at gmail.com> wrote:
>> >>
>> >>> Yes it seems,
>> >>>
>> >>> Just by curiousity, when you start stop start stop pgpool, where
>> pgpool
>> >>> store the information about the current database it uses ?
>> >>>
>> >>> about pgadmin, I got :
>> >>>
>> >>> http://img546.imageshack.us/i/pgpool.png/
>> >>>
>> >>> instead of :
>> >>>
>> >>>
>> >>>
>> >>>
>> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/operation_images/02.png
>> >>>
>> >>> I tried :
>> >>>
>> >>> postgres at PTI2:~$ pcp_node_count 10 localhost 9898 postgres1
>> pgpoolAdmin
>> >>> 2
>> >>>
>> >>> It works
>> >>>
>> >>> as well as :
>> >>>
>> >>> postgres at PTI2:~$ pcp_node_info 10 localhost 9898 postgres1
>> pgpoolAdmin 1
>> >>> 5433 3 0.500000
>> >>>
>> >>> and I'm sure that I've done a :
>> >>>
>> >>> chmod 755 /usr/local/bin/pgpool
>> >>> chmod 755 /usr/local/bin/pcp_*
>> >>>
>> >>>
>> >>> see :
>> >>>
>> >>>
>> >>> mickael at PTI2:/usr/local/bin$ ls -l
>> >>> total 2436
>> >>> -rwxr-xr-x 1 root root 19159 2011-02-22 09:08 pcp_attach_node
>> >>> -rwxr-xr-x 1 root root 19426 2011-02-22 09:08 pcp_detach_node
>> >>> -rwxr-xr-x 1 root root 19207 2011-02-22 09:08 pcp_node_count
>> >>> -rwxr-xr-x 1 root root 19967 2011-02-22 09:08 pcp_node_info
>> >>> -rwxr-xr-x 1 root root 19556 2011-02-22 09:08 pcp_proc_count
>> >>> -rwxr-xr-x 1 root root 20575 2011-02-22 09:08 pcp_proc_info
>> >>> -rwxr-xr-x 1 root root 19171 2011-02-22 09:08 pcp_recovery_node
>> >>> -rwxr-xr-x 1 root root 19124 2011-02-22 09:08 pcp_stop_pgpool
>> >>> -rwxr-xr-x 1 root root 20968 2011-02-22 09:08 pcp_systemdb_info
>> >>> -rwxr-xr-x 1 root root 131901 2011-02-22 09:08 pg_md5
>> >>> -rwxr-xr-x 1 root root 2164698 2011-02-22 09:08 pgpool
>> >>>
>> >>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110224/1576b74e/attachment.html>
More information about the Pgpool-general
mailing list