Team
I followed Greg suggested steps .One of big had only one table and around four
million recordsi am doing dev env restoration into new vmthe target VM env is
an POC server and took 3 hrs to restore four million records.Now it is doing
process of lo_open / lo_close / lowrite etci.e
pg-dum
>
> On Tue, Dec 31, 2024 at 10:32 PM Nick wrote:
> >
> > I'm trying to create an Ansible playbook that sets up and manages
> > Postgres on Debian 12.
> >
> > I'm having issues with the default username/login structure, and
> > could
> > use some help.
> >
> > I'm installing the `postgresql` pa
On Tue, Dec 31, 2024 at 5:17 PM Nick wrote:
>
> ```
> localall all peer map=ansible_map
> ```
>
>
> In `pg_ident.conf`, add:
>
> ```
> ansible_map ansible postgres
> ansible_map postgrespostgres
>
> ```
>
>
> This seems to work,
I'm trying to create an Ansible playbook that sets up and manages
Postgres on Debian 12.
I'm having issues with the default username/login structure, and could
use some help.
I'm installing the `postgresql` package via apt, and Debian creates a
`postgres` system account that has a locked passwo
On Dec 31, 2024, at 13:31, Nick wrote:
> What is the proper (secure) way to let the Ansible POSIX user manage
> postgres? It seems there should be a fully automated way to bootstrap
> an Ansible user for `postgres`.
This is generally done with "become" and "become_user" in a shell command,
somet
Hello,
On Tue, Dec 31, 2024 at 10:32 PM Nick wrote:
>
> I'm trying to create an Ansible playbook that sets up and manages
> Postgres on Debian 12.
>
> I'm having issues with the default username/login structure, and could
> use some help.
>
> I'm installing the `postgresql` package via apt, and
On Tue, 2024-12-31 at 23:16 +0100, Andreas 'ads' Scherbaum wrote:
>
>
>
> Can you please provide an example of the task(s) which fail?
> If you have passwordless "sudo" configured tor the user running
> Ansible,
> this works:
>
> - name: Ping PostgreSQL
> postgresql_ping:
> db: postgres
>
