Re: Both type of replications from a single server?

On Thu, Oct 08, 2020 at 11:43:26AM +0530, Srinivasa T N wrote: >Is it possible to have both type of replications (streaming and logical) > from a single server? Yes. >If I have 3 servers A,B and C, then I want to have streaming replication > from A to B whereas logical replication from A

Both type of replications from a single server?

Hi All, Is it possible to have both type of replications (streaming and logical) from a single server? If I have 3 servers A,B and C, then I want to have streaming replication from A to B whereas logical replication from A to C. Is it possible? Regards, Seenu.

Re: How to migrate column type from uuid to serial

I was thinking UUID was not a very good choice for id. Serial would be a better one because I don't have a billion customers. It is more like a thousand. So when I saw the customer ID of the payment gateway cannot accept more than 32 characters, I thought UUID is overkill. So I want to migrate to u

Re: Which is the setup with lowest resources you know Postgres is used in?

On Thu, Oct 08, 2020 at 01:14:02AM +0300, Dmitry Igrishin wrote: > чт, 8 окт. 2020 г. в 00:14, raf : > > > > On Wed, Oct 07, 2020 at 01:53:44PM +0300, Dmitry Igrishin > > wrote: > > > > > In many cases concurrency is not a problem and in fact SQLite may > > > handle concurrent requests faster

Re: Which is the setup with lowest resources you know Postgres is used in?

чт, 8 окт. 2020 г. в 00:14, raf : > > On Wed, Oct 07, 2020 at 01:53:44PM +0300, Dmitry Igrishin > wrote: > > > In many cases concurrency is not a problem and in fact SQLite may > > handle concurrent requests faster than Postgres. Since SQLite is > > server-less and access overhead is near to zero

Re: [SOLVED] Re: UUID generation problem

On 10/7/20 3:28 PM, Adrian Klaver wrote: On 10/7/20 2:24 PM, Rob Sargent wrote: On 10/6/20 9:35 AM, James B. Byrne wrote: Thank you all for the help.  This is what ultimate resolved the issue for me: [root@accounting-2 ~ (master)]#  psql -E --dbname=idempiere --username=postgres --hos

Re: [SOLVED] Re: UUID generation problem

On 10/7/20 2:24 PM, Rob Sargent wrote: On 10/6/20 9:35 AM, James B. Byrne wrote: Thank you all for the help.  This is what ultimate resolved the issue for me: [root@accounting-2 ~ (master)]#  psql -E --dbname=idempiere --username=postgres --host=localhost Password for user postgres: psql

Re: [SOLVED] Re: UUID generation problem

On 10/6/20 9:35 AM, James B. Byrne wrote: Thank you all for the help. This is what ultimate resolved the issue for me: [root@accounting-2 ~ (master)]# psql -E --dbname=idempiere --username=postgres --host=localhost Password for user postgres: psql (11.8) Type "help" for help. idempiere(54

Re: Which is the setup with lowest resources you know Postgres is used in?

On Wed, Oct 07, 2020 at 01:53:44PM +0300, Dmitry Igrishin wrote: > In many cases concurrency is not a problem and in fact SQLite may > handle concurrent requests faster than Postgres. Since SQLite is > server-less and access overhead is near to zero (compared to Postgres) > each writer does its

Re: Handling time series data with PostgreSQL

Greetings, * Mark Johnson (remi9...@gmail.com) wrote: > I think the OP may be referring to Oracle's Temporal Validity feature. Perhaps, but that's not the only way to manage time series data. > [ ... ] In earlier releases of each DBMS we tried to accomplish > the same by adding pairs of timestam

Re: Missing libpq-dev version in buster-pgdg?

On 10/7/20 12:34 PM, Nick Aldwin wrote: Thanks for the reply.  Should I post to the separate hackers list, or wait for someone to chime in here? There is the APT issue tracker(you will need community account to access): https://redmine.postgresql.org/projects/pgapt/issues or the APT packaging

Re: Missing libpq-dev version in buster-pgdg?

Thanks for the reply. Should I post to the separate hackers list, or wait for someone to chime in here? FWIW, I am able to access older v12 libpq-dev by using the archive apt list: https://apt-archive.postgresql.org/ -- so we will do that going forward until this is resolved. -Nick On Wed, Oct

Re: Missing libpq-dev version in buster-pgdg?

On 10/7/20 12:02 PM, Nick Aldwin wrote: Hi Adrian, The FAQ you linked to says the following: > If you really want to use a different version, the packages are available in separate archive components named after the PostgreSQL major version. Append that version after "main" in your sources.l

Re: Missing libpq-dev version in buster-pgdg?

Hi Adrian, The FAQ you linked to says the following: > If you really want to use a different version, the packages are available in separate archive components named after the PostgreSQL major version. Append that version after "main" in your sources.list. For example, if you wanted 9.0's libpq5

Re: Missing libpq-dev version in buster-pgdg?

On 10/7/20 11:01 AM, Nick Aldwin wrote: Hi folks, Did something change recently with what versions of libpq-dev are published to buster-pgdg?  We have a dockerfile based on |postgres:12.2| (which is based on |buster-slim|) that installs |"libpq-dev=$PG_MAJOR.*"|  and it just recently (this we

Missing libpq-dev version in buster-pgdg?

Hi folks, Did something change recently with what versions of libpq-dev are published to buster-pgdg? We have a dockerfile based on postgres:12.2 (which is based on buster-slim) that installs "libpq-dev=$PG_MAJOR.*" and it just recently (this week) started failing. running a brand new postgres

Re: How to migrate column type from uuid to serial

Hemil: On Wed, Oct 7, 2020 at 2:49 PM Hemil Ruparel wrote: > I was integrating a payment gateway for my app when I noticed its maximum > length of customer id string is 32. SIze of UUID is 36 (32 characters and 4 > dashes). So I want to change the type of customer id to serial. The problem > i

Re: Handling time series data with PostgreSQL

I think the OP may be referring to Oracle's Temporal Validity feature. This type of feature has yet to be implemented in PostgreSQL (see https://www.postgresql.org/docs/13/unsupported-features-sql-standard.html item T181). Temporal Validity allows you to add a time dimension to any table, and only

Re: What version specification used by PG community developers?

On 10/7/20 6:53 AM, Magnus Hagander wrote: On Wed, Oct 7, 2020 at 3:47 PM Adrian Klaver > wrote: On 10/7/20 6:01 AM, Ron wrote: > On 10/7/20 2:52 AM, WanCheng wrote: >> Is same to the SemVer?(https://semver.org/) > > It used to be, but

Re: How to migrate column type from uuid to serial

Is it because they are hex characters and hence only need 4 bit to store per character but we display each of those 4 bits as a character as a hex value (0 to 9 and a-f) all of which in ASCII and UTF-8 require a byte to represent? Hence the length of 32 (or 36 with dashes)? On Wed, Oct 7, 2020 at

Re: How to migrate column type from uuid to serial

>>> it is declared as uuid. But how does it occupy only 16 bytes? >> Because a UUID is internally simply a 128bit number - the dashes you see are >> just formatting. > Sorry if this is silly but if it is a 128 bit number, why do we need 32 > characters to represent it? The 36 (or 32 without the

Re: How to migrate column type from uuid to serial

Sorry if this is silly but if it is a 128 bit number, why do we need 32 characters to represent it? Isn't 8 bits one byte? On Wed, Oct 7, 2020 at 8:08 PM Thomas Kellerer wrote: > Hemil Ruparel schrieb am 07.10.2020 um 16:21: > > it is declared as uuid. But how does it occupy only 16 bytes? > > B

Re: Handling time series data with PostgreSQL

Greetings, * Jayaram (jairam...@gmail.com) wrote: > So, Do we need the timescaleDB as mandatory to handle time series data? Is > there any way to handle hourly to days,months,yearly data with PGSQL alone > without timescale addon? Certainly there is and a lot of people do it- what isn't clear is

Re: How to migrate column type from uuid to serial

Hemil Ruparel schrieb am 07.10.2020 um 16:21: > it is declared as uuid. But how does it occupy only 16 bytes? Because a UUID is internally simply a 128bit number - the dashes you see are just formatting. But if you can only send the text represnation, then yes 32 characters aren't enough.

Re: How to migrate column type from uuid to serial

umm it is declared as uuid. But how does it occupy only 16 bytes? Even if we remove those 4 dashes thats 32 bytes of text right? I am not concerned about the size at all. How do i send it as a string below 32 bytes? On Wed, Oct 7, 2020 at 7:37 PM Thomas Kellerer wrote: > Hemil Ruparel schrieb am

Re: How to migrate column type from uuid to serial

Hemil Ruparel schrieb am 07.10.2020 um 16:02: > Yes the id is stored as a uuid. Then it should be declared with the data type uuid, which only needs 16 bytes.

Re: How to migrate column type from uuid to serial

Yes the id is stored as a uuid. Thanks for the suggestion. Should work On Wed, Oct 7, 2020 at 7:29 PM Adrian Klaver wrote: > On 10/7/20 6:58 AM, Hemil Ruparel wrote: > > Please reply to list also. > Ccing list > > > Yes. The id is stored as uuid. Thanks for the suggestion. Should work > > > > >

Re: How to migrate column type from uuid to serial

On 10/7/20 6:58 AM, Hemil Ruparel wrote: Please reply to list also. Ccing list Yes. The id is stored as uuid. Thanks for the suggestion. Should work On Wed, Oct 7, 2020 at 7:27 PM Adrian Klaver > wrote: On 10/7/20 5:48 AM, Hemil Ruparel wrote: > I

Re: How to migrate column type from uuid to serial

On 10/7/20 5:48 AM, Hemil Ruparel wrote: I was integrating a payment gateway for my app when I noticed its maximum length of customer id string is 32. SIze of UUID is 36 (32 characters and 4 dashes). So I want to change the type of customer id to serial. The problem is by now, the column is bei

Re: What version specification used by PG community developers?

On Wed, Oct 7, 2020 at 3:47 PM Adrian Klaver wrote: > On 10/7/20 6:01 AM, Ron wrote: > > On 10/7/20 2:52 AM, WanCheng wrote: > >> Is same to the SemVer?(https://semver.org/) > > > > It used to be, but starting with v10 it's > > MAJOR > > PATCH > > Was it? > > Pre-10 it was: > > MAJOR.MAJOR.PATCH

undefined reference to `pg_snprintf when we upgraded libpq version from 10.3 to 12.3

Hi all, We upgraded the libpq version from 10.3 to 12.3. Now we are getting following linker error in compilation. linux64/lib/libPostgreSQLClient.so: undefined reference to `pg_snprintf(char*, unsigned long, char const*, ...)' When we analyzed it we found following diff in libpq. What could be

Re: What version specification used by PG community developers?

On 10/7/20 6:01 AM, Ron wrote: On 10/7/20 2:52 AM, WanCheng wrote: Is same to the SemVer?(https://semver.org/) It used to be, but starting with v10 it's MAJOR PATCH Was it? Pre-10 it was: MAJOR.MAJOR.PATCH -- Adrian Klaver adrian.kla...@aklaver.com

Re: What version specification used by PG community developers?

On 10/7/20 2:52 AM, WanCheng wrote: Is same to the SemVer?(https://semver.org/) It used to be, but starting with v10 it's MAJOR PATCH -- Angular momentum makes the world go 'round.

How to migrate column type from uuid to serial

I was integrating a payment gateway for my app when I noticed its maximum length of customer id string is 32. SIze of UUID is 36 (32 characters and 4 dashes). So I want to change the type of customer id to serial. The problem is by now, the column is being used at many places. How to migrate the co

Re: Which is the setup with lowest resources you know Postgres is used in?

ср, 7 окт. 2020 г. в 10:51, Thorsten Schöning : > > Hi all, > > I'm regularly reading that Postgres is often used with containers and > in cloud environments these days, even on some not too powerful NAS. > > What are the lowest resource setups you know of or even host Postgres > successfully with

Re: What version specification used by PG community developers?

st 7. 10. 2020 v 9:52 odesílatel WanCheng napsal: > Is same to the SemVer?(https://semver.org/) > no https://www.postgresql.org/support/versioning/ Regards Pavel

What version specification used by PG community developers?

Is same to the SemVer?(https://semver.org/)

Which is the setup with lowest resources you know Postgres is used in?

Hi all, I'm regularly reading that Postgres is often used with containers and in cloud environments these days, even on some not too powerful NAS. What are the lowest resource setups you know of or even host Postgres successfully with yourself? It's especially about RAM and CPU, if you needed to

Re: Handling time series data with PostgreSQL

Hi Adalberto, Awesome.!! Thanks for your reply. So, Do we need the timescaleDB as mandatory to handle time series data? Is there any way to handle hourly to days,months,yearly data with PGSQL alone without timescale addon? Ours is a new project and we are unsure about whether we should have both