Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Bagian berikut membahas cara mengonfigurasi database Amazon Aurora PostgreSQL.
Membuat grup parameter
Luncurkan Dasbor Amazon RDS Anda.
Di Navigation Drawer, klik Parameter Groups, lalu klik Create Parameter Group. Halaman Create Parameter Group akan muncul.
Gunakan tabel berikut untuk mengisi kolom di halaman ini, lalu klik Buat:
Kolom
Deskripsi
Kelompok parameter
Pilih keluarga yang cocok dengan database Anda.
Jenis
Pilih DB Cluster Parameter Group.
Nama grup
Berikan nama untuk grup parameter.
Deskripsi
Berikan deskripsi untuk grup parameter.
Centang kotak di sebelah kiri grup parameter yang baru dibuat, lalu di bagian Tindakan grup parameter, klik Edit.
Ubah nilai parameter rds.logical_replication menjadi 1.
Klik Simpan Perubahan.
Tetapkan grup parameter ke instance database
Luncurkan Dasbor Amazon RDS Anda.
Di Navigation Drawer, klik Databases, lalu pilih instance
database Anda.
Dari menu Instance Actions, pilih Modify. Dialog Modify DB
Instance akan muncul.
Di bagian Konfigurasi tambahan, pilih grup parameter cluster database yang Anda buat.
Tetapkan Periode retensi cadangan ke 7 hari.
Klik Lanjutkan.
Di panel Penjadwalan modifikasi, pilih opsi Terapkan
segera.
Mulai ulang instance database
Luncurkan Dasbor Amazon RDS Anda.
Di Navigation Drawer, klik Databases, lalu pilih instance
database Anda.
Di menu drop-down Tindakan, pilih Mulai Ulang, lalu Konfirmasi.
Buat publikasi dan slot replikasi
Buat publikasi untuk perubahan pada tabel yang ingin Anda replikasi. Sebaiknya Anda membuat publikasi hanya untuk tabel yang ingin direplikasi.
Hal ini memungkinkan Datastream membaca data yang relevan saja, dan mengurangi beban pada database dan Datastream:
CREATE PUBLICATION PUBLICATION_NAME
FOR TABLE SCHEMA1.TABLE1, SCHEMA2.TABLE2;
Ganti kode berikut:
PUBLICATION_NAME: Nama publikasi Anda. Anda
harus memberikan nama ini saat membuat aliran data di wizard pembuatan aliran
Datastream.
SCHEMA: Nama skema yang berisi tabel.
TABLE: Nama tabel yang ingin Anda replikasi.
Anda juga dapat membuat publikasi untuk semua tabel di database Anda. Perhatikan bahwa pendekatan ini meningkatkan beban pada database sumber dan Datastream:
CREATE PUBLICATION PUBLICATION_NAME FOR ALL TABLES;
Buat slot replikasi dengan memasukkan perintah PostgreSQL berikut:
REPLICATION_SLOT_NAME: Nama slot replikasi Anda. Anda
harus memberikan nama ini saat membuat aliran data di wizard pembuatan aliran
Datastream.
Membuat pengguna Datastream
Untuk membuat pengguna Datastream, masukkan perintah PostgreSQL berikut:
CREATE USER USER_NAME WITH ENCRYPTED PASSWORD 'USER_PASSWORD';
Ganti kode berikut:
USER_NAME: Nama pengguna Datastream yang ingin Anda buat.
USER_PASSWORD: Sandi untuk pengguna Datastream
yang ingin Anda buat.
Berikan hak istimewa berikut kepada pengguna yang Anda buat:
GRANT RDS_REPLICATION TO USER_NAME;
GRANT SELECT ON ALL TABLES IN SCHEMA SCHEMA_NAME TO USER_NAME;
GRANT USAGE ON SCHEMA SCHEMA_NAME TO USER_NAME;
ALTER DEFAULT PRIVILEGES IN SCHEMA SCHEMA_NAME
GRANT SELECT ON TABLES TO USER_NAME;
Ganti kode berikut:
SCHEMA_NAME: Nama skema yang ingin Anda beri
hak istimewa.
USER_NAME: Pengguna yang ingin Anda beri hak istimewa.
Langkah berikutnya
Pelajari lebih lanjut cara kerja Datastream dengan sumber PostgreSQL.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-12 UTC."],[[["\u003cp\u003eBefore setting up logical replication, ensure you have an existing Aurora cluster and are connected to the Writer endpoint of the master database server.\u003c/p\u003e\n"],["\u003cp\u003eConfigure a database cluster parameter group by creating one, setting the \u003ccode\u003erds.logical_replication\u003c/code\u003e parameter to 1, and then assigning it to the database instance.\u003c/p\u003e\n"],["\u003cp\u003eCreate a publication for the tables you want to replicate, using commands that specify either individual tables, all tables, or all tables within specified schemas.\u003c/p\u003e\n"],["\u003cp\u003eCreate a replication slot with a specific name by using the \u003ccode\u003ePG_CREATE_LOGICAL_REPLICATION_SLOT\u003c/code\u003e command.\u003c/p\u003e\n"],["\u003cp\u003eCreate a specific Datastream user with the \u003ccode\u003eCREATE USER\u003c/code\u003e command and grant it necessary privileges like \u003ccode\u003eRDS_REPLICATION\u003c/code\u003e, \u003ccode\u003eSELECT\u003c/code\u003e, and \u003ccode\u003eUSAGE\u003c/code\u003e on the relevant schemas and tables.\u003c/p\u003e\n"]]],[],null,["# Configure an Amazon Aurora PostgreSQL database\n\nThe following sections cover how to configure an Amazon Aurora PostgreSQL database.\n| Before configuring logical replication for your Amazon Aurora PostgreSQL database, make sure that you have an existing Aurora cluster and that you have connected to the Writer endpoint of your primary database server.\n\nCreate a parameter group\n------------------------\n\n1. Launch your Amazon RDS Dashboard.\n2. In the **Navigation Drawer** , click **Parameter Groups** , and then click **Create Parameter Group** . The **Create Parameter Group** page appears.\n3. Use the following table to populate the fields of this page, and then click **Create** :\n\n4. Select the checkbox to the left of your newly created parameter group, and then, under **Parameter group actions** , click **Edit**.\n5. Change the value of the `rds.logical_replication` parameter to **1**.\n6. Click **Save Changes**.\n\nAssign the parameter group to the database instance\n---------------------------------------------------\n\n1. Launch your Amazon RDS Dashboard.\n2. In the **Navigation Drawer** , click **Databases**, and then select your database instance.\n3. From the **Instance Actions** menu, select **Modify** . The **Modify DB\n Instance** dialog appears.\n4. In the **Additional configuration** section, select the database cluster parameter group that you [created](#create-a-parameter-group-aurora).\n5. Set the **Backup retention period** to **7 days**.\n6. Click **Continue**.\n7. In the **Scheduling of modifications** pane, select the **Apply\n immediately** option.\n\nReboot the database instance\n----------------------------\n\n1. Launch your Amazon RDS Dashboard.\n2. In the **Navigation Drawer** , click **Databases**, and then select your database instance.\n3. In the **Actions** drop-down menu, select **Reboot** and then **Confirm**.\n\nCreate a publication and a replication slot\n-------------------------------------------\n\n1. Create a publication for the changes in the tables you want to replicate. We\n recommend that you create a publication only for the tables that you want to replicate.\n This allows Datastream to read-only the relevant data, and lowers the\n load on the database and Datastream:\n\n ```\n CREATE PUBLICATION PUBLICATION_NAME\n FOR TABLE SCHEMA1.TABLE1, SCHEMA2.TABLE2;\n ```\n\n Replace the following:\n - \u003cvar translate=\"no\"\u003ePUBLICATION_NAME\u003c/var\u003e: The name of your publication. You'll need to provide this name when you create a stream in the Datastream stream creation wizard.\n - \u003cvar translate=\"no\"\u003eSCHEMA\u003c/var\u003e: The name of the schema that contains the table.\n - \u003cvar translate=\"no\"\u003eTABLE\u003c/var\u003e: The name of the table that you want to replicate.\n\n You can also create a publication for all tables in your database. Note that\n this approach increases the load on both the source database and Datastream: \n\n ```\n CREATE PUBLICATION PUBLICATION_NAME FOR ALL TABLES;\n ```\n | For PostgreSQL 15 and later, you can create a publication for all tables in a schema. This approach lets you replicate changes for tables in the specified list of schemas, including tables that you create in the future: \n |\n | ```\n | CREATE PUBLICATION PUBLICATION_NAME\n | FOR TABLES IN SCHEMA SCHEMA1, SCHEMA2;\n | ```\n2. Create a replication slot by entering the following PostgreSQL command:\n\n ```\n SELECT PG_CREATE_LOGICAL_REPLICATION_SLOT('REPLICATION_SLOT_NAME', 'pgoutput');\n ```\n\n \u003cbr /\u003e\n\n Replace the following:\n - \u003cvar translate=\"no\"\u003eREPLICATION_SLOT_NAME\u003c/var\u003e: The name of your replication slot. You'll need to provide this name when you create a stream in the Datastream stream creation wizard.\n\nCreate a Datastream user\n------------------------\n\n1. To create a Datastream user, enter the following PostgreSQL command:\n\n ```\n CREATE USER USER_NAME WITH ENCRYPTED PASSWORD 'USER_PASSWORD';\n ```\n\n \u003cbr /\u003e\n\n Replace the following:\n - \u003cvar translate=\"no\"\u003eUSER_NAME\u003c/var\u003e: The name of the Datastream user that you want to create.\n - \u003cvar translate=\"no\"\u003eUSER_PASSWORD\u003c/var\u003e: The password for the Datastream user that you want to create.\n2. Grant the following privileges to the user you created:\n\n ```\n GRANT RDS_REPLICATION TO USER_NAME;\n GRANT SELECT ON ALL TABLES IN SCHEMA SCHEMA_NAME TO USER_NAME;\n GRANT USAGE ON SCHEMA SCHEMA_NAME TO USER_NAME;\n ALTER DEFAULT PRIVILEGES IN SCHEMA SCHEMA_NAME\n GRANT SELECT ON TABLES TO USER_NAME;\n ```\n\n \u003cbr /\u003e\n\n Replace the following:\n - \u003cvar translate=\"no\"\u003eSCHEMA_NAME\u003c/var\u003e: The name of the schema to which you want to grant the privileges.\n - \u003cvar translate=\"no\"\u003eUSER_NAME\u003c/var\u003e: The user to whom you want to grant the privileges.\n\nWhat's next\n-----------\n\n- Learn more about how Datastream works with [PostgreSQL sources](/datastream/docs/sources-postgresql)."]]
