postgresql-10 armhf repository

Hello, I would like to install postgresql-10 on raspberries. I followed this instructions : https://wiki.postgresql.org/wiki/Apt Unfortunatly after a "sudo apt-get update" I get the error : " Skipping acquire of configured file 'main/binary-armhf/Packages' as repository 'http://apt.postgresql

Re: Command line session and running queries

imp3 wrote: > I've run an update query inside command line tool (psql) then I've exit the > tool (closing the window). > > When I re-logged in, I've noticed in pg_stat_activity that my query was still > running. > I used the command pg_cancel_backend with the right PID, but it returned "f" > fe

Re: pg_sample

i have installed postgresql on centos. i want to use pg_sample. Do i need to install that separately of it's included in the postgresql -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: postgresql-10 armhf repository

> Is there any other repository with the last version of postgresql-10 armhf packages ? Postgre Docker images (alpine based) -arm32v5:https://hub.docker.com/r/arm32v5/postgres/ - arm32v6: https://hub.docker.com/r/arm32v6/postgres/ (for Raspberry PI 1 ) - arm32v7: https://hub.docker.com/

Upgrade/Downgrade

Hello, My postgres version is 10.4 and I want to downgrade it to 9.5. and one is at 9.2 and need to upgrade it to 9.5. Can someone please help how to do this. Unable to find anything online

Re: Upgrade/Downgrade

On 23 August 2018 12:51:08 CEST, Sonam Sharma wrote: >Hello, > >My postgres version is 10.4 and I want to downgrade it to 9.5. >and one is at 9.2 and need to upgrade it to 9.5. >Can someone please help how to do this. >Unable to find anything online Why downgrade? Dump and restore should do the j

MultiXactId 24018 has not been created yet -- apparent wraparound error

My team is confused as we are not doing anything then we experienced this in our staging environment. It's happening only in one of our tables. When we try fetch in that table, the message below returns project=# SELECT * FROM table_table; ERROR: MultiXactId 24018 has not been created yet -- appa

Re: Upgrade/Downgrade

No, I didn't. The version is not compatible with application, so need to downgrade it On Thu, Aug 23, 2018, 4:56 PM Andreas Kretschmer wrote: > On 23 August 2018 12:51:08 CEST, Sonam Sharma > wrote: > >Hello, > > > >My postgres version is 10.4 and I want to downgrade it to 9.5. > >and one is at

Re: Upgrade/Downgrade

On 23/08/2018 14:30, Sonam Sharma wrote: No, I didn't. The version is not compatible with application, so need to downgrade it Have you tried to tweak postgresql.conf ? What do you mean is not compatible? What's the problem? On Thu, Aug 23, 2018, 4:56 PM Andreas Kretschmer mailto:andr...@a-

Re: pg_sample

On 08/23/2018 12:10 AM, naveen12 wrote: i have installed postgresql on centos. i want to use pg_sample. Do i need to install that separately of it's included in the postgresql It is not included in the Postgres core or contrib packages. You will need to install it separately. -- Sent fr

Re: "checkpointer process" is consuming more memory. How to control it?

On 2018-08-22 11:14:48 -0300, Avi Vallarapu wrote: > Seams like you are with the default or fairly less checkpoint_* settings. > > You need to look at several patterns to understand the best values for > these settings. > > For now, i can say 300 seconds for checkpoint_timeout could be fairly ver

Re: MultiXactId 24018 has not been created yet -- apparent wraparound error

On 2018-Aug-23, Dean Armada wrote: > My team is confused as we are not doing anything then we experienced this > in our staging environment. It's happening only in one of our tables. When > we try fetch in that table, the message below returns > > project=# SELECT * FROM table_table; > ERROR: Mu

Re: pg_sample

sir from where should i install it. I tried but i didn't found separate link for pg_sample can you help me in this thanks On Thu, Aug 23, 2018 at 6:34 PM, Adrian Klaver wrote: > On 08/23/2018 12:10 AM, naveen12 wrote: > >> i have installed postgresql on centos. >> i want to use pg_sample. >>

Re: pg_sample

On 08/23/2018 07:39 AM, Naveen Dabas wrote: sir from where should i install it. I tried but  i didn't found separate  link for pg_sample can you help me in this I am guessing it is this: https://github.com/mla/pg_sample -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_sample

On 08/23/2018 07:39 AM, Naveen Dabas wrote: sir from where should i install it. I tried but  i didn't found separate  link for pg_sample can you help me in this Something similar: https://github.com/18F/rdbms-subsetter It is Python based and can be pip installed. thanks -- Adrian Kl

Re: Upgrade/Downgrade

On Thu, 23 Aug 2018 14:47:25 +0300 Achilleas Mantzios wrote: > What do you mean is not compatible? What's the problem? As I recall there's several SETs and some other stuff that v.10 spits out that earlier versions do not recognize. Nothing that a little sed script can't fix but you need to un

extracting the sql for a function

Using postgres Version 9.5 I can extract the sql for a table using pg_dump  -d database_name  -s  -t  table_name  -f  table_name.sql Is there something equivalent for extracting the sql for a function from the database? Paul Tilles

RE: extracting the sql for a function

-Original Message- From: Paul Tilles [mailto:paul.til...@noaa.gov] Sent: Thursday, August 23, 2018 1:18 PM To: pgsql-gene...@postgresql.org Subject: extracting the sql for a function WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE ris

Re: Upgrade/Downgrade

On 08/23/2018 04:47 AM, Achilleas Mantzios wrote: On 23/08/2018 14:30, Sonam Sharma wrote: No, I didn't. The version is not compatible with application, so need to downgrade it Have you tried to tweak postgresql.conf ? What do you mean is not compatible? What's the problem? My guess would be

RE: extracting the sql for a function

Hello > -Original Message- > From: Paul Tilles [mailto:paul.til...@noaa.gov] > Sent: Donnerstag, 23. August 2018 19:18 > To: pgsql-gene...@postgresql.org > Subject: extracting the sql for a function > > Using postgres Version 9.5 > > I can extract the sql for a table using > > pg_dump

Re: extracting the sql for a function

*>is there something equivalent for extracting the sql for a function from the database? * *Have a look at pg_extractor. It is essentially a pg_dump but with many more options.* *https://github.com/omniti-labs/pg_extractor * On Thu, Aug 23, 2018 at 2:

Re: Upgrade/Downgrade

On Thu, Aug 23, 2018 at 11:44 AM Joshua D. Drake wrote: > On 08/23/2018 04:47 AM, Achilleas Mantzios wrote: > > On 23/08/2018 14:30, Sonam Sharma wrote: > >> No, I didn't. The version is not compatible with application, so need > >> to downgrade it > > > > Have you tried to tweak postgresql.conf

Is my text_pattern_ops index working for a LIKE prefix search with column reference?

hi, I created an index with text_pattern_ops because I want fast prefix search [1] [2]. CREATE INDEX ON mytable USING BTREE (state, city, address text_pattern_ops); (Note it's composite - I'm looking for prefixes on the address part only.) I can see that it "works" (purely uses the index) for

Join condition parsing puzzle

I'm looking at a query generated by SQLAlchemy. It works; Postgres is perfectly happy to run it, and it gives answers that make sense to the guy who wrote it. But I don't understand why it works. Stripped way down ... CREATE VIEW relation_a (id_c, id_v) AS VALUES (1, 20), (2, 21), (3, 22); CREA

Re: Join condition parsing puzzle

Mark Jeffcoat writes: > SELECT * > FROM relation_a > LEFT JOIN relation_b > JOIN relation_c > ON (relation_c.id_p = relation_b.id_p) > ON (relation_a.id_c = relation_b.id_c AND relation_a.id_v = relation_b.id_v); > I would have claimed before seeing this example that it wasn't even > grammatical;

Re: Is my text_pattern_ops index working for a LIKE prefix search with column reference?

Seamus Abshere wrote: > I created an index with text_pattern_ops because I want fast prefix search > [1] [2]. > > ...but I don't think it's working when I use a column reference || '%'... An index can only be used for expressions like and you have a column refrence on the right side. Pe

[no subject]

Hi All, In order to implment connection pool mechanisam, we have decided to use pg_bouncer. But due to some dependent software's like openssl we are not going to use pg_bouncer. Therefore we are planning to use pgpool to implement the connection pool mechanisam in my applicaiton. We don't have m

Which are the settings need to be modified inorder to implement only connection pool mechanisam in pgpool

Hi All, In order to implment connection pool mechanisam, we have decided to use pg_bouncer. But due to some dependent software's like openssl we are not going to use pg_bouncer. Therefore we are planning to use pgpool to implement the connection pool mechanisam in my applicaiton. We don't have m

Re: Is my text_pattern_ops index working for a LIKE prefix search with column reference?

Laurenz Albe writes: > Seamus Abshere wrote: >> I created an index with text_pattern_ops because I want fast prefix search >> [1] [2]. >> ...but I don't think it's working when I use a column reference || '%'... > An index can only be used for expressions like > > and you have a column ref

Re: Upgrade/Downgrade

On 23/08/2018 22:40, Nikolay Samokhvalov wrote: On Thu, Aug 23, 2018 at 11:44 AM Joshua D. Drake mailto:j...@commandprompt.com>> wrote: On 08/23/2018 04:47 AM, Achilleas Mantzios wrote: > On 23/08/2018 14:30, Sonam Sharma wrote: >> No, I didn't. The version is not compatible with app