pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedEncryption password for Backup
7+ messages / 6 participants
[nested] [flat]
* Encryption password for Backup
@ 2020-07-08 03:20 Mayur Mundada <mundada.mayur24@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Mayur Mundada @ 2020-07-08 03:20 UTC (permalink / raw)
To: pgsql-admin
Hello Team,
I need to confirm about Encryption password for Backups. Can we use Encryption
password while taking pg_dump backup and restore backup purpose. If it is
possible please let me know the methods and guidance for the same.
Regards,
Mayur Mundada
9860900093
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Encryption password for Backup
@ 2020-07-08 12:20 Holger Jakobs <holger@jakobs.com>
parent: Mayur Mundada <mundada.mayur24@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Holger Jakobs @ 2020-07-08 12:20 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Dear Mayur,
The easiest way is to pipe the result of pg_dump through some encrypting
program.
pg_dump | encryptProgram > encrypted.dump
Regards,
Holger
Am 08.07.20 um 05:20 schrieb Mayur Mundada:
> Hello Team,
>
> I need to confirm about Encryption password for Backups. Can we
> use Encryption password while taking pg_dump backup and restore backup
> purpose. If it is possible please let me know the methods and guidance
> for the same.
>
> Regards,
> Mayur Mundada
> 9860900093
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Encryption password for Backup
@ 2020-07-08 12:26 Ron <ronljohnsonjr@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 7+ messages in thread
From: Ron @ 2020-07-08 12:26 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Sadly, that wouldn't work too well with --format=directory.
On 7/8/20 7:20 AM, Holger Jakobs wrote:
>
> Dear Mayur,
>
> The easiest way is to pipe the result of pg_dump through some encrypting
> program.
>
> pg_dump | encryptProgram > encrypted.dump
>
> Regards,
>
> Holger
>
>
> Am 08.07.20 um 05:20 schrieb Mayur Mundada:
>> Hello Team,
>>
>> I need to confirm about Encryption password for Backups. Can we use
>> Encryption password while taking pg_dump backup and restore backup
>> purpose. If it is possible please let me know the methods and guidance
>> for the same.
>>
>> Regards,
>> Mayur Mundada
>> 9860900093
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Encryption password for Backup
@ 2020-07-18 15:13 Mayur Mundada <mundada.mayur24@gmail.com>
parent: Mayur Mundada <mundada.mayur24@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Mayur Mundada @ 2020-07-18 15:13 UTC (permalink / raw)
To: pgsql-admin
Any update on this? I am waiting for your reply.
On Wed, Jul 8, 2020, 8:50 AM Mayur Mundada <mundada.mayur24@gmail.com>
wrote:
> Hello Team,
>
> I need to confirm about Encryption password for Backups. Can we use Encryption
> password while taking pg_dump backup and restore backup purpose. If it is
> possible please let me know the methods and guidance for the same.
>
> Regards,
> Mayur Mundada
> 9860900093
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Encryption password for Backup
@ 2020-07-19 12:05 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Mayur Mundada <mundada.mayur24@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Scott Ribe @ 2020-07-19 12:05 UTC (permalink / raw)
To: Mayur Mundada <mundada.mayur24@gmail.com>; +Cc: pgsql-admin
> On Jul 18, 2020, at 9:13 AM, Mayur Mundada <mundada.mayur24@gmail.com> wrote:
>
> Any update on this? I am waiting for your reply.
pg_dump does not encrypt; you can pipe its output into any encryption utility you want to
^ permalink raw reply [nested|flat] 7+ messages in thread
* Google Cloud Maintenance
@ 2024-02-26 08:43 SOzcn <selahattinozcnma@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: SOzcn @ 2024-02-26 08:43 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello Guys,
I hope everything is going well with you guys.
I need to consult your experience on something.
- How do you automatically perform Index maintenance work on your
PostgreSQL instances on Google Cloud? I looked at the documents but could
not get a satisfactory result.
Have a nice week!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Google Cloud Maintenance
@ 2024-02-26 10:30 Ozgur Kulu <kuluozgur@gmail.com>
parent: SOzcn <selahattinozcnma@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Ozgur Kulu @ 2024-02-26 10:30 UTC (permalink / raw)
To: SOzcn <selahattinozcnma@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi SOzcn,
you can use pg_cron on GCP unmanaged environment.
if you use GCP managed environment, you can write a script(python or shell)
for maintenance and schedule it.
Have a nice day,
SOzcn <selahattinozcnma@gmail.com>, 26 Şub 2024 Pzt, 11:44 tarihinde şunu
yazdı:
> Hello Guys,
>
> I hope everything is going well with you guys.
> I need to consult your experience on something.
>
> - How do you automatically perform Index maintenance work on your
> PostgreSQL instances on Google Cloud? I looked at the documents but could
> not get a satisfactory result.
>
> Have a nice week!
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-02-26 10:30 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-08 03:20 Encryption password for Backup Mayur Mundada <mundada.mayur24@gmail.com>
2020-07-08 12:20 ` Holger Jakobs <holger@jakobs.com>
2020-07-08 12:26 ` Ron <ronljohnsonjr@gmail.com>
2020-07-18 15:13 ` Mayur Mundada <mundada.mayur24@gmail.com>
2020-07-19 12:05 ` Scott Ribe <scott_ribe@elevated-dev.com>
2024-02-26 08:43 Google Cloud Maintenance SOzcn <selahattinozcnma@gmail.com>
2024-02-26 10:30 ` Re: Google Cloud Maintenance Ozgur Kulu <kuluozgur@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox