---
title: "Postgres WAL"
slug: "postgres-wal"
description: "Effortlessly connect PostgreSQL WAL to your preferred destination using Dataddo, the seamless integration platform that enables streamlined operations."
updated: 2024-04-26T19:04:52Z
published: 2024-04-26T19:04:52Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Postgres WAL

**Postgres WAL (Write-Ahead Logging)** is a system used by PostgreSQL to ensure data integrity by recording changes to the database before they are written to the actual data files. This logging process aids in recovering from crashes by replaying these logs to rebuild the database state up to the point of failure.

The main function of the Postgres WAL ***source*** is to replicate `DELETE` operations.

## Authorize Connection to Postgres

To authorize the connection to your Postgres server, please follow the authorization guide on our [Postgres as a destination](/docs/postgres) article.

### Additional User Permission

Apart from the general user permissions (`CREATE`, `SELECT`, `UPDATE`, `INSERT`, `DELETE`), you will need to add the following:

- Logical replication permission

```
ALTER ROLE dataddo REPLICATION;
```

## Prerequisite: Unique Field Requirement

To set up a Postgres WAL ***source*** , it is essential to define a **unique field**, preferably a **PRIMARY KEY**, as there is no support for implicit replica identity.

## How to Create a Postgres WAL Data Source

1. Under the **Sources** tab, click on the [**Create Source**](https://app.dataddo.com/sources/new) button and select the connector from the list.
2. From the drop-down menu, choose your **account**.
          **Didn't find your account?**

          

Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).
3. **Name** your data source.
4. Select your **table** and **columns**.
5. Configure your **snapshotting preferences**. Choose your [**sync frequency**](https://docs.dataddo.com/docs/extraction#frequency) or the exact synchronization time under **Show advanced settings**.
6. Preview your data by clicking on the **Test Data** button in the top right corner. You can **adjust the date range** for a more specific time frame.
7. Click on **Save** and **congratulations, your new data source is ready!**

---

## Troubleshooting

### Insufficient Disk Space

The Dataddo source can be configured to connect **only every hour (not frequently)**. For this reason, your server **requires sufficient disk space** to store WAL files for at least 1 to 3 hours.

The additional storage time depends on the volume of changes (`INSERT`, `UPDATE`, `DELETE`) occurring in your database. Make sure you estimate the disk capacity accordingly to cover any unexpected traffic peaks or large maintenance operations performed by your DBAs and other personnel.

### No Special Configuration for Replica Identity

Currently, there is no support for explicit replica identity settings to use with the WAL source.

## Related Articles

Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage.

**Sending Data to Dashboarding Apps**

- [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards)
- [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps)

**Sending Data to Data Storages**

- [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)

**Other Resources**

- [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting)
- [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs)
- [Data Duplication](https://docs.dataddo.com/docs/data-duplication)