Re: [GENERAL] PGSQL 9.6.2 unable to find readline

On Tuesday, March 7, 2017 3:35 PM, John Iliffe wrote:   >  > Trying to compile pgsql 9.6.2 on Fedora 25  >  > I get the following message:  >  > configure:9345: error: readline library not found  > If you have readline already installed, see config.log for details on the  > Use --without-r

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

On 03/07/2017 01:33 PM, John Iliffe wrote: Perfect! Thank you. Same issue then occurred with zlib and I installed the dev pieces and it worked too. Might be a good idea if the documentation listed these somewhere as prereqs. In the past all the servers I have worked on had these installed

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

Perfect! Thank you. Same issue then occurred with zlib and I installed the dev pieces and it worked too. Might be a good idea if the documentation listed these somewhere as prereqs. In the past all the servers I have worked on had these installed already but this one is a bit basic. Regard

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

Hi, On Tue, 2017-03-07 at 15:38 -0500, John Iliffe wrote: > Trying to compile pgsql 9.6.2 on Fedora 25  > > I get the following message: > > configure:9345: error: readline library not found Please install readline-devel. (BTW, https://yum.PostgreSQL.org has 9.6.2 and Fedora 25 RPMs already)

[GENERAL] PGSQL 9.6.2 unable to find readline

Trying to compile pgsql 9.6.2 on Fedora 25 I get the following message: configure:9345: error: readline library not found If you have readline already installed, see config.log for details on the Use --without-readline to disable readline support. pgac_cv_check_readline=no libreadline does exis

Re: [GENERAL] [pgsql-GENERAL] AUTOVACUUM and Streaming Replication in v9.5

On Fri, 16 Dec 2016, 12:10 a.m. Sameer Kumar, wrote: > Hi, > > I was wondering if there is some change in the way > max_standby_streaming_delay and hot_standby_feedback work in v9.5. > > Below is a scenario which I had built to test out something but the > behavior confused me. I would like to ch

[GENERAL] [pgsql-GENERAL] AUTOVACUUM and Streaming Replication in v9.5

Hi, I was wondering if there is some change in the way max_standby_streaming_delay and hot_standby_feedback work in v9.5. Below is a scenario which I had built to test out something but the behavior confused me. I would like to check if there is something/some parameter which I am missing or if m

Re: [GENERAL] PgSQL versions supported on ubuntu 16 and debian 8

John R Pierce wrote: > On 9/19/2016 4:18 AM, MEERA wrote: > > > >Could someone please provide us this information? > > was answered nearly a week ago. Hmm, yeah, but you didn't CC the OP, and she is not subscribed. Meera: you can see the answer here: https://www.postgresql.org/message-id/flat/CA

Re: [GENERAL] PgSQL versions supported on ubuntu 16 and debian 8

On 9/19/2016 4:18 AM, MEERA wrote: Could someone please provide us this information? was answered nearly a week ago. any current PG version (thats 9.1.latest to 9.5.latest) can be run on most any version of linux.Do note, 9.1 will be phased out soon, while 9.6 is nearly ready for releas

Re: [GENERAL] PgSQL versions supported on ubuntu 16 and debian 8

Hi, Could someone please provide us this information? On Thu, Sep 15, 2016 at 1:10 PM, MEERA wrote: > Hi, > > Could someone share below information? > > - PgSQL versions supported on ubuntu 16 > - PgSQL versions supported on debian 8 > > > -- > thanks and regards, > Meera R Nair > -- thanks

Re: [GENERAL] PgSQL versions supported on ubuntu 16 and debian 8

On 9/15/2016 12:40 AM, MEERA wrote: Could someone share below information? - PgSQL versions supported on ubuntu 16 - PgSQL versions supported on debian 8 any current PG version (thats 9.1.latest (likely to be deprecated soon when 9.6 releases) to 9.5.latest) can be run on most any version o

[GENERAL] PgSQL versions supported on ubuntu 16 and debian 8

Hi, Could someone share below information? - PgSQL versions supported on ubuntu 16 - PgSQL versions supported on debian 8 -- thanks and regards, Meera R Nair

Re: [GENERAL] Pgsql troubleshooting & Iscsi

Hej all, Sorry for the late answer. I faced the same problem installing PostgreSQL 9.5.2 server on my RHEL 7.2 server. I solved it by doing the following. 1. vi /etc/fstab . . . UUID=19881aa7-699a-41ff-bd65-216e1d3de62c/var/lib/pgsql/9.5xfs _netdev0 0 2. vi /usr/lib/systemd/sys

Re: [GENERAL] Pgsql troubleshooting & Iscsi

On Wed, Feb 17, 2016 at 06:07:29PM +0100, p...@free.fr wrote: > Hi everybody, > > I installed a postgresql database on Redhat 7.1 and I decided to move the > database on an ISCSI device (LUN) inside a logical volume, mounted at > starting of the machine (xfs formatted). The mounting point is /var/

[GENERAL] Pgsql troubleshooting & Iscsi

51:42 +0100 (CET) Objet: Re: [GENERAL] Pgsql troubleshooting & Iscsi On 02/17/2016 06:07 PM, p...@free.fr wrote: > Hi everybody, > > I installed a postgresql database on Redhat 7.1 and I decided to move the > database on an ISCSI device (LUN) inside a logical volume, mounted

Re: Re : Re: [GENERAL] Pgsql troubleshooting & Iscsi

(CET) Objet: Re: [GENERAL] Pgsql troubleshooting & Iscsi On 02/17/2016 09:07 AM, p...@free.fr wrote: Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (

Re : Re: [GENERAL] Pgsql troubleshooting & Iscsi

nvoyé: Wed, 17 Feb 2016 18:35:15 +0100 (CET) Objet: Re: [GENERAL] Pgsql troubleshooting & Iscsi On 02/17/2016 09:07 AM, p...@free.fr wrote: > Hi everybody, > > I installed a postgresql database on Redhat 7.1 and I decided to move the > database on an ISCSI device (LUN) inside a logic

Re: [GENERAL] Pgsql troubleshooting & Iscsi

On 02/17/2016 06:07 PM, p...@free.fr wrote: Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot o

Re: [GENERAL] Pgsql troubleshooting & Iscsi

On 02/17/2016 09:07 AM, p...@free.fr wrote: Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot o

[GENERAL] Pgsql troubleshooting & Iscsi

Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot of the server, postgresql.service is in failed

Re: [GENERAL] [pgsql-es-ayuda] No funciona WITH con mas de 2 sentencias DML

Hellmuth Vargas escribió: > Hola Lista > > Estaba realizando un cargue de un archivo Excel con información de clientes > bancarios con tarjeta para un call center poblando un modelo maestro, > detalle y tabla de llamadas telefónicas. En un principio se implemento por > medio de una herramienta de

Re: [GENERAL] pgsql-95 repo in rsync

On ti., 2015-09-22 at 14:33 +0300, Devrim GÜNDÜZ wrote: Hi, On Mon, 2015-09-21 at 12:46 +, Kjetil Nygård wrote: 1. rsync Would it be possible to have PostgreSQL 9.5 in the rsync-repo? This is now done. Thanks a lot :-D -- Med vennleg helsing Kjetil Nygård Technical Expert | Ambita

Re: [GENERAL] pgsql-95 repo in rsync

Hi, On Mon, 2015-09-21 at 12:46 +, Kjetil Nygård wrote: > > 1. rsync > Would it be possible to have PostgreSQL 9.5 in the rsync-repo? This is now done. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] pgsql-95 repo in rsync

Hi, On Mon, 2015-09-21 at 15:46 -0700, Adrian Klaver wrote: > In other words not sure what Postgres has to do with rsync? I think OP refers to the YUM repo. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] pgsql-95 repo in rsync

Hi, On Mon, 2015-09-21 at 12:46 +, Kjetil Nygård wrote: > 1. rsync > Would it be possible to have PostgreSQL 9.5 in the rsync-repo? Emailed PostgreSQL.org sysadmins, and I'll let you know when that is done. > 2. yum repo for Fedora 23 > Is it possible to have fedora 23-repo for PostgreSQL

Re: [GENERAL] pgsql-95 repo in rsync

On 9/21/2015 5:46 AM, Kjetil Nygård wrote: 2. yum repo for Fedora 23 Is it possible to have fedora 23-repo for PostgreSQL? Especially 9.4 and 9.5. I thought F23 starts beta next week? it appears 9.4.4 is included in the F23 base repository. postgres 9.5 is itself still in beta. -- john r pi

Re: [GENERAL] pgsql-95 repo in rsync

On 09/21/2015 05:46 AM, Kjetil Nygård wrote: Hi, I have two questions about PostgreSQL repositories: 1. rsync Would it be possible to have PostgreSQL 9.5 in the rsync-repo? I am not understanding what you mean above. In other words not sure what Postgres has to do with rsync? 2. yum repo

[GENERAL] pgsql-95 repo in rsync

Hi, I have two questions about PostgreSQL repositories: 1. rsync Would it be possible to have PostgreSQL 9.5 in the rsync-repo? 2. yum repo for Fedora 23 Is it possible to have fedora 23-repo for PostgreSQL? Especially 9.4 and 9.5. *** Is there anything I can do, to help with this? -- Med v

Re: [GENERAL] [pgsql-general] Daily digest v1.13732 (15 messages)

On Tue, 2015-08-25 at 15:41 +, Neil Tiffin wrote: > I really like the standardization that PostgreSQL uses in auto > generating default names. The rule I use is to always use the auto > generated names unless the object is referenced routinely in code. In > most cases developers don’t care

Re: [GENERAL] [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA

Joshua D. Drake wrote: > > On 05/06/2015 08:11 AM, Sujit K M wrote: > > > >On Wed, May 6, 2015 at 8:35 PM, Jason May wrote: > >>You find the description offensive? That’s interesting. You're very > >>easily offended. I think it reads more like an Engineer than a DBA > > > >lol, you are cribbin

Re: [GENERAL] [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA

On 05/06/2015 08:11 AM, Sujit K M wrote: On Wed, May 6, 2015 at 8:35 PM, Jason May wrote: You find the description offensive? That’s interesting. You're very easily offended. I think it reads more like an Engineer than a DBA lol, you are cribbing like a third graders looking for some fr

Re: [GENERAL] [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA

On Wed, May 6, 2015 at 8:35 PM, Jason May wrote: > You find the description offensive? That’s interesting. You're very easily > offended. I think it reads more like an Engineer than a DBA lol, you are cribbing like a third graders looking for some freshman. I am not offended, I found it offen

Re: [GENERAL] pgsql age function showing 00:00:00 with year argument

Arup Rakshit wrote: > yelloday-staging::YELLOW=> select id, dob from users; > id | dob > +- > 13 | > 9 | 1967-02-13 14:00:00 > 10 | > 11 | > 8 | 1977-06-05 14:00:00 > 15 | > 21 | > 14 | 2014-05-25 14:00:00 > 37 | > 22 | > 26 | 2014-05-06 14:00:00 > 32

[GENERAL] pgsql age function showing 00:00:00 with year argument

Look the below 2 scenarios :- yelloday-staging::YELLOW=> select id, dob from users;  id |         dob          +-  13 |    9 | 1967-02-13 14:00:00  10 |   11 |    8 | 1977-06-05 14:00:00  15 |   21 |   14 | 2014-05-25 14:00:00  37 |   22 |   26 | 2014-05-06 14:00:00  32 | 

Re: [GENERAL] pgsql in a virtual environment

=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= writes: > 2014-05-16 11:56 GMT-03:00 Graeme Gemmill : >> $ ./pg_ctl start -D /mnt/post/pgsql/data & >> [1] 3692 >> [postgres@localhost bin]$ pg_ctl: could not open PID file >> "/mnt/post/pgsql/data/postmaster.pid": Protocol error > Looks like a libpq - backend

Re: [GENERAL] pgsql in a virtual environment

2014-05-16 11:56 GMT-03:00 Graeme Gemmill : > $ ./pg_ctl start -D /mnt/post/pgsql/data & > [1] 3692 > [postgres@localhost bin]$ pg_ctl: could not open PID file > "/mnt/post/pgsql/data/postmaster.pid": Protocol error > > [1]+ Exit 1 ./pg_ctl start -D /mnt/post/pgsql/data > Is there

[GENERAL] pgsql in a virtual environment

I am running a postgresql application under Mandriva 2011 x86_64, and want to explore the problems in porting it to a Mageia 4 x86_64 environment before actually upgrading. I have installed Mageia 4 as a virtual machine under VBox, installed postgresql 9.3 and sorted out a shared folder to get

Re: [GENERAL] pgsql and asciidoc output

On 2/11/14, 6:25 PM, Vik Fearing wrote: > I personally find Markdown to be more pleasing to the eye than AsciiDoc. Markdown can embed HTML tables, so there is nothing that we need to implement. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] pgsql and asciidoc output

On Wed, Feb 12, 2014 at 08:48:49AM +0100, Gabriele Bartolini wrote: > I second Bruce. I massively use asciidoc. I guess adding both asciidoc and md > would not be too hard. Agreed. Assuming there are no objections, I will add it to the TODO list. -- Bruce Momjian http://momjian.us

Re: [GENERAL] pgsql and asciidoc output

On Wed, Feb 12, 2014 at 06:02:29AM +0100, Pavel Stehule wrote: > Perhaps, but if we're going to add a text markup format then we'll have > to choose one out of many. > > I personally find Markdown to be more pleasing to the eye than AsciiDoc. > http://en.wikipedia.org/wiki/Markdown

Re: [GENERAL] pgsql and asciidoc output

On Tue, Feb 11, 2014 at 03:32:32PM -0800, Steve Atkins wrote: > > On Feb 11, 2014, at 2:56 PM, Bruce Momjian wrote: > > > Someone suggested that 'asciidoc' > > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > > for psql, similar to the existing output formats of html, late

Re: [GENERAL] pgsql and asciidoc output

> From: Bruce Momjian > To: PostgreSQL-general > Sent: Tuesday, 11 February 2014, 22:56 > Subject: [GENERAL] pgsql and asciidoc output > > Someone suggested that 'asciidoc' > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > for ps

Re: [GENERAL] pgsql and asciidoc output

I second Bruce. I massively use asciidoc. I guess adding both asciidoc and md would not be too hard. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it 2014-02-12 6:02 GMT+01:00 Pavel St

Re: [GENERAL] pgsql and asciidoc output

2014-02-12 0:25 GMT+01:00 Vik Fearing : > On 02/11/2014 11:56 PM, Bruce Momjian wrote: > > Someone suggested that 'asciidoc' > > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > > for psql, similar to the existing output formats of html, latex, and > > troff. > > > > Would t

Re: [GENERAL] pgsql and asciidoc output

On Feb 11, 2014, at 2:56 PM, Bruce Momjian wrote: > Someone suggested that 'asciidoc' > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > for psql, similar to the existing output formats of html, latex, and > troff. > > Would this be useful? Less so than Markdown[1], IMO.

Re: [GENERAL] pgsql and asciidoc output

On 02/11/2014 11:56 PM, Bruce Momjian wrote: > Someone suggested that 'asciidoc' > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > for psql, similar to the existing output formats of html, latex, and > troff. > > Would this be useful? > Perhaps, but if we're going to add a

[GENERAL] pgsql and asciidoc output

Someone suggested that 'asciidoc' (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format for psql, similar to the existing output formats of html, latex, and troff. Would this be useful? -- Bruce Momjian http://momjian.us EnterpriseDB http:

Re: [GENERAL] PGSQL: listing db/role and user/role relationships

On Mon, Nov 18, 2013 at 4:00 AM, Felipe Gasper wrote: > One more question: how “stable” are these interfaces? Are they by chance > available via information_schema? Enough stable that they have not changed so much since 8.3. But I'm not used to the information_schema, so I don't know which are e

Re: [GENERAL] PGSQL: listing db/role and user/role relationships

On 17.11.13 2:56 AM, Luca Ferrari wrote: On Sat, Nov 16, 2013 at 1:19 AM, Felipe Gasper wrote: Hi all, How can I retrieve: 1) each role’s privileges on a given DB Do you mean pg_database.datacl? http://www.postgresql.org/docs/current/static/catalog-pg-database.html 2) which use

Re: [GENERAL] PGSQL: listing db/role and user/role relationships

On Sat, Nov 16, 2013 at 1:19 AM, Felipe Gasper wrote: > Hi all, > > How can I retrieve: > > > 1) each role’s privileges on a given DB > Do you mean pg_database.datacl? http://www.postgresql.org/docs/current/static/catalog-pg-database.html > 2) which users have access to a given role > 3)

[GENERAL] PGSQL: listing db/role and user/role relationships

Hi all, How can I retrieve: 1) each role’s privileges on a given DB For example, if I do: “GRANT ALL PRIVILEGES ON DATABASE thedb TO therole”, how can I list this grant among others with access to “thedb”? 2) which users have access to a given role For example, if I do: “GRANT the

Re: [GENERAL] PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken

om: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Edson Richter Sent: Friday, December 14, 2012 2:58 PM To: pgsql-general Subject: [GENERAL] PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken I just discovered

Re: [GENERAL] PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken

--Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Edson Richter > Sent: Friday, December 14, 2012 2:58 PM > To: pgsql-general > Subject: [GENERAL] PgSQL 9.1: Warning - error 10061 on Windows, no error >

[GENERAL] PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken

I just discovered a non PostgreSQL problem (but I was suspecting all the time from PostgreSQL). I'm recording this because would save lot of time from others in the list, since my problem is already solved. During this day, we had very busy servers and suddenly we started to get error 500 an

Re: [GENERAL] pgsql server reset the connection immediately after connected

On Fri, Nov 2, 2012 at 2:43 PM, Dongkuo Ma wrote: > I connect to database and then fork a new process! > Now it's ok. > Thanks. Ah, yes, that would be a dangerous thing to do :) ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] pgsql server reset the connection immediately after connected

I connect to database and then fork a new process! Now it's ok. Thanks. On Fri, Nov 2, 2012 at 11:17 AM, Adrian Klaver wrote: > On 11/01/2012 07:57 PM, Dongkuo Ma wrote: > >> Hi >> the python code is >> >> logging.info ("**database connecting...") >> >> conn = connect(databas

Re: [GENERAL] pgsql server reset the connection immediately after connected

On Fri, Nov 2, 2012 at 1:57 PM, Dongkuo Ma wrote: > Hi > the python code is > > logging.info("database connecting...") > conn = connect(database="dbname", user="user", > password="password",host="127.0.0.1") > logging.info("database connected") > conn.autocommit = True > conn.set_client_encoding('

Re: [GENERAL] pgsql server reset the connection immediately after connected

On 11/01/2012 07:57 PM, Dongkuo Ma wrote: Hi the python code is logging.info ("database connecting...") conn = connect(database="dbname", user="user", password="password",host="127.0.0.1") logging.info ("database connected") conn.autocommit = True conn.s

Re: [GENERAL] pgsql server reset the connection immediately after connected

Hi the python code is logging.info("database connecting...") conn = connect(database="dbname", user="user", password="password",host="127.0.0.1") logging.info("database connected") conn.autocommit = True conn.set_client_encoding('UTF8') cur = conn.cursor() #the above code executed without exceptio

Re: [GENERAL] pgsql server reset the connection immediately after connected

On 11/01/2012 07:32 PM, Dongkuo Ma wrote: Sorry! I typed the enter key and sent the uncomplete message. The psycopg2 connect function succesed,but throw a exception server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the req

Re: [GENERAL] pgsql server reset the connection immediately after connected

On 11/01/2012 07:24 PM, Dongkuo Ma wrote: Hi Sorry for my English. I'm running pgsql8.4 server on debian,the client is the python library(psycopg2) on the same mechine. The client connect server via 127.0.0.1:5432 . The psycopg2 connect function /succesed,but throw a excep

Re: [GENERAL] pgsql server reset the connection immediately after connected

Sorry! I typed the enter key and sent the uncomplete message. The psycopg2 connect function succesed,but throw a exception server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. when executing any sql statement. Us

[GENERAL] pgsql server reset the connection immediately after connected

Hi Sorry for my English. I'm running pgsql8.4 server on debian,the client is the python library(psycopg2) on the same mechine. The client connect server via 127.0.0.1:5432. The psycopg2 connect function *succesed,but throw a exception * server closed the connection unexpectedly This probably mea

Re: [GENERAL] [pgsql-es-ayuda] como exportar separado por comas una tabla grande

> > data=# \o /tmp/datos_para_proceso.csv > > data=# select * from datos_para_proceso; > > /opt/PostgreSQL/9.2/bin/psql: lí­nea 30: 9608 Terminado (killed) > > LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib > > "$PG_BIN_PATH/psql.bin" "$@" Moshe Jacobson escribió: > More i

Re: [GENERAL] [pgsql-es-ayuda] como exportar separado por comas una tabla grande

Hola Alejandro Muchas gracias!! la verdad no me acordaba que el copy podía funcionar en doble via!!! 2012/10/24 Alejandro Carrillo > http://www.postgresql.org/docs/current/static/sql-copy.html > > -- > *De:* Hellmuth Vargas > *Para:* Lista Postgres ES ; > pgsql-

Re: [GENERAL] [pgsql-es-ayuda] como exportar separado por comas una tabla grande

More important than the solution to this specific problem is the question of why psql crashed when doing this export... 2012/10/24 Alejandro Carrillo > http://www.postgresql.org/docs/current/static/sql-copy.html > > -- > *De:* Hellmuth Vargas > *Para:* Lista Postgr

Re: [GENERAL] [pgsql-es-ayuda] como exportar separado por comas una tabla grande

http://www.postgresql.org/docs/current/static/sql-copy.html > > De: Hellmuth Vargas >Para: Lista Postgres ES ; >pgsql-general@postgresql.org >Enviado: Miércoles 24 de octubre de 2012 12:22 >Asunto: [pgsql-es-ayuda] como exportar separado por comas una tabla gr

Re: [GENERAL] [pgsql-cluster-hackers] advice on Replication for a Specific Scenario

Thank you Greg. I will have a look at Slony in the first instance. I have a great deal of preparatory work to do before I look at it in detail. Thanks again. Regards, Donald -Original Message- From: pgsql-cluster-hackers-ow...@postgresql.org [mailto:pgsql-cluster-hackers-ow...@postgre

Re: [GENERAL] Pgsql problem

Thanks. Hstore works perfectly. pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Pgsql problem

On Πεμ 12 Ιαν 2012 12:51:00 pasman pasmański wrote: > Hi. > > I write function in pgsql. This function needs > to execute other functions by name. > I do it using loop: > > declare r record; > begin > for r in execute 'select ' || $1 || '()' > loop > end loop; > > But I can't convert a recor

Re: [GENERAL] Pgsql problem

Hey pasman, 2012/1/12 pasman pasmański > Hi. > > I write function in pgsql. This function needs > to execute other functions by name. > I do it using loop: > > declare r record; > begin > for r in execute 'select ' || $1 || '()' > loop > end loop; > > But I can't convert a record to array of t

[GENERAL] Pgsql problem

Hi. I write function in pgsql. This function needs to execute other functions by name. I do it using loop: declare r record; begin for r in execute 'select ' || $1 || '()' loop end loop; But I can't convert a record to array of text. How to do it ? pasman -- Sent via pgsql-g

Re: [GENERAL] pgsql error

11 9:40 AM To: Mcleod, John Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pgsql error On Tue, Jul 26, 2011 at 7:47 AM, Mcleod, John wrote: > Thank you for the reply. > > At command line, I ran... > "psql  --version" > and received.. > "psql  (PostgreSQL) 7.5

Re: [GENERAL] pgsql error

"Mcleod, John" writes: > Thank you for the reply. > At command line, I ran... > "psql --version" > and received.. > "psql (PostgreSQL) 7.5devel" Egad. That is an early development snapshot of what eventually got called the 8.0 release. You should try "select version();" in psql to verify that

Re: [GENERAL] pgsql error

On Tue, Jul 26, 2011 at 7:47 AM, Mcleod, John wrote: > Thank you for the reply. > > At command line, I ran... > "psql  --version" > and received.. > "psql  (PostgreSQL) 7.5devel" > > The database is sitting on a Windows 2003 Server box. > A mapping application, wrote in PHP, runs with Apache 2.05

Re: [GENERAL] pgsql error

John -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, July 25, 2011 11:20 PM To: Merlin Moncure Cc: Mcleod, John; pgsql-general@postgresql.org Subject: Re: [GENERAL] pgsql error Merlin Moncure writes: > On Mon, Jul 25, 2011 at 3:05 PM, Mcleod, John w

Re: [GENERAL] pgsql error

Merlin Moncure writes: > On Mon, Jul 25, 2011 at 3:05 PM, Mcleod, John wrote: >> I'm receiving the following error >> CONTEXT: writing block 614 of relation 394198/412175 >> WARNING: could not write block 614 of 394198/412175 >> DETAIL: Multiple failures --- write error may be permanent. >> ERROR

Re: [GENERAL] pgsql error

On Mon, Jul 25, 2011 at 3:05 PM, Mcleod, John wrote: > Hello all, > > I'm new to pgsql and I'm taking over for a project manager that left the > company. > > I'm receiving the following error… > > > > CONTEXT: writing block 614 of relation 394198/412175 > > WARNING: could not write block 614 of 39

Re: [GENERAL] pgsql error

2011/7/25 Mcleod, John : > Hello all, > > I'm new to pgsql and I'm taking over for a project manager that left the > company. > > I'm receiving the following error… > > > > CONTEXT: writing block 614 of relation 394198/412175 > > WARNING: could not write block 614 of 394198/412175 > > DETAIL: Multi

[GENERAL] pgsql error

Hello all, I'm new to pgsql and I'm taking over for a project manager that left the company. I'm receiving the following error... CONTEXT: writing block 614 of relation 394198/412175 WARNING: could not write block 614 of 394198/412175 DETAIL: Multiple failures --- write error may be permanent. ER

[GENERAL] pgsql ODBC text escaping issue

Hi all, I have a problem on text escaping. In my application, I have a table offlinemsg, which has one column id with long, and has another column msg with text. pgsql ODBC and dynamic SQL binding was used when I tried to insert data into offlinemsg. the sql is : insert into offlinemsg values(?, ?

Re: [GENERAL] pgsql 9.0.1 table corruption

Benjamin Smith writes: > On Friday, April 15, 2011 09:50:57 AM Tom Lane wrote: >> If you simply unpacked the tar archive and started a postmaster on that, >> you'd be pretty much guaranteed to get a corrupt database. The tar >> archive is not a valid snapshot by itself --- you have to replay >> w

Re: [GENERAL] pgsql 9.0.1 table corruption

On Friday, April 15, 2011 09:50:57 AM Tom Lane wrote: > If you simply unpacked the tar archive and started a postmaster on that, > you'd be pretty much guaranteed to get a corrupt database. The tar > archive is not a valid snapshot by itself --- you have to replay > whatever WAL was generated duri

Re: [GENERAL] pgsql 9.0.1 table corruption

Dan Biagini writes: > I have a 9.0.1 database with two corrupted tables (one table has 20 > rows, the other 140). The tables *seem* fine for read/select > operations, but updating certain rows in the table produce error > messages: > update media set updated_at = now() at time zone 'UTC'; > ERRO

Re: [GENERAL] pgsql 9.0.1 table corruption

On April 14, 2011 08:10:47 am Dan Biagini wrote: > I suspect that it may have occurred during a filesystem level backup > (ie pg_start_backup(), tar -czf..., pg_stop_backup()), as I performed > a backup and moved the database to a different system. After > restoring the files and starting postgre

[GENERAL] pgsql 9.0.1 table corruption

I have a 9.0.1 database with two corrupted tables (one table has 20 rows, the other 140). The tables *seem* fine for read/select operations, but updating certain rows in the table produce error messages: update media set updated_at = now() at time zone 'UTC'; ERROR: could not read block 2 in fil

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On 22/11/10 07:40, Elliot Chance wrote: > It does surprise me a bit that when I (or someone else) signs up to a mailing > list (not postgres specifically) that there is no fine print or agreement > that says something along the lines of "Your email address will be plastered > all over the inter

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Mon, Nov 22, 2010 at 10:40:34AM +1100, Elliot Chance wrote: > It does surprise me a bit that when I (or someone else) signs up to > a mailing list (not postgres specifically) that there is no fine > print or agreement that says something along the lines of "Your > email address will be plastered

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Mon, 2010-11-22 at 10:40 +1100, Elliot Chance wrote: > > I would argue that if the person wants to use a forum, aren't they > > saying they don't want to be contacted via email. I think we just throw > > it only to the forum (that is the user) and leave it that. Forum users > > don't get the

Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On 21/11/2010, at 2:59 AM, Bruce Momjian wrote: > Magnus Hagander wrote: >> On Sat, Nov 20, 2010 at 14:46, Elliot Chance wrote: > for...@postgresql.com.au is pointed to a black hole so that email > disappears but the mailing list gets another copy. When the mailing list > gets its c

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On 21 Nov 2010, at 16:16, Trevor Talbot wrote: >> I do see a difficulty here; if the forum software is only subscribed with >> one e-mail address, how is it going to distinguish between a reply-all and a >> private reply? >> Maybe it would help to subscribe it using two or three addresses, so tha

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

Alban Hertroys writes: > I'm not one of the people who've been communicating off-list about this with > him, so I may be wrong, but to my understanding what Magnus wants (the > requirement, not a solution to it) is this: > - Person A is on the forums and sends a message that ends up on the ML (

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Sun, Nov 21, 2010 at 18:12, Tom Lane wrote: > Alban Hertroys writes: >> I'm not one of the people who've been communicating off-list about this with >> him, so I may be wrong, but to my understanding what Magnus wants (the >> requirement, not a solution to it) is this: > >> - Person A is on

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On 11/21/2010 06:04 AM, Alban Hertroys wrote: > On 21 Nov 2010, at 24:17, Trevor Talbot wrote: > >>> I can't explain it any clearer, your email response goes to the mailing >>> list and that mailing list sends a copy to the original person thats how a >>> mailing list works. It also sends a copy

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Sun, Nov 21, 2010 at 05:04, Alban Hertroys wrote: > On 21 Nov 2010, at 24:17, Trevor Talbot wrote: >> Elliot, Magnus wants forum->list email to come from a per-user address >> so that when he replies directly to that address (without sending it >> to the list), the response is mapped to a PM.

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On 21 Nov 2010, at 24:17, Trevor Talbot wrote: >> I can't explain it any clearer, your email response goes to the mailing list >> and that mailing list sends a copy to the original person thats how a >> mailing list works. It also sends a copy to the forum which is parses you >> and that person

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Nov 20, 2010, at 8:22 , Elliot Chance wrote: > One very annoying thing about Apple Mail with these lists is that when I hit > reply if I don't change the To address to the mailing list or manually add > the Cc then it doesn't even get sent to the mailing list. Use Reply to All: Cmd-Shift-R.

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Sat, Nov 20, 2010 at 05:46, Elliot Chance wrote: > On 21/11/2010, at 12:32 AM, Magnus Hagander wrote: >> On Sat, Nov 20, 2010 at 14:22, Elliot Chance wrote: >> Use "Reply To All" when you want to send to the list. It's what >> everybody else has been doing for ages :-) If you want to read u

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

Magnus Hagander wrote: > On Sat, Nov 20, 2010 at 14:46, Elliot Chance wrote: > >>> for...@postgresql.com.au is pointed to a black hole so that email > >>> disappears but the mailing list gets another copy. When the mailing list > >>> gets its copy it sends a copy to the forum (because the forum

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Sat, Nov 20, 2010 at 14:46, Elliot Chance wrote: >>> for...@postgresql.com.au is pointed to a black hole so that email >>> disappears but the mailing list gets another copy. When the mailing list >>> gets its copy it sends a copy to the forum (because the forum is just like >>> a subscribed

  1   2   3   4   5   6   7   8   9   10   >