My Postgres instance hosted on aws ec2 and use DataStream to Big query table

[manankansaravlo]

Hello My database is hosted in aws ec2 machine so I followed custom This Custom solution.
but after this all step when trying validate showing 
PostgreSQL publication: Failed
PostgreSQL replication slot status: Failed

[yrhsk]

I can recommend trying the following:

1) Check postgresql.conf (psql -U postgres -c 'SHOW config_file`) and ensure these settings:

wal_level = logical
max_replication_slots = 5 # Adjust according to your needs
max_wal_senders = 5 # Adjust according to your needs
shared_preload_libraries = 'pgoutput'

2) Check the pub settings (\dRp+), whether all the needed tables are present there

3) Check the replication slots (SELECT * FROM pg_replication_slots;), and if it has inactive or failed status, you should fix that (try recreating the slot).

P.S. of course, check the Postgres logs on your machine - maybe, there's more specific context. Check the user permissions for publications and replication slots (and check the Postgres engine version, low chance, but it can be outdated)

[manankansaravlo]

Now validate part is done but when i started streaming it's showing error like i have also stated debug log in postgres.conf file but i don't know where is log write can you guide me how i checked that

[yrhsk]

You can query PG for info about log dir and file location (via psql or any other tool that you use for queries):

SHOW log_directory;
SHOW log_filename;

Next, you should login on your instance which runs Postgres engine and check the logs on local fs using the combined path.

[manankansaravlo]

i Don't know but it started running without checking log 😁.
i Don't get log Folder yet !!!