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

Here is the basic structure - is the gist index significant?: CREATE UNLOGGED TABLE foo ( as_of_date daterange NOT NULL, customer_id integer, bunch_of_fields_here); ALTER TABLE ONLY foo ADD CONSTRAINT foo_as_of_date_excl EXCLUDE USING gist (customer_id WITH =, as_of_date WITH

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

On Tue, Feb 06, 2018 at 12:50:56AM -0600, Jeremy Finzel wrote: > The table I am setting to logged is 32GB with indexes. I see it writing > WAL files like crazy but after about an hour and a half, it has written out > some 2500 WAL segments, then it just sits and continues to run as "active", >

Found non-empty schema without metadata table error while migrating

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 non-empty

Alter table set logged hanging after writing out all WAL

We are running: PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit The table I am setting to logged is 32GB with indexes. I see it writing WAL files like crazy but after about an hour and a half, it has written out some 2500 WAL segments, then it just sits

Re: Postgres install

On 5 February 2018 at 19:01, Benjamin Scherrey wrote: > One option you should seriously consider is using Docker to containerize > your postgres installation. The installation thinks it has root access but > you don't need any rights beyond the standard user role that

Re: Postgres install

One option you should seriously consider is using Docker to containerize your postgres installation. The installation thinks it has root access but you don't need any rights beyond the standard user role that way you can use the standard builds without changes. This assumes you're running under

Re: Postgres install

On 02/05/2018 12:41 PM, Azimuddin Mohammed wrote: Hello, I need to install postgres without root privileges. I have a postgres user in our companies AD. Below are my questions n concerns: 1. Is there a website you will refer other the postgres documentation, the one on postgres website is

Postgres install

Hello, I need to install postgres without root privileges. I have a postgres user in our companies AD. Below are my questions n concerns: 1. Is there a website you will refer other the postgres documentation, the one on postgres website is confusing 2. What is the default location of postgress

Re: Regex Replace with 2 conditions

Denisa: 1.- Please, do not top-post, it makes seeing what you arereplying to difficult. 2.- Do not reply to several messages in one. Nobody reading this knows my suggestions. Having said that, regarding my part: On Mon, Feb 5, 2018 at 5:54 PM, Denisa Cirstescu

Re: Regex Replace with 2 conditions

On Mon, Feb 5, 2018 at 6:34 AM, Denisa Cirstescu < denisa.cirste...@tangoe.com> wrote: > Is there a way to specify 2 conditions in regexp_replace? > ​Tom and Francisco ​both give excellent responses. I have written a SQL function that achieves this, but I am not happy with > it because it is

Re: Regex Replace with 2 conditions

Denisa: On Mon, Feb 5, 2018 at 2:34 PM, Denisa Cirstescu wrote: > I need an SQL function that eliminates all ASCII characters from 1-255 that > are not A-Z, a-z, 0-9, and special characters % and _ so something like: Are you aware ASCII is a SEVEN bit code ? And

Re: weird result by changing type enum array to text array of a column

Hello Rob, I already read this. I have already executed this kind of procedure except with an array. I don't know why but now it is working :-s Thank you for your reply :-) Thomas 2018-02-05 13:16 GMT+01:00 rob stone : > > > On Mon, 2018-02-05 at 11:26 +0100, Thomas

Re: weird result by changing type enum array to text array of a column

On Mon, 2018-02-05 at 11:26 +0100, Thomas Poty wrote: > Hello, > > I m running 9.5.10 on centos 7. > > I have a colmun "TestFields", its type is an array of an enum. > > I would like to change the type of this column by an array of text. > > So i execute -> alter table

weird result by changing type enum array to text array of a column

Hello, I m running 9.5.10 on centos 7. I have a colmun "TestFields", its type is an array of an enum. I would like to change the type of this column by an array of text. So i execute -> alter table "controldetailpromoters" alter column "TestFields" type text[] The command seems to be

Replication slots for cascading replication.

Hi, I encountered an issue this weeked and was wondering if there is a simple solution to avoid this specific problem. A simplified database setup here i three servers, which uses streaming replication with replication slot on pg10.1 M: a "master" server C: a hot standby that cascades to ... S: