# Combining PostgreSQL Persistence and Transport

<!-- Version variant: sqlpersistence_8; default: [/persistence/sql/postgresql-combining-persistence-with-transport.md](/persistence/sql/postgresql-combining-persistence-with-transport.md) -->


When using [SQL persistence using the PostgreSQL dialect](/persistence/sql/dialect-postgresql.md) in combination with the [PostgreSQL transport](/transports/postgresql/index.md), the location of saga data depends both on whether the [outbox](/nservicebus/outbox/index.md) is enabled and on the transaction mode.

## Outbox disabled

PostgreSQL Transport<br/>TransactionMode | Connection sharing | Saga data location
:-:|:-:|:-:
SendsAtomicWithReceive | isolated transaction for send and receive | Transport DB
ReceiveOnly | isolated transaction for receive | Transport DB
None | No transactions | Persistence DB

With the outbox disabled, the persistence uses the connection and transaction context established by the transport to access saga data. This behavior ensures *exactly-once* message processing, since the state change of a saga is committed atomically with the consumption of the message that caused it.

This behavior may be disabled, to force the persistance to create its own connection, as it does when the outbox is enabled:

<!-- snippet: PostgreSqlDoNotShareConnection -->

```cs
var persistence = endpointConfiguration.UsePersistence<SqlPersistence>();
var dialect = persistence.SqlDialect<SqlDialect.PostgreSql>();
dialect.DoNotUsePostgreSqlTransportConnection();
```

<!-- endsnippet -->

> [!WARNING]
> In this mode NServiceBus does not guarantee *exactly-once* message processing behavior. A single incoming message could result in multiple calls of the saga message handling logic, if the previous processing attempt failed just before consuming the message.


## Outbox enabled

PostgreSQL Transport<br/>TransactionMode | Connection sharing | Saga data location
:-:|:-:|:-:
SendsAtomicWithReceive | Not supported | N/A
ReceiveOnly | via Transport storage context | Persistence DB
None | Not supported | N/A