Re: [GENERAL] pitr archive_command cp fsync

2015-03-16 Thread Peter Eisentraut
On 3/14/15 3:27 PM, Миша Тюрин wrote: > should we add disclaimer in pitr documentation about cp and fsync? > > cp does not fsync. > > and dd for example can do fsync. only on some platforms -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-24 Thread Peter Eisentraut
On 4/20/15 6:09 PM, Bruce Momjian wrote: > On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote: >> ISTM there's a documentation bug here: in the code, the "dump" method >> checks for tablespaces and raises an error if they are found, but the >> "upgrade" method does not check. I think t

Re: [GENERAL] RPM building tools and info missing?

2015-05-11 Thread Peter Eisentraut
On 5/9/15 10:47 AM, Bill Moran wrote: > https://wiki.postgresql.org/wiki/RPM_Packaging > > The link to the specfiles and other data at > http://svn.pgrpms.org/repo/ gives a 404. It's been move to git. I have updated the wiki page with the new URL. -- Sent via pgsql-general mailing list (pgsq

Re: [GENERAL] Replicate over pgbouncer?

2015-05-21 Thread Peter Eisentraut
On 5/21/15 12:12 PM, Andomar wrote: > Hi, > > Today I installed pgbouncer. I added a second installation as a hot > standby. Before starting the standby, I configured "recovery.conf" to > connect to pgbouncer. > > This results in an error message: > > Pooler Error: Unsupported startup para

Re: [GENERAL] pl/python composite type array as input parameter

2015-05-28 Thread Peter Eisentraut
On 5/18/15 10:52 AM, Filipe Pina wrote: > But one of the functions I need to create needs to accept an array of > records. PL/Python doesn't support that. Some more code needs to be written to support that. You did everything correctly. I don't know of a good workaround. -- Sent via pgsql-g

Re: [GENERAL] Change UUID type default output representation

2015-05-28 Thread Peter Eisentraut
On 5/28/15 5:35 PM, Randall Lucas wrote: > Can I compile my own version of uuid_out and update the system > catalogs, or create a "uuid_dashless" type that uses my own custom > uuid_dashless.c that's hacked to remove dashes? Either one would work. -- Sent via pgsql-general mailing list (pgsql-

Re: [GENERAL] [ADMIN] How Many PG_Locks are considered too many

2015-07-30 Thread Peter Eisentraut
On 7/30/15 6:13 AM, Renato Oliveira wrote: > We have a Nagios plugin, which monitors pg_locks and almost daily we see > 3000 to 4 pg_locks. > > Can we just ignore them, can we let them grow without worrying? > > How many pg_locks are considered unsafe for any given postgres server? That depe

Re: [GENERAL] pgpass (in)flexibility

2015-09-22 Thread Peter Eisentraut
On 9/15/15 1:48 AM, Ben Chobot wrote: > We're in a situation where we would like to take advantage of the pgpass > hostname field to determine which password gets used. For example: > > psql -h prod-server -d foo # should use the prod password > psql -h beta-server -d foo # should use the beta pa

Re: [GENERAL] Recovering data from an old disk image

2016-07-15 Thread Peter Eisentraut
anywhere anymore, you can check out the tag REL9_4_BETA1 from git and built it yourself. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] What's the benefit (or usage scenario) of a "typed table"?

2017-01-03 Thread Peter Eisentraut
_type; > > I wonder what the benefit of a typed table is and when this would be useful? One use is with PL/Proxy. You create the type on the proxy, thus allowing you to define functions using the type. Then create the table on the backend from the type, thus ensuring they are

Re: [GENERAL] Ubuntu/Debian PGDP

2016-05-07 Thread Peter Eisentraut
own and being worked on. It's only a deprecation warning, so you can ignore it for now. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Day of week vs. Language

2007-07-11 Thread Peter Eisentraut
What is the behaviour in PGSQL? Does the dow result > also depend on the language settings, or will the value 0 ALWAYS be a > Sunday? It's always that way for this particular function. -- Peter Eisentraut http://developer.postgresql.org/~petere/ -

Re: [GENERAL] it works, but is it legal to separate schema/table/field references using spaces

2007-07-18 Thread Peter Eisentraut
Frank van Vugt wrote: > db=# select avg(pg_catalog    .   pg_stats     . avg_width) from > pg_stats; > It seems that all whitespace between schema/table/field references is > ignored? Sure, this is perfectly valid per SQL and what not. -- Peter Eisentraut http://developer.po

Re: [GENERAL] [pgsql-advocacy] European users mailing list

2007-07-29 Thread Peter Eisentraut
but as a place to discuss events, advocacy and other > topics relevant to our work in Europe. If it's not a general list, why did you name it "general"? That will certainly cause confusion. It sounds like -eu-advocacy might have been better. -- Peter Eisentraut htt

Re: [GENERAL] locale and performance?

2007-07-29 Thread Peter Eisentraut
gt; disappointing that postgresql is only in one configuration to suply > the max. performance. That is nonsense. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, ple

Re: [GENERAL] Problem With gunzip backup

2007-08-01 Thread Peter Eisentraut
gt; please suggest what is going wrongThanks In advanceWith RegardsAshish... Check if you have the GZIP environment variable set. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: Have you checked

Re: [GENERAL] Possible to Attach/Detach Tablespaces?

2007-08-01 Thread Peter Eisentraut
Am Mittwoch, 1. August 2007 10:07 schrieb Ow Mun Heng: > New to PG, just wondering if there's anyway to say.. I want t Full > backup of DB-Sample and I can just tar up the directory containing that > tablespace, copy it to another PG server and then re-attach it? No. -- Peter E

Re: [GENERAL] Suse RPM's

2007-08-04 Thread Peter Eisentraut
ackage, replace the tarball with a new 8.2 release and send that to the OpenSUSE build service. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Latin1 to UTF-8 ?

2007-08-04 Thread Peter Eisentraut
Aarni Ruuhimäki wrote: > So, what would be the proper way to convert the dumps to UTF-8 ? Or > any other solution ? Any other tool to work with the problem files ? Dump them again but set your client encoding to UTF8. -- Peter Eisentraut http://developer.postgresql.org/~

Re: [GENERAL] Restrict access

2007-08-04 Thread Peter Eisentraut
Michael Knudsen wrote: > I can't find a file with that name. I am not using postgreSQL on my > own computer, so the file may be hidden somewhere in a directory > which I haven't got access to. Is there another way to get rid of > 'trust'? No. -- Peter Eisentraut

Re: [GENERAL] pg_restore UTF8 problem

2007-08-04 Thread Peter Eisentraut
message: > "In Reply To:get a life > > and terminates. What I would like to happen is for pg_restore to > ignore this error and continue on. Is there a way to make it do > that? No, you have to find out which encoding that actually is and then set your client encoding

Re: [GENERAL] UTF-8 encoding problem

2007-08-16 Thread Peter Eisentraut
Am Donnerstag, 16. August 2007 08:40 schrieb bhyuan: > Can I ignore the error message by confiing the config file? No, there are not provisions for that. Some errors of this type used to be ignored, but that led to SQL injection-like security issues, so you don't want that. -

Re: [GENERAL] array for cstring type

2007-08-16 Thread Peter Eisentraut
Am Donnerstag, 16. August 2007 11:22 schrieb Sergey Moroz: > there is no array for cstring type. I created it manually in pg_type table. > It seems to me that it's working fine. Can this cause any problems? The cstring type is not for general use. Use varchar or text. -- Peter Eise

Re: [GENERAL] UTF-8 encoding problem

2007-08-16 Thread Peter Eisentraut
to the current behavior, so it won't be changed back without sufficient cause. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subsc

Re: [GENERAL] Local authentication/security

2007-08-23 Thread Peter Eisentraut
r some variant of this involving those parameters. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] lc_collate issue

2007-08-25 Thread Peter Eisentraut
Cody Pisto wrote: > I'm just looking for the correct workaround. The canonically correct workaround it to define your own locale. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions b

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Peter Eisentraut
rget directory in > postgresql.conf, but then clients like psql still try to find the PID > file in /var/run/ postgresql and fail. You must be mistaken about this. psql shouldn't have a reason to read the server's PID file. -- Peter Eisentraut http://developer.postgre

Re: [GENERAL] DB upgrade

2007-10-09 Thread Peter Eisentraut
r 'gizmos' than pg_dump which I need to > copy from new machine to old machine to perform the dump? The advice remains: Install the newest client package and use that pg_dump. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadca

Re: [GENERAL] What encoding to use for English, French, Spanish

2007-10-14 Thread Peter Eisentraut
e by default, and so there is probably no reason to use a more restricted character set. Note that some versions of PostgreSQL have various degrees of trouble with UTF-8 support. Be sure to use the latest version. -- Peter Eisentraut http://developer.postgresql.org/~petere/ --

Re: [GENERAL] Inconsistence in transaction isolation docs

2007-10-16 Thread Peter Eisentraut
ou don't see changes while your own query runs. > > 2) Notice that two successive SELECT commands can see different data, > even though they > are within a single transaction, if other transactions commit changes > during execution > of the first SELECT -- Peter Eisentr

Re: [GENERAL] Collation sequence and use of operatings system's locale

2007-10-30 Thread Peter Eisentraut
sh dictionary sort, so something on your system is probably broken. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] The .pgpass file

2007-11-07 Thread Peter Eisentraut
Am Mittwoch, 7. November 2007 schrieb Tommy Flewwelling: > How do I inform the complier to extract the password from the file and not > the prompt the user? It does that automatically. Just omit the -W option. -- Peter Eisentraut http://developer.postgresql.org/~

Re: [GENERAL] stripping HTML, SQL injections ...

2007-11-15 Thread Peter Eisentraut
madhtr wrote: > Quick question, are there any native functions in PostGreSQL 8.1.4 that > will strip HTML tags, escape chars, etc? Using an SQL function to circumvent SQL injections probably isn't the wisest of ideas. -- Peter Eisentraut http://developer.postgresql.

Re: [GENERAL] XML schema

2007-11-15 Thread Peter Eisentraut
of an XML document. How do you imagine that affecting PostgreSQL database system operations? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] XML schema

2007-11-16 Thread Peter Eisentraut
ny time soon. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Call for translations

2007-11-16 Thread Peter Eisentraut
is available for general discussion and coordination of translation activities. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] convert access sql to postgresql

2007-11-16 Thread Peter Eisentraut
determination of the values of other fields (I told you I > couldn't figure out how to explain it). I can't tell more without the exact table definitions, but this should work just fine. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [GENERAL] Postgre and XML

2007-11-19 Thread Peter Eisentraut
Am Montag, 19. November 2007 schrieb x asasaxax: >I´m interested in running xml with postgre. I use postgre version 8.2 > and windows xp. I would like to know how can i enable the xml in the > postgresql. That depends on what you want to do with it. XML is quite a broad topic.

Re: [GENERAL] best way to handle enum type

2007-11-21 Thread Peter Eisentraut
Tom Hart wrote: > Hey everybody. I have a field that, in my earlier mySQL days would have > been an enum('q','y','m','c'), and I'm wondering what's the best way to > handle this in pgsql. If it's an option, upgrade

Re: [GENERAL] 8.3beta4 needs a dump/restore?

2007-12-04 Thread Peter Eisentraut
Am Dienstag, 4. Dezember 2007 schrieb Louis-David Mitterrand: > While upgrading from 8.3-beta3 to beta4, postgres complained that the > database format was not supported. I had to restore from backup. > > Was that intended? Yes -- Peter Eisentraut http://developer.postgresql

Re: [GENERAL] "Suspending" indexes and constraint updates

2007-12-04 Thread Peter Eisentraut
int creation at the end after the data load. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] initdb - encoding question

2007-12-05 Thread Peter Eisentraut
s character string processing functions. > How can I solve this? Rerun initdb and either do not specify an encoding explicitly, or choose a matching combination. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)-

Re: [GENERAL] initdb - encoding question

2007-12-05 Thread Peter Eisentraut
Am Montag, 3. Dezember 2007 schrieb Josh Harrison: > initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data > gives this error > initdb: "en_CA.utf-8" is not a valid server encoding name The option name you want is --locale, not -E. -- Pe

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

2008-01-07 Thread Peter Eisentraut
Devrim GÜNDÜZ wrote: > I want to announce PostgreSQL RPM Buildfarm today. Where is it? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? h

Re: [GENERAL] need to dump/restore data for 8.3beta2 -> 8.3RC1 upgrade?

2008-01-08 Thread Peter Eisentraut
Am Dienstag, 8. Januar 2008 schrieb rihad: > Hi, all! Subj, as is. Any other pitfalls I should be aware of? Please check the release notes for this information. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadc

Re: [GENERAL] Sun acquires MySQL

2008-01-16 Thread Peter Eisentraut
k we shouldn't spend our energy making it so. Nevertheless, I suggest you follow Josh Berkus's blog, which is as close as you will get to someone important from Postgres having access to someone important at Sun. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-18 Thread Peter Eisentraut
07; root:xnu-792.25.20~1/RELEASE_I386 i386 i386 I think we should address the problem were it happens. Adding this output will increase the amount of information available for causing confusion, while it would probably still require expert knowledge to read an endianness issue out of that. -

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-30 Thread Peter Eisentraut
ps, articles, and the like, but I'm not sure how accessible that is. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-30 Thread Peter Eisentraut
I understand it is proprietary. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-30 Thread Peter Eisentraut
Am Mittwoch, 30. Januar 2008 schrieb Ivan Sergio Borgonovo: > How/where is it possible to submit doc patches? [EMAIL PROTECTED] -- The process is mostly the same as for normal code. The Developer section of the web site gives you more information. -- Peter Eisentraut h

Re: [GENERAL] XML-support

2008-01-30 Thread Peter Eisentraut
Sigurd Nes wrote: > I noticed the upcoming support for xml in 8.3: > Does anybody know if this allows updates, inserts,removes and renames of > nodes to a XML-document (as for Xindice)? No, it doesn't support that directly. I guess you could achieve it by using XSLT. -- Peter E

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-07 Thread Peter Eisentraut
On ons, 2010-10-06 at 18:18 -0700, Mike Christensen wrote: > ERROR: could not load library > "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: > cannot open shared object file: No such file or directory > SQL state: 58P01 apt-get install libossp-uuid16 -- Sent via pgsql-general

Re: [GENERAL] queriing the version of libpq

2010-10-07 Thread Peter Eisentraut
On tis, 2010-10-05 at 09:33 +0200, Massa, Harald Armin wrote: > Now I would love to have an additional check "is the used psycopg2 > linked to an advanced-enough libpq", to be able to set bytea_output to > 'escape' if the libpq is not worthy. This is really something that psycopg2 should work out

Re: [GENERAL] Getting ROW_COUNT from MOVE in 8.3

2010-10-24 Thread Peter Eisentraut
On sön, 2010-10-24 at 15:41 +0200, Reuven M. Lerner wrote: > But is there any way for me to get, in 8.3, the > number of rows over which a cursor has skipped? Keep in mind that > after > this count has executed, we're then going to rewind the cursor, > chunking > through the result set with a s

Re: [GENERAL] ipv4 data type does not allow to use % as subnet mask delimiter

2010-11-14 Thread Peter Eisentraut
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote: > Windows uses % as subnet mask delimiter. This is not a subnet mask but a zone index, but it should probably still be supported. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://

Re: [GENERAL] ipv4 data type does not allow to use % as subnet mask delimiter

2010-11-14 Thread Peter Eisentraut
On sön, 2010-11-14 at 16:46 -0500, Tom Lane wrote: > Peter Eisentraut writes: > > On tor, 2010-11-11 at 20:33 +0200, Andrus wrote: > >> Windows uses % as subnet mask delimiter. > > > This is not a subnet mask but a zone index, but it should probably still > >

Re: [GENERAL] ipv4 data type does not allow to use % assubnet mask delimiter

2010-11-16 Thread Peter Eisentraut
On mån, 2010-11-15 at 11:06 +0200, Andrus wrote: > > Possibly someday the standard will actually standardize the things, > > and then maybe we can work with them usefully ... > > >From http://tools.ietf.org/html/rfc4007#section-11.2 > > implementation SHOULD >support the following format: >

Re: [GENERAL] lock file permisson

2010-11-30 Thread Peter Eisentraut
On mån, 2010-11-29 at 21:57 +0530, Mohammed Rashad wrote: > when i start postgresql using > /etc/init.d/postgresql-8.4 start > I am getting this error > IST FATAL: could not create lock file > "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied You probably need to run this command as roo

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Peter Eisentraut
On ons, 2010-12-01 at 10:26 +0200, Andrus wrote: > How to get list of available locale names from Postgres ? > Why Postgres does not have command which returns available locale > names ? > How to use same locale names in every platform? There is no portable operating system interface to get the n

Re: [GENERAL] How to find correct locale name for CREATEDATABASE

2010-12-02 Thread Peter Eisentraut
On tor, 2010-12-02 at 19:53 +0200, Andrus wrote: > I'm trying to create portable application which can automatically > create > database using estonian locale in any server. > Postgres returns different values for same locale: > > In Fedoraet_EE.UTF8 > Other linuxeset_EE.UTF-8 > In Window

Re: [GENERAL] Type cast removal - proposed exceptions for xml,enum

2010-12-07 Thread Peter Eisentraut
On tis, 2010-12-07 at 11:49 +0800, Craig Ringer wrote: > This is driving me nuts when working with PgJDBC via various ORM > layers (I know, I know, but they're life at this point) that would > work happily with these types if they were implicitly castable to/from > strings, but don't understand how

Re: [GENERAL] Using regexp_replace to remove small words

2010-12-10 Thread Peter Eisentraut
On fre, 2010-12-10 at 10:47 -0200, Henrique de Lima Trindade wrote: > I'm trying to find a regular expression that removes all small (length < N) > words from a string. But, until now I've not been successful. Here is a start: select regexp_replace('Tommy Lee Jones', $$\y\w{2,3}\y$$, ' ', 'g' );

Re: [GENERAL] help understanding collation order

2011-01-17 Thread Peter Eisentraut
On tis, 2011-01-18 at 10:33 +1100, raf wrote: > p.s. if anyone in debian locale land is listening, > 'E' does not sort before ','. what were you thinking? :-) What is actually happening is that the punctuation is sorted in a second pass after the letters. Which is both correct according to the re

Re: [GENERAL] XML Encoding problem

2011-02-09 Thread Peter Eisentraut
On mån, 2011-02-07 at 12:44 +0100, rsmogura wrote: > I have test database with UTF-8 encoding. I putted there XML > ЁĄ¡, (U+0401, U+0104, U+00A1). I changed client encoding to > iso8859-2, as the result of select I got > ERROR: character 0xd081 of encoding "UTF8" has no equivalent in > "LAT

Re: [GENERAL] Linux, Hungarian charset (Win1250) is supports the hungarian collation?

2011-03-23 Thread Peter Eisentraut
On mån, 2011-03-21 at 11:22 +0100, Durumdara wrote: > The language is Windows 1250 (ISO-8859-2). > > I remembered that when I tried in 8.1 to create database as same in Windows: > > CharSet: Win1250 > Collation: - (disabled, and it is handled as HUN - iso-8859-2) > > then I failed. > > Because

Re: [GENERAL] Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files

2014-06-04 Thread Peter Eisentraut
On 5/29/14, 11:59 AM, Bob Moyers wrote: > When I try this update: > > UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE > (REPORT_STYLE_NAME = ?) > > > > I get: > > org.postgresql.util.PSQLException: ERROR: invalid XML content > > Detail: line 2: StartTag: invalid element nam

Re: [GENERAL] Why isn't Java support part of Postgresql core?

2014-09-17 Thread Peter Eisentraut
On 9/15/14 1:30 PM, cowwoc wrote: > Any chance you guys could help cleaning up the build/deploy process? > > This is a pretty big hurdle to overcome for new users. I'm glad to hear that PL/Java is still working well for some people. Last I saw it was stuck in a transition of the build system fro

Re: [GENERAL] Why isn't Java support part of Postgresql core?

2014-09-17 Thread Peter Eisentraut
On 9/15/14 1:46 PM, Pavel Stehule wrote: > I am strong sceptic. There is relative slow progress in JDBC driver, > that is 100x more important project than PL/Java - so It is hard to > believe, so there can be 3 developers, who start work on PL/Java. Stupid, completely offensive guess: Most Java p

Re: [GENERAL] PL/Python prepare example's use of setdefault

2014-11-01 Thread Peter Eisentraut
On 10/15/14 5:56 PM, Tom Lane wrote: > Hm ... this was changed in commit 6f6b46c9c0ca3d96. Peter, did > you consider efficiency here? Fixed. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-ge

Re: [GENERAL] PL/Python prepare example's use of setdefault

2014-11-01 Thread Peter Eisentraut
On 10/15/14 5:58 PM, Jonathan Rogers wrote: > BTW, I would rewrite the 9.1 example to be shorter while > behaving the same: > > > CREATE FUNCTION usesavedplan() RETURNS trigger AS $$ > plan = SD.get("plan") > if plan is None: If we're going for shortness, how about if not plan: ?

Re: [GENERAL] pg_upgrade and ubuntu

2014-11-14 Thread Peter Eisentraut
On 11/14/14 2:10 PM, Jonathan Vanasco wrote: > I ran into an issue migrating from 9.1 to 9.3 on ubuntu using pg_upgrade > > the default ubuntu package, and the one from postgresql.org, both store > `postgresql.conf` in etc as `/etc/postgresql/VERSION/main/postgresql.conf` > > however, the pg_upg

[GENERAL] anyone using oid2name?

2014-12-12 Thread Peter Eisentraut
pgsql-hackers are discussing some housekeeping in contrib. Is anyone using the oid2name tool? Otherwise, we might deprecate and eventually remove it. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/p

Re: [GENERAL] anyone using oid2name?

2014-12-12 Thread Peter Eisentraut
On 12/12/14 9:25 AM, Bruce Momjian wrote: > On Fri, Dec 12, 2014 at 09:18:53AM -0500, Peter Eisentraut wrote: >> pgsql-hackers are discussing some housekeeping in contrib. >> >> Is anyone using the oid2name tool? >> >> Otherwise, we might deprecate and eventually

Re: [GENERAL] SELECT, GROUP BY, and aggregates

2015-02-13 Thread Peter Eisentraut
On 2/13/15 1:48 PM, Jeff Janes wrote: > I waste an inordinate amount of time retyping select lists over into the > group by list, or copying and pasting and then deleting the aggregate > clauses. It is an entirely pointless exercise. I can't fault > PostgreSQL for following the standard, but its

Re: [GENERAL] Fast Shutdown (SIGINT) results in a CHECKPOINT...

2013-03-20 Thread Peter Eisentraut
On 3/20/13 4:28 PM, Sean Chittenden wrote: > For a while now I've known that sending a SIGINT can trigger a CHECKPOINT, > but I don't know if this is intentional or a bug. It's intentional. If you don't want that, use SIGQUIT. That's how they are different. Of course, when using SIGQUIT, you w

Re: [GENERAL] pg_upgrade -u

2013-05-29 Thread Peter Eisentraut
On 5/21/13 2:41 PM, Bruce Momjian wrote: > I have thought about this and there are potentially several options > specified to pg_upgrade that could be passed into scripts: > > -O, --new-options=OPTIONS new cluster options to pass to the server > -P, --new-port=NEWPORTnew cluster po

Re: [GENERAL] pgxs question - linking c-functions to external libraries

2013-06-19 Thread Peter Eisentraut
On 6/6/13 11:49 PM, Rad Cirskis wrote: > Hi John, > have you managed to get it to link with external shared libs? Sure, many extensions to that. Do something like SHLIB_LINK += -lfoo in your Makefile. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] Pl/Python runtime overhead

2013-08-09 Thread Peter Eisentraut
On 8/7/13 10:43 AM, Seref Arikan wrote: > When a pl/python based function is invoked, does it keep a python > runtime running across calls to same function? That is, if I use > connection pooling, can I save on the python runtime initialization and > loading costs? The Python interpreter is initi

[GENERAL] Call for translations

2013-08-24 Thread Peter Eisentraut
In anticipation of the release of PostgreSQL 9.3, it is once again time to update the message translations. We are now in a string freeze, which has traditionally been associated with the first release candidate, so it's a good time to do this work now. If you want to help, see

Re: [GENERAL] AEXPR_OR, AEXPR_AND is not in postgres 9.6, how can I rewrite where it used in 9.3 ?

2017-04-04 Thread Peter Eisentraut
db85c738364fe8f7965209e08c6be about how the internal representation was changed. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Logical replication

2017-05-01 Thread Peter Eisentraut
to use both at the same time?: > > 9.4 ---> 10(instance 1)---> 10(instance 2) > pglogicalpglogical > builtinbuiltin That is possible. pglogical will continue to exist, so you can also keep using it if you already have it.

Re: [GENERAL] PQerrorMessage documentation

2017-05-04 Thread Peter Eisentraut
presume that in this case the string > will end with just \0, correct? It's not going to be \0\0 like with MSVC. I don't know what you mean by \0\0 with MSVC, but it is correct that the error message string will end with \0, like any C string. -- Peter Eisentraut http://

Re: [GENERAL] character encoding of the postgres database

2017-05-10 Thread Peter Eisentraut
On 5/10/17 11:48, Sandeep Gupta wrote: > Currently, the postgres database by has SQL_ASCII encoding. > Is it possible to start the postgres database with UTF-8 encoding, instead > of modifying it later. This is done when initdb is run, with the --locale and/or --encoding option.

Re: [GENERAL] relation create time

2017-05-10 Thread Peter Eisentraut
ation stored anywhere in the catalog? It is not. > Or I > need to store it myself? Is there any plan to add such meta data > information to the catalog as a feature? Thanks a lot! You could write an event trigger to record it. -- Peter Eisentraut http://www.2ndQua

Re: [GENERAL] Streaming replication bandwith per table

2017-06-19 Thread Peter Eisentraut
ical replication. That would save you the bandwidth for updating all the indexes at least. It might work for you. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql

Re: Fwd: [GENERAL] Streaming replication bandwith per table

2017-06-21 Thread Peter Eisentraut
On 6/21/17 22:04, Maeldron T. wrote: > * Logical replication is in 10.0 Beta 1. I might be oldschool but I > would install 10.1 or maybe 10.0.2 into production There are also other logical replication options such as pglogical and londiste. -- Peter Eisentraut http

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

2017-06-22 Thread Peter Eisentraut
ctionality can be expected to trickle into core eventually. One advantage of the in-core feature is that the initial table synchronization can be parallelized, which can make the initial setup faster and more robust. pglogical will probably support that too at some point once PG10 is out. -- Pe

Re: [HACKERS] [GENERAL] Not able to create collation on Windows

2017-08-01 Thread Peter Eisentraut
tead, don't know for sure. > > I think this is actually a bug, because the collations code clearly > means to allow clones of the C/POSIX locales --- see eg lc_collate_is_c, You seem to say that we should support a "POSIX" locale even on systems where the C library does

Re: [GENERAL] Compiling libpq only on Linux

2017-08-08 Thread Peter Eisentraut
ed distribution packages, even if they are not directly from your vendor. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

2017-08-11 Thread Peter Eisentraut
39922 17769 0 15:39 ?00:00:00 > /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h > bd-sillage.info. It appears that the second one is a process forked off from the first one. That looks normal to me. -- Peter Eisentraut http://www.2ndQuadrant.

Re: [GENERAL] Adding a new Clause in the Source Code

2017-08-14 Thread Peter Eisentraut
track all those places down and then see whether I need to make analogous changes there. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] Invalid magic number 0000 in log file

2017-08-25 Thread Peter Eisentraut
> > If it's  applicable, is it still valid or too many things have changed? That doesn't seem related. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mail

Re: [GENERAL] Get user defined type OID (PostgreSQL extension in C)

2017-08-25 Thread Peter Eisentraut
e OIDs of all the types involved don't change, and you can use the standard functions to look up the types of your arguments and the associated array types. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --

Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication

2017-10-26 Thread Peter Eisentraut
through exactly how to present this in the user interface. Another longer-term solution here is to implement conflict resolution mechanisms. So if you don't like local updates to break the incoming replication stream, a remote-update-wins policy would help. -- Peter Eisentrau

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-11-01 Thread Peter Eisentraut
suggest. > > > new version looks good. committed I changed to links to xrefs, which automatically generated the correct target texts. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via

Re: [GENERAL] Postgres 10 manual breaks links with anchors

2017-11-03 Thread Peter Eisentraut
https://www.postgresql.org/docs/9.5/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY A fix for this has been committed. Once 10.1 comes out (next week), the old-style anchors will work again. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Su

Re: [GENERAL] Naming conventions for column names

2017-11-06 Thread Peter Eisentraut
naming pattern used in the system catalogs: 3 letters indicating the catalog, plus additional letters or words. It is useful to use the same name in views such as pg_stat_replication, so you can easily join different views and catalogs. -- Peter Eisentraut http://www.2ndQuadrant.com/ Post

Re: [GENERAL] PostgreSQL on a CompactFlash

2008-01-31 Thread Peter Eisentraut
. You will find that PostgreSQL very write-happy and you might have some work to do. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] 8.3.-build fails due parse error in VERSION script

2008-02-05 Thread Peter Eisentraut
leases. You can edit the makefile and remove the export list, but there is no simpler or better-defined way available. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PostgreSQL 8.3.0 RPMs are available for download

2008-02-06 Thread Peter Eisentraut
e plan is to get quasi-official RPMs for SUSE onto the openSUSE build service. The only thing holding this back at the moment is the lack of time for the people involved. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

  1   2   3   4   5   6   7   8   9   10   >