> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-560f2a74.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Pausing and resuming a Postgres ClickPipe

> Pausing and resuming a Postgres ClickPipe

export const Image = ({img, alt, size}) => {
  return <Frame>
      <img src={img} alt={alt} />
    </Frame>;
};

There are scenarios where it would be useful to pause a Postgres ClickPipe. For example, you may want to run some analytics on existing data in a static state. Or, you might be performing upgrades on Postgres. Here is how you can pause and resume a Postgres ClickPipe.

<h2 id="pause-clickpipe-steps">
  Steps to pause a Postgres ClickPipe
</h2>

1. In the Data Sources tab, click on the Postgres ClickPipe you wish to pause.
2. Head over to the **Settings** tab.
3. Click on the **Pause** button.

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-560f2a74/RuZ82X1hHlMF1hxv/images/integrations/data-ingestion/clickpipes/postgres/pause_button.png?fit=max&auto=format&n=RuZ82X1hHlMF1hxv&q=85&s=6e8929caee730085bd815c195285ba46" border size="md" width="769" height="217" data-path="images/integrations/data-ingestion/clickpipes/postgres/pause_button.png" />

4. A dialog box should appear for confirmation. Click on Pause again.

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-560f2a74/RuZ82X1hHlMF1hxv/images/integrations/data-ingestion/clickpipes/postgres/pause_dialog.png?fit=max&auto=format&n=RuZ82X1hHlMF1hxv&q=85&s=b653676771f72a47812e4db90a0d8626" border size="md" width="768" height="288" data-path="images/integrations/data-ingestion/clickpipes/postgres/pause_dialog.png" />

4. Head over to the **Metrics** tab.
5. In around 5 seconds (and also on page refresh), the status of the pipe should be **Paused**.

<Warning>
  Pausing a Postgres ClickPipe won't pause the growth of replication slots.
</Warning>

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-560f2a74/RuZ82X1hHlMF1hxv/images/integrations/data-ingestion/clickpipes/postgres/pause_status.png?fit=max&auto=format&n=RuZ82X1hHlMF1hxv&q=85&s=fce671e33bc523d94eb1cf51c9d90f2f" border size="md" width="1437" height="256" data-path="images/integrations/data-ingestion/clickpipes/postgres/pause_status.png" />

<h2 id="resume-clickpipe-steps">
  Steps to resume a Postgres ClickPipe
</h2>

1. In the Data Sources tab, click on the Postgres ClickPipe you wish to resume. The status of the mirror should be **Paused** initially.
2. Head over to the **Settings** tab.
3. Click on the **Resume** button.

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-560f2a74/RuZ82X1hHlMF1hxv/images/integrations/data-ingestion/clickpipes/postgres/resume_button.png?fit=max&auto=format&n=RuZ82X1hHlMF1hxv&q=85&s=43a6ae0c68da77c18ddad6b2f604e094" border size="md" width="1258" height="202" data-path="images/integrations/data-ingestion/clickpipes/postgres/resume_button.png" />

4. A dialog box should appear for confirmation. Click on Resume again.

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-560f2a74/RuZ82X1hHlMF1hxv/images/integrations/data-ingestion/clickpipes/postgres/resume_dialog.png?fit=max&auto=format&n=RuZ82X1hHlMF1hxv&q=85&s=66690260ec6cedded92e5df1de1a7e01" border size="md" width="879" height="365" data-path="images/integrations/data-ingestion/clickpipes/postgres/resume_dialog.png" />

5. Head over to the **Metrics** tab.
6. In around 5 seconds (and also on page refresh), the status of the pipe should be **Running**.
