the user running Ansible,
this works:
- name: Ping PostgreSQL
postgresql_ping:
db: postgres
login_unix_socket: "/var/run/postgresql"
login_user: postgres
become: yes
become_user: postgres
More examples and details:
https://andreas.scherbaum.la/writings/Managing_PostgreSQL_wit
/archives/1122-PGSQL-Phriday-002-PostgreSQL-Backup-and-Restore.html
Looking forward to your blog posts!
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
d like your cup of tea, you're more than welcome
to lend a hand during the event. All you have to do is send a mail at
cont...@pgconf.nyc.
Note: The conference will not be able to cover travel or accommodation
costs.
See you in NYC!
--
Andreas 'ads' Scherbaum
German PostgreSQL
dreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
On 12/02/2022 22:34, Peter J. Holzer wrote:
On 2022-02-12 22:09:25 +0100, Andreas 'ads' Scherbaum wrote:
On 12/02/2022 20:50, Peter J. Holzer wrote:
On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote:
On 10/02/2022 18:22, Peter J. Holzer wrote:
On 2022-02-09 21
On 12/02/2022 20:50, Peter J. Holzer wrote:
On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote:
On 10/02/2022 18:22, Peter J. Holzer wrote:
On 2022-02-09 21:14:39 -0800, Guyren Howe wrote:
Examples of small things Postgres could have:
• SELECT * - b.a_id from a natu
the query.
Regards,
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
out, "show databases" and "show tables" are not from any
standard.
Since you seem to come from MySQL, here is a list terms translated to
PostgreSQL:
https://wiki.postgresql.org/wiki/MySQL_PostgreSQL_terminology
Regards,
--
Andreas 'ads' Scherbaum
German Postg
your cup of tea, you're more than welcome
to lend a hand during the event. All you have to do is send us a mail at
cont...@pgconf.nyc.
Note: We will not be able to cover travel or accommodation costs.
See you in NYC!
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European Po
low our
twitter accounts @fosdempgday <https://twitter.com/fosdempgday> and
@postgresqleu <https://twitter.com/postgresqleu>.
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
g somewhere in the cloud, then yes, that might
make
sense. If your database runs in your own data center, then usually you also
have
disk space available there. Plus a transfer out of your data center will
take time.
There is no "per se" recommendation to move data to S3. And there might be
transfer
costs?
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
numbers,
or a BEFORE trigger can normalize (or reject) the input value.
Regards,
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
communication. Please include your Hangouts handle in your
email (and once again, only reply to me, please don't share your handle
with a public mailinglist)-
Thank you,
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL Use
14 matches
Mail list logo
