Re: Backup

On 10/18/24 11:25 AM, Andy Hartman wrote: Windows Server 2022 I would like a backup process similar to what I'm used to using in the mssql world if that's  possible with Postgres... I will be loading monthly archive data to Postgresql so that's why I probably only need once a backup .. onc

Re: Backup

Windows Server 2022 I would like a backup process similar to what I'm used to using in the mssql world if that's possible with Postgres... I will be loading monthly archive data to Postgresql so that's why I probably only need once a backup .. once loaded data is just viewed thru an app... no upd

Re: Backup

On 10/18/24 05:39, Andy Hartman wrote: I would like to use the closest thing to a mssql backup... As in? Searching on 'mssql backup' returns a lot of choices. You will need to be more specific on what you want to achieve. Also be specific about what versions of OS and Postgres you are usin

Re: Backup

On 10/18/24 09:52, Andy Hartman wrote: Reply to list also Ccing list. Windows 22 and Postgres 16.4 Is that Windows Server 2022 or Windows 10/11 with the 22H2 update? You also need to provide a more detailed description of what you want the backup to do? On Fri, Oct 18, 2024 at 12:04 PM

Re: Permissions for Newly Created User

Laurenz Albe writes: > On Fri, 2024-10-18 at 15:41 +0530, sreekanta reddy wrote: >> When creating or altering a user's password, the log file captures the >> password in plain text format, which could be a potential security risk. >> However, when using the \password command in psql, the password

Re: Permissions for Newly Created User

On 10/18/24 03:11, sreekanta reddy wrote: Dear PostgreSQL Support Team, I would also like to suggest an enhancement to the default behavior for newly created users in PostgreSQL. *Observed Issue: *User Created: testdb Command used: CREATE USER testdb WITH PASSWORD 'dhsfjobodjjbsdj'; After cr

Re: Backup

On 10/18/24 08:34, Andy Hartman wrote: Thanks.. I'm on a Windows platform using PG. AFAIK pgBackRest does not run on Windows: https://github.com/pgbackrest/pgbackrest/issues/2431 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backup

Thanks.. I'm on a Windows platform using PG. On Fri, Oct 18, 2024 at 10:45 AM Adrian Klaver wrote: > On 10/18/24 05:39, Andy Hartman wrote: > > I would like to use the closest thing to a mssql backup... > > > > How do I install pgbackrest after downloading and UnZip? > > Read the docs?: > > htt

Re: Backup

On 10/18/24 05:39, Andy Hartman wrote: I would like to use the closest thing to a mssql backup... How do I install pgbackrest after downloading  and UnZip? Read the docs?: https://pgbackrest.org/user-guide.html#installation -- Adrian Klaver adrian.kla...@aklaver.com

Re: Permissions for Newly Created User

On Fri, 2024-10-18 at 15:41 +0530, sreekanta reddy wrote: > I would also like to suggest an enhancement to the default behavior for newly > created users in PostgreSQL. > > Observed Issue: > User Created: testdb > Command used: CREATE USER testdb WITH PASSWORD 'dhsfjobodjjbsdj'; > After creating

Permissions for Newly Created User

Dear PostgreSQL Support Team, I would also like to suggest an enhancement to the default behavior for newly created users in PostgreSQL. *Observed Issue:*User Created: testdb Command used: CREATE USER testdb WITH PASSWORD 'dhsfjobodjjbsdj'; After creating the user testdb, I observed that the use

Re: Backup

I would like to use the closest thing to a mssql backup... How do I install pgbackrest after downloading and UnZip? On Thu, Oct 17, 2024 at 6:28 AM Andy Hartman wrote: > This is great, thank you so much! > > On Thu, Oct 17, 2024 at 12:47 AM Asad Ali wrote: > >> >> Hi Andy, >> >> I hope you'

Re: Postgres installation is failing in mac

> On 18 Oct 2024, at 04:21, Venkata Nori wrote: > > Problem running post-install step. Installation may not complete correctly > The database cluster initialisation failed. There is no information in this post which could assist anyone in helping you, if you would like help I suggest you provide

Postgres installation is failing in mac

Problem running post-install step. Installation may not complete correctly The database cluster initialisation failed. Regards, Prasad Nori Senior Data Scientist Indian Software Labs (ISL) E-mail: venor...@in.ibm.com