Re: calculating the MD5 hash of role passwords in C

On 1/22/20 12:58 PM, Matthias Apitz wrote: El día miércoles, enero 22, 2020 a las 03:32:17p. m. -0500, Justin escribió: Not sure what your after but here is more information regarding how to store passwords in Postgresql, ... I just want to write a piece of C-code to generate the same

Re: calculating the MD5 hash of role passwords in C

Not sure what your after but here is more information regarding how to store passwords in Postgresql, not related to database roles but for storing passwords for things like websites... https://www.postgresql.org/docs/current/pgcrypto.html section F.25.2.XXX On Wed, Jan 22, 2020 at 2:41 PM

Re: calculating the MD5 hash of role passwords in C

El día miércoles, enero 22, 2020 a las 07:52:51p. m. +, Igor Neyman escribió: > -Original Message- > From: Matthias Apitz [mailto:g...@unixarea.de] > Sent: Wednesday, January 22, 2020 2:41 PM > To: pgsql-general@lists.postgresql.org > Subject: Re: calculating the MD5 hash of role

RE: calculating the MD5 hash of role passwords in C

-Original Message- From: Matthias Apitz [mailto:g...@unixarea.de] Sent: Wednesday, January 22, 2020 2:41 PM To: pgsql-general@lists.postgresql.org Subject: Re: calculating the MD5 hash of role passwords in C . -- Matthias Apitz, ✉

Re: calculating the MD5 hash of role passwords in C

El día miércoles, enero 22, 2020 a las 07:58:47p. m. +0100, Christoph Moench-Tegeder escribió: > ## Matthias Apitz (g...@unixarea.de): > > > sisis71=# select rolname, rolpassword from pg_authid where rolname = > > 'sisis'; > > rolname | rolpassword > >

Re: Memory usage of pg_basebackup...

On Wed, Jan 22, 2020 at 11:23 AM Mladen Marinović wrote: > > Hi, > > Does anybody know how much RAM does pg_basebackup use and if it depends on > the size of the database that the backup is being created? pg_basebackup uses very little RAM, as the data received is written to disk immediately.

Memory usage of pg_basebackup...

Hi, Does anybody know how much RAM does pg_basebackup use and if it depends on the size of the database that the backup is being created? Regards, Mladen Marinović

Re: calculating the MD5 hash of role passwords in C

## Matthias Apitz (g...@unixarea.de): > sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis'; > rolname | rolpassword > -+- > sisis | md52f128a1fbbecc4b16462e8fc8dda5cd5 > > I know the clear text password of the

Re: calculating the MD5 hash of role passwords in C

On 1/22/20 10:20 AM, Matthias Apitz wrote: Hello, If I look into the database I see: sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis'; rolname | rolpassword -+- sisis |

calculating the MD5 hash of role passwords in C

Hello, If I look into the database I see: sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis'; rolname | rolpassword -+- sisis | md52f128a1fbbecc4b16462e8fc8dda5cd5 I know the clear text password of the role,

Re: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

On 1/22/20 2:18 AM, Tanja Savic wrote: Hi, I’m running a pgAdmin from Windows 10 : pgAdmin Version: 4.17 Python Version:**3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 21:26:53) [MSC v.1916 32 bit (Intel)] and I’m able to connect to the remote server. I can see schemas and tables, but when I

Re: SQL Query Syntax help

On Wednesday, January 22, 2020, srikkanth wrote: > Hi Jan, > > Thanks for your input, it is working exactly what i want, but still i m > facing issue because in my table there are different data types they are 10 > to 15 columns are Boolean, one primary key, 140 columns are character. > > when i

Re: @@TRANCOUNT ?

Postgresql does not support Transaction in the same way mssql, it does support nesting transactions in a limited way from version 11+ https://docs.microsoft.com/en-us/sql/t-sql/functions/trancount-transact-sql?view=sql-server-ver15 https://www.postgresql.org/docs/current/sql-begin.html

Re: @@TRANCOUNT ?

1 ;) > On Jan 22, 2020, at 5:59 AM, İlyas Derse wrote: > >  > What's Prostgres' equivalent of select @@trancount? Do you have an idea ?

@@TRANCOUNT ?

What's Prostgres' equivalent of select @@trancount ? Do you have an idea ?

Re: SQL Query Syntax help

Hi Jan,Thanks for your input, it is working exactly what i want, but still i m facing issue because in my table there are different data types they are 10 to 15 columns are Boolean, one primary key, 140 columns are character.when i m applying the logic on this scenario i m getting the below

Re: SQL Query Syntax help

On Wed, 22 Jan 2020 at 11:00, srikkanth wrote: > Can you please help me in writing the syntax for the below mentioned table. > Suggest looking at the crosstab function. https://www.postgresql.org/docs/current/tablefunc.html crosstab(text source_sql, text category_sql) Produces a

Re: SQL Query Syntax help

srikkanth wrote: > Can you please help me in writing the syntax for the below mentioned This looks like an UNPIVOT operation. Here's a generic method that does this without having to specify the columns individually, with the help of json functions: SELECT ID, key, value FROM (SELECT

PgQ and NOTIFY/LISTEN

Hi all. I looked for a forum or a mailing list for PgQ, but didn't find. May be someone know here? Does PgQ use NOTIFY/LISTEN for PgQ internal daemon or consumers. And if not, why? May be it has internal own simulation of NOTIFY/LISTEN functionality?

Re: SQL Query Syntax help

Hi, Am Mittwoch, 22. Januar 2020, 12:00:45 CET schrieb srikkanth: [sniped HTML] something like select id, 'Col A' as "Col Name", "Col A" as "Col Value" from input union all select id, 'Col B' as "Col Name", "Col B" as "Col Value" from input ... order by 1, 2; should work. --

SQL Query Syntax help

Hi Team,Can you please help me in writing the syntax for the below mentioned table.Input :ID Col A Col B Col C Col D Col E Col F

PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

Hi, I’m running a pgAdmin from Windows 10 : pgAdmin Version: 4.17 Python Version: 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 21:26:53) [MSC v.1916 32 bit (Intel)] and I’m able to connect to the remote server. I can see schemas and tables, but when I want to run a query I get this error: could