Mass Ingestion
- Mass Ingestion
- 所有产品
[PGSQL] Description = ODBC for PostgreSQL Driver = Setup = Driver64 = /usr/pgsql-9.6/lib/psqlodbca.so Setup64 = /usr/lib64/libodbcpsqlS.so FileUsage = 1
export ODBCSYSINI=/root/infaagent export LD_LIBRARY_PATH=/usr/pgsql-9.6/lib export PGSQL_ODBC_DRIVER=PGSQL
alter database postgres set default_transaction_read_only = off; gcloud sql connectdatabase_replica--user=postgres --quiet; ALTER USER postgres WITH REPLICATION; CREATE USER replication_user WITH REPLICATION IN ROLE cloudsqlsuperuser LOGIN PASSWORD 'password'; ALTER USER postgres WITH REPLICATION;
CREATE USERdbmi_userWITH PASSWORD 'password'; GRANT SELECT ON ALL TABLES IN SCHEMAschemaTOdbmi_user;
CREATE USERdbmi_userWITH PASSWORD 'password' REPLICATION;
CREATE USERdbmi_userWITH PASSWORD 'password'; GRANT rds_replication todbmi_user;
GRANT CREATE ON DATABASEdatabaseTOdbmi_user;
CREATE PUBLICATIONpublication_name[FOR TABLE [ONLY]table_name[*] [,...] | FOR ALL TABLES ];