Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres error

Postgres error

From
Loai Abdallatif
Date:
Hello Guys,

I have case of two Postgres version 11 ( replication using repmgr) and and its work fine as below:
-bash-4.2$ sudo su - postgres -c " /usr/pgsql-11/bin/repmgr -f /var/lib/pgsql/repmgr/repmgr.conf cluster show"
 ID | Name  | Role    | Status    | Upstream | Location | Priority | Connection string
----+-------+---------+-----------+----------+----------+----------+--------------------------------------
 1  | pgdb1 | standby |   running | pgdb2    | default  | 100      | host=pgdb1 user=repmgr dbname=repmgr
 2  | pgdb2 | primary | * running |          | default  | 100      | host=pgdb2 user=repmgr dbname=repmgr



but when I installed pgpool 4.1 on third  server to loadbalace the traffic ., from command line I see everything ok like below:

-bash-4.2$ psql -U pgpool  --dbname=postgres --host pgpool -c "show pool_nodes"
 node_id | hostname | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_statu
s_change
---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+-----------
----------
 0       | pgdb1    | 5432 | up     | 0.500000  | standby | 0          | false             | 0                 |                   |                        | 2020-02-17
 11:03:31
 1       | pgdb2    | 5432 | up     | 0.500000  | primary | 3          | true              | 0                 |                   |                        | 2020-02-17
 11:03:31





the problem is appears on when i installed pgpooladmin and tried to stop one node ( master os slave ) I got the below error on pgserver ( not pgpool)

2020-02-17 10:49:39.118 IST [2051] ERROR:  function pgpool_pgctl(unknown, unknown) does not exist at character 8
2020-02-17 10:49:39.118 IST [2051] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2020-02-17 10:49:39.118 IST [2051] STATEMENT:  SELECT pgpool_pgctl('stop', 's')

what I can do please




Re: Postgres error

From
Adrian Klaver
Date:
On 2/17/20 1:50 AM, Loai Abdallatif wrote:
> Hello Guys,
> 
> I have case of two Postgres version 11 ( replication using repmgr) and 
> and its work fine as below:
> -bash-4.2$ sudo su - postgres -c " /usr/pgsql-11/bin/repmgr -f 
> /var/lib/pgsql/repmgr/repmgr.conf cluster show"
>   ID | Name  | Role    | Status    | Upstream | Location | Priority | 
> Connection string
> ----+-------+---------+-----------+----------+----------+----------+--------------------------------------
>   1  | pgdb1 | standby |   running | pgdb2    | default  | 100      | 
> host=pgdb1 user=repmgr dbname=repmgr
>   2  | pgdb2 | primary | * running |          | default  | 100      | 
> host=pgdb2 user=repmgr dbname=repmgr
> 
> 
> 
> but when I installed pgpool 4.1 on third  server to loadbalace the 
> traffic ., from command line I see everything ok like below:
> 
> -bash-4.2$ psql -U pgpool  --dbname=postgres --host pgpool -c "show 
> pool_nodes"
>   node_id | hostname | port | status | lb_weight |  role   | select_cnt 
> | load_balance_node | replication_delay | replication_state | 
> replication_sync_state | last_statu
> s_change
>
---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+-----------
> ----------
>   0       | pgdb1    | 5432 | up     | 0.500000  | standby | 0         
>   | false             | 0                 |                   |         
>                 | 2020-02-17
>   11:03:31
>   1       | pgdb2    | 5432 | up     | 0.500000  | primary | 3         
>   | true              | 0                 |                   |         
>                 | 2020-02-17
>   11:03:31
> 
> 
> 
> 
> 
> the problem is appears on when i installed pgpooladmin and tried to stop 
> one node ( master os slave ) I got the below error on pgserver ( not 
> pgpool)
> 
> 2020-02-17 10:49:39.118 IST [2051] ERROR:  function 
> pgpool_pgctl(unknown, unknown) does not exist at character 8
> 2020-02-17 10:49:39.118 IST [2051] HINT:  No function matches the given 
> name and argument types. You might need to add explicit type casts.
> 2020-02-17 10:49:39.118 IST [2051] STATEMENT:  SELECT 
> pgpool_pgctl('stop', 's')
> 
> what I can do please

Probably best to ask here:

https://www.pgpool.net/mailman/listinfo/pgpool-general

> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: Postgres error

From
Loai Abdallatif
Date:
Thanks Adrian, I will

On Mon, Feb 17, 2020 at 6:53 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 2/17/20 1:50 AM, Loai Abdallatif wrote:
> Hello Guys,
>
> I have case of two Postgres version 11 ( replication using repmgr) and
> and its work fine as below:
> -bash-4.2$ sudo su - postgres -c " /usr/pgsql-11/bin/repmgr -f
> /var/lib/pgsql/repmgr/repmgr.conf cluster show"
>   ID | Name  | Role    | Status    | Upstream | Location | Priority |
> Connection string
> ----+-------+---------+-----------+----------+----------+----------+--------------------------------------
>   1  | pgdb1 | standby |   running | pgdb2    | default  | 100      |
> host=pgdb1 user=repmgr dbname=repmgr
>   2  | pgdb2 | primary | * running |          | default  | 100      |
> host=pgdb2 user=repmgr dbname=repmgr
>
>
>
> but when I installed pgpool 4.1 on third  server to loadbalace the
> traffic ., from command line I see everything ok like below:
>
> -bash-4.2$ psql -U pgpool  --dbname=postgres --host pgpool -c "show
> pool_nodes"
>   node_id | hostname | port | status | lb_weight |  role   | select_cnt
> | load_balance_node | replication_delay | replication_state |
> replication_sync_state | last_statu
> s_change
> ---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+-----------
> ----------
>   0       | pgdb1    | 5432 | up     | 0.500000  | standby | 0         
>   | false             | 0                 |                   |         
>                 | 2020-02-17
>   11:03:31
>   1       | pgdb2    | 5432 | up     | 0.500000  | primary | 3         
>   | true              | 0                 |                   |         
>                 | 2020-02-17
>   11:03:31
>
>
>
>
>
> the problem is appears on when i installed pgpooladmin and tried to stop
> one node ( master os slave ) I got the below error on pgserver ( not
> pgpool)
>
> 2020-02-17 10:49:39.118 IST [2051] ERROR:  function
> pgpool_pgctl(unknown, unknown) does not exist at character 8
> 2020-02-17 10:49:39.118 IST [2051] HINT:  No function matches the given
> name and argument types. You might need to add explicit type casts.
> 2020-02-17 10:49:39.118 IST [2051] STATEMENT:  SELECT
> pgpool_pgctl('stop', 's')
>
> what I can do please

Probably best to ask here:

https://www.pgpool.net/mailman/listinfo/pgpool-general

>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com