Documentation section F

I learnt yesterday that pgcrypto and uuid-ossp (possibly more) were included in the core. However, reading section F rose the impression that those are outside the core. Is this just me or can I help regroup the documentation at that point? -- Öffentlicher PGP-Schlüssel:

Re: [solved] Pgcrypto (PostgreSQL 10) on Debain 9?

Zitat von Raymond O'Donnell : Only a guess, but maybe you need to install the extension first? - create extension ; Thanks, right guess as I figured out yesterday evening after reading not only the module portion but the introduction to the modules. I also was mislead by

Re: Fwd: postgres instalation

I think I fig out what the issue here under the ./configure i need to mention man directory as well which I was missing let me ask this once the installation is I see a message "PostgreSQL installation complete" how many directories I should be seeing under my prefix directory I am seeing below

Re: Fwd: postgres instalation

May I know the use for doc and man here. Additionally I see the doc directory is getting created in the build directory and no the prefix directory I supplied On Tue, Feb 6, 2018 at 11:16 PM, Shreeyansh Dba wrote: > While you installing PostgreSQL via Source then by

Re: Fwd: postgres instalation

While you installing PostgreSQL via Source then by default it will contain only (Bin, lib, include, share) if you want to install the documentation (HTML and man pages) use following command:- make install-docs. On Wed, Feb 7, 2018 at 9:11 AM, Adrian Klaver

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

On Tue, Feb 06, 2018 at 03:58:14PM +, Raymond O'Donnell wrote: > On 06/02/18 13:25, Thiemo Kellner, NHC Barhufpflege wrote: >> But why do I get following error? >> ERROR: function gen_random_uuid() does not exist. >> create table ENTITY (ID uuid not null default gen_random_uuid()); > > Only a

Re: Alter table set logged hanging after writing out all WAL

On Tue, Feb 6, 2018 at 6:02 PM Michael Paquier wrote: > On Tue, Feb 06, 2018 at 01:36:04AM -0600, Jeremy Finzel wrote: > > Here is the basic structure - is the gist index significant?: > > > > CREATE UNLOGGED TABLE foo ( > > as_of_date daterange NOT NULL, > >

Re: Fwd: postgres instalation

On 02/06/2018 07:32 PM, Azimuddin Mohammed wrote: I built it from source code. It says contib is installed too. But i dont see thrm under the prefix directory. When you did the original build did you do make world or just make? See also:

Re: Fwd: postgres instalation

I built it from source code. It says contib is installed too. But i dont see thrm under the prefix directory. On Feb 6, 2018 9:17 PM, "Adrian Klaver" wrote: > On 02/06/2018 06:05 PM, Azimuddin Mohammed wrote: > >> >> Hello, >> I have installed postgres I saw the

Re: Fwd: postgres instalation

On 02/06/2018 06:05 PM, Azimuddin Mohammed wrote: Hello, I have installed postgres I saw the message postgres installation complete. But when I look in the install directory I only see bin lib include share I do not see man and docs, may I know how I can install the man and docs  and what

Fwd: postgres instalation

Hello, I have installed postgres I saw the message postgres installation complete. But when I look in the install directory I only see bin lib include share I do not see man and docs, may I know how I can install the man and docs and what is the use of it? -- Regards, Azim -- Regards,

Re: pgadmin4: not possible to create server

On 02/06/2018 03:11 PM, robert wrote: On 06.02.2018 23:33, Adrian Klaver wrote: On 02/06/2018 02:19 PM, robert wrote: So you pgAdmin4 running in a container on your local machine and Postgres running in the native OS(the OS is?) on your local machine. Is the Docker container set up to

Re: pgadmin4: not possible to create server

On 06.02.2018 23:33, Adrian Klaver wrote: On 02/06/2018 02:19 PM, robert wrote: So you pgAdmin4 running in a container on your local machine and Postgres running in the native OS(the OS is?) on your local machine. Is the Docker container set up to 'see' the local machine? what do you

Re: pgadmin4: not possible to create server

On 02/06/2018 02:19 PM, robert wrote: On 06.02.2018 23:12, Adrian Klaver wrote: On 02/06/2018 02:08 PM, robert wrote: On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i

Re: pgadmin4: not possible to create server

On 06.02.2018 23:12, Adrian Klaver wrote: On 02/06/2018 02:08 PM, robert wrote: On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command:

Re: pgadmin4: not possible to create server

On 06.02.2018 23:12, Adrian Klaver wrote: On 02/06/2018 02:08 PM, robert wrote: On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command:

Re: pgadmin4: not possible to create server

On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT_PASSWORD=admin"

Re: pgadmin4: not possible to create server

Add following in your pg_hba.conf, hostall all 0.0.0.0/ 0 md5 restart your Postgres database server and try to connect again from pgAdmin4. On Tue, Feb 6, 2018 at 10:54 PM, robert rottermann wrote: > Hi there, > > I have

Re: pgadmin4: not possible to create server

On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT_PASSWORD=admin" -d dpage/pgadmin4 I then could access it

Re: Regex Replace with 2 conditions

On Tue, 6 Feb 2018 17:57:33 +0100, Francisco Olarte wrote: >So, no question mark sent, I suspect your mail chain may be playing >tricks on you, or may be you are translating to 7 bits on purpose >since your mail came with the headers: > >Content-Type: text/plain;

Re: Regex Replace with 2 conditions

George: On Tue, Feb 6, 2018 at 4:46 PM, George Neuner wrote: > On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte > wrote: >>I repeat for the last time. YOU ARE NOT USING ASCII. ASCII IS A SEVEN >>BIT CODE, 0-128. "?" IS NOT IN THE ASCII CHARACTER

Re: Found non-empty schema without metadata table error while migrating

On 02/05/2018 10:52 PM, Abhra Kar wrote: Hi, Getting below error— exec] Flyway (Command-line Tool) v.1.1 [exec] [exec] Metadata table created: schema_version [exec] Schema initialized with version: 0 [exec] Flyway (Command-line Tool) v.1.1 [exec] [exec] ValidationException: Found

Re: Regex Replace with 2 conditions

On 2/6/2018 10:52 AM, David G. Johnston wrote: On Tue, Feb 6, 2018 at 8:46 AM, George Neuner >wrote: On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte > wrote: >I repeat

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

On 06/02/18 13:25, Thiemo Kellner, NHC Barhufpflege wrote: Zitat von Magnus Hagander : On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner wrote: pgcrypto and uuid-ossp are both in the core package for PostgreSQL 10. So, I take the

Re: Regex Replace with 2 conditions

On Tue, Feb 6, 2018 at 8:46 AM, George Neuner wrote: > On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte > wrote: > > > >I repeat for the last time. YOU ARE NOT USING ASCII. ASCII IS A SEVEN > >BIT CODE, 0-128. "?" IS NOT IN THE ASCII CHARACTER

Re: Regex Replace with 2 conditions

On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte wrote: >I repeat for the last time. YOU ARE NOT USING ASCII. ASCII IS A SEVEN >BIT CODE, 0-128. "?" IS NOT IN THE ASCII CHARACTER SET. What ASCII table are you reading? The question mark symbol is #63. It lies between

Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?

Zitat von Tom Lane : I believe the point of the recommendation is that if you only need type-4 UUIDs, you can get that from pgcrypto without needing the external dependency of the OSSP UUID library. This is a bit less urgent than when that text was written, because now we

Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?

Thiemo Kellner writes: > I consider using uuid as primary key type. The documentation of > uuid-ossp states > (https://www.postgresql.org/docs/10/static/uuid-ossp.html#idm46428633607040) > makes a note to consider the pgcrypto function instead but not why. >

Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?

In my testing, gen_random_uuid() is quite a bit faster than uuid_generate_v4(). Thx for sharing your experience. -- Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?op=get=0x8F70EFD2D972CBEF This message was sent

Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?

In my testing, gen_random_uuid() is quite a bit faster than uuid_generate_v4().

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

Zitat von Magnus Hagander : On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner wrote: pgcrypto and uuid-ossp are both in the core package for PostgreSQL 10. So, I take the documentation would be outdated? But why do I get following error?

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner wrote: > Hi all > > I use Debian Strech (9) with PostgreSQL repository (as described on > https://wiki.postgresql.org/wiki/Apt). I would like to use pgcrypto or > uuid-ossp but to the contrary of 9.x there is no

pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?

Hi all I consider using uuid as primary key type. The documentation of uuid-ossp states (https://www.postgresql.org/docs/10/static/uuid-ossp.html#idm46428633607040) makes a note to consider the pgcrypto function instead but not why. Can somebody shed some light on that matter? Kind

Re: PostgreSQL Active-Active

You can achieve this HA with forward and backward reverse synchronous streaming replication with 3 nodes automatic failover with pgpool in PostgreSQL. There is always downtime but it should not be more than a minute its depends on your hardware and network bandwidth speed availability. --

Re: PostgreSQL Active-Active

Dhandapani Shanmugam wrote: > Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > Sorry if this question has been addressed already. > What will be best open source HA for postgresql with zero RTO and RPO. No, PostgreSQL does not have a shared storage cluster technology

Re: Postgres install

Hi to all. I usually install Postgresql on my user to local development using the Postgresql Binaries I follow some tips from this link Installing Postgresql 9.1 to windows 7 from the binary zip distribution

Re: PostgreSQL Active-Active

Greetings, * Andreas Kretschmer (andr...@a-kretschmer.de) wrote: > Am 06.02.2018 um 12:01 schrieb Dhandapani Shanmugam: > >Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > >Sorry if this question has been addressed already. What will be best open > >source HA for

Re: PostgreSQL Active-Active

Greetings, * Dhandapani Shanmugam (postgresq...@gmail.com) wrote: > Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > Sorry if this question has been addressed already. What will be best open > source HA for postgresql with zero RTO and RPO. What you're probably

Re: Function execution is taking more than 2hrs

Raghavendra Rao J S V wrote: > Device id column logic has changed in my organization. > Therefore, I need to modify all the old device id values to new device id > value > of the tables which contains the device id column. > Old device id and new device id columns are mapped in

PostgreSQL Active-Active

Hi Gurus, Do we have active-active setup in postgreSQL, like we have in oracle RAC?. Sorry if this question has been addressed already. What will be best open source HA for postgresql with zero RTO and RPO. -D