Thread: got stuck in pglogical upgrade on FreeBSD
Hi,
--
I'm trying to replicate data using pglogical
In my testing on local network machine and amazon linux test machine I have successfully setup the replication,
Now while trying for my DB which is running on FreeBSD I did setup everything installed pglogical and pglogical_output, the provider and master are setup properly but the replication is not working.
mydb=# SELECT subscription_name, status FROM pglogical.show_subscription_status();
subscription_name | status
-------------------------+--------------
mydb_subscription | initializing
(1 row)
subscription_name | status
-------------------------+--------------
mydb_subscription | initializing
(1 row)
status is not moving to replicating since last 24 hours db size is 30MB of this database.
nothing found in log, please tell me how to get detailed log and help me solve this.
FYI: OS: FreeBSD 11.0
Master PG: 9.4
Slave PD: 11.3
Thanks & Regards
| Rahul Chordiya | |
Tech-Geek && DevOps && Full Stack Developer | |
| Mobile: +91 998 153 4313 |
Please do not print this email unless absolutely necessary. Go GREEN, Go PAPERLESS
Hi,
Sorry for delayed response.
pglogical_fe.c:54:7: error: implicit declaration of function 'WIFEXITED' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
if (WIFEXITED(ret))
^
pglogical_fe.c:55:124: error: implicit declaration of function 'WEXITSTATUS' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
...fprintf(stderr, "find_other_exec_version: couldn't read output of \"%s\": %d (exited with return code %d)\n", cmd, ret, WEXITSTATUS(ret));
^
pglogical_fe.c:56:12: error: implicit declaration of function 'WIFSIGNALED' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
else if (WIFSIGNALED(ret))
^
pglogical_fe.c:57:119: error: implicit declaration of function 'WTERMSIG' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
fprintf(stderr, "find_other_exec_version: couldn't read output of \"%s\": %d (exited with signal %d)\n", cmd, ret, WTERMSIG(ret));
^
4 errors generated.
if (WIFEXITED(ret))
^
pglogical_fe.c:55:124: error: implicit declaration of function 'WEXITSTATUS' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
...fprintf(stderr, "find_other_exec_version: couldn't read output of \"%s\": %d (exited with return code %d)\n", cmd, ret, WEXITSTATUS(ret));
^
pglogical_fe.c:56:12: error: implicit declaration of function 'WIFSIGNALED' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
else if (WIFSIGNALED(ret))
^
pglogical_fe.c:57:119: error: implicit declaration of function 'WTERMSIG' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
fprintf(stderr, "find_other_exec_version: couldn't read output of \"%s\": %d (exited with signal %d)\n", cmd, ret, WTERMSIG(ret));
^
4 errors generated.
Header Added are:
pglogical_fe.c ==>
#include <sys/types.h>#include <sys/wait.h>
And Second error is:
pglogical_apply_spi.c:588:8: error: implicit declaration of function 'htonl' is invalid in C99
[-Werror,-Wimplicit-function-declaration]
buf = htonl((uint32) val);
^
pglogical_apply_spi.c:600:8: error: implicit declaration of function 'htons' is invalid in C99
[-Werror,-Wimplicit-function-declaration]
buf = htons((uint16) val);
^
2 errors generated.
[-Werror,-Wimplicit-function-declaration]
buf = htonl((uint32) val);
^
pglogical_apply_spi.c:600:8: error: implicit declaration of function 'htons' is invalid in C99
[-Werror,-Wimplicit-function-declaration]
buf = htons((uint16) val);
^
2 errors generated.
Header Added is:
pglogical_apply_spi.c =>> #include <arpa/inet.h>
After adding these .h file we are able to successfully gmake and install.
On Fri, Jun 21, 2019 at 9:57 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/21/19 9:25 AM, Rahul Chordiya wrote:
> Yes, I did install via source using gmake as make command was not working.
> I also need to include some (.h) header file as gmake throwing some
> dependency error.
The errors and the header files are?
>
> On Fri, 21 Jun, 2019, 9:41 PM Adrian Klaver, <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 6/21/19 9:07 AM, Rahul Chordiya wrote:
> > Yes and yes.
> > Also tried to completely clear slave data directory and setup fresh
> > subscribe & subscription.
> >
>
> I assume you compiled it from source. Where there any errors in the
> make
> and/or install stops?
>
> Does the system log show anything relevant?
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Thanks & Regards
| Rahul Chordiya | |
Tech-Geek && DevOps && Full Stack Developer | |
| Mobile: +91 998 153 4313 |
Please do not print this email unless absolutely necessary. Go GREEN, Go PAPERLESS