[GENERAL] Append text using Concat on an Update query

I'm trying to append new text on a field using the concat function. On the Set statement I use something like this: Set Field = Concat(Field,'ABC') And when I check the results 'ABC' wasn't appended to . What should I do to make it append? ---(end of broadcast)

Re: [GENERAL] Problem with pl/python procedure connecting to the internet

It might be a dumb thought, but... Did you run the script from ipython as postgres user? External programs called by triggers run as postgres, and maybe your postgres user doesn't have rights to reach the remote service. Regards, Sandor On 23 August 2015 at 09:09, Igor Sosa Mayor wrote: > "Ch

Re: [GENERAL] Problem with pl/python procedure connecting to the internet

On 23 August 2015 at 18:59, Igor Sosa Mayor wrote: > s d writes: > > > It might be a dumb thought, but... > > thanks. There are not dumb thoughts with such problems... > > > Did you run the script from ipython as postgres user? > > External programs called by tr

Re: [GENERAL] Replacement for Oracle Text

On 19 February 2016 at 14:19, Bruce Momjian wrote: > On Fri, Feb 19, 2016 at 11:53:26AM +, Simon Riggs wrote: > > On 19 February 2016 at 11:46, Thomas Kellerer > wrote: > > > > Daniel Westermann schrieb am 19.02.2016 um 12:41: > > if I'd need to implement/replace Oracle Text (ww

Re: [GENERAL] Update foreign table with trigger

On 26 February 2016 at 20:02, Leonardo M. Ramé wrote: > > El 26/02/16 a las 15:55, John R Pierce escribió: > >> On 2/26/2016 10:29 AM, Leonardo M. Ramé wrote: >> >>> Hi, I created a Postgres_FDW table (TABLE_A) and need to do an update on >>> that table. >>> >>> As TABLE_A has a trigger, and the

Re: [GENERAL] Update foreign table with trigger

On 26 February 2016 at 20:19, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:18, s d escribió: > >> >> On 26 February 2016 at 20:02, Leonardo M. Ramé > <mailto:l.r...@griensu.com>> wrote: >> >> >> El 26/02/16 a las 15:55, John

Re: [GENERAL] Update foreign table with trigger

On 26 February 2016 at 20:42, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:33, s d escribió: > >> On 26 February 2016 at 20:19, Leonardo M. Ramé > <mailto:l.r...@griensu.com>> wrote: >> >> >> >> El 26/02/16 a las 16:18, s d e

Re: [GENERAL] Update foreign table with trigger

On 26 February 2016 at 21:02, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:49, s d escribió: > >> On 26 February 2016 at 20:42, Leonardo M. Ramé > <mailto:l.r...@griensu.com>> wrote: >> >> >> >> >> Then try to do the upd

Re: [GENERAL] PLPythonu for production server

On 4 March 2016 at 10:46, Rémi Cura wrote: > Thanks for the answer guys. > > I should have mentionned that I had read the doc, > and was looking for non explicit knowledge, > like : > - what is the reputation of plpython for a dba? > Dunno. - are there actual production system that use it > I

Re: [GENERAL] archive_command not being executed

I'd come to the same conclusion Jeremy had about 9.5 being the first version with the 'always' option for archive_mode. Looking at pg_receivexlog, that might work, but with me being a total noob I'm wary of the various steps I'd have to take in going from: Master -> streaming replication to

Re: [GENERAL] archive_command not being executed

9:26 AM, Paul Jungwirth wrote: > Oh this has happened to me before. :-) On SB1 you need to set > archive_mode to always (not on). Otherwise it is ignored when running as a > standby. It looks to me like this feature was not added until 9.5 and Eric is running 9.3 :( > On 11/10/2017 09:10

Re: [GENERAL] Geographic data sources, queries and questions

On Thursday 24 May 2007 13:02, John D. Burger wrote: > > We also have a hodge-podge of other sources, but those are the main > ones. (By the way, we have found USGS to very amenable to dumping > their data in arbitrary ways. Those state files essentially try to > fit everything in

Re: [GENERAL] "not in" clause too slow?

Ottavio Campana <[EMAIL PROTECTED]> írta: > mytable.id is primary key. > > I create copy_mytable with > create table copy_mytable as (select * from mytable); > > the planer behavior does not change no matter if I create and index > on copy_mytable.id or not. Try this, with an index on copy_myt

Re: [GENERAL] Geographic data sources, queries and questions

On May 24, 2007 01:02:42 pm John D. Burger wrote: > Tilmann Singer wrote: > > We are using this data which seems to be fairly extensive and > > accurate, and is free: > > > > http://earth-info.nga.mil/gns/html/gis_countryfiles.htm > > We use that, but it is only n

Re: [GENERAL] SHMMAX and SHMALL question

Thank you so much for the script. ~deepak On Jan 22, 2011, at 10:18 AM, Greg Smith wrote: > DM wrote: >> RAM = 16GB, what value should i set for shmall? > > Given that PostgreSQL rarely sees increasing improvement as shared_buffers > goes over 50% of RAM, I just use that figure for the shmal

[GENERAL] archive_command not being executed

I have a standby db server (SB1) that will soon become the master. SB1 is set up with streaming replication from the current master. I'm trying to set up a third server (SB2) as a slave/standby to SB1, so that when SB1 becomes the master, there will be a standby for it. First step is to get W

[GENERAL] Postgres with daemontools or similar

Greetings everyone. I would like to know what the correct position is on the use of Postgres with DJB's daemontools or other monitoring prgrams? I tried to set it up the other day and was successful in getting it to start and log, and even refresh the config files, but I could not get it to sh

[GENERAL] Server not listening

If this isn't the right place to post this, please advise. I've spent a week trying to get PostgreSQL 8.3 to install correctly on WIN2K. Server will load & I see the server processes loaded but none of them have any open ports. I keep getting the message the server isn't listening. Server

[GENERAL] Lost psql.exe on 8.3.3 upgrade

Windows 2000 Prof. Used upgrade option, not full install. I upgraded my 8.3.1 to 8.3.3. Looks like all went ok except I had no psql.exe in my bin dir. I searched for it & found it in C:\WINNT\Installer\{B823632F-3B72-4514-8861-B961CE263224} dir. It is the 8.3.3 version. When I copied it to m

Re: [GENERAL] Overloading

Ralph Smith wrote: I never did get an answer to this. I get: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. ** Error ** ERROR: cannot change return type of existing function SQL state: 42P13 Hint: Use DROP FUNCTION first. When I try t

[GENERAL] Start automatically a function at startup of postgresql server

Dear Sirs, Is it possible to start a function (a my function) when the server postgres is started? and how I can do? Best regards. Domenico Formenton -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL] ERROR: could not read block 4707 of relation 1663/16384/16564: Success

My guess is some one moved the data folder or the directory got deleted (/var/lib/pgsql/9.0/data/.../...1663/16384/16564). Without server restart. I am sure some experts gonna answer this very well. Thanks Deepak On Jul 30, 2011, at 2:01 AM, Deniz Atak wrote: > Hi, > > I am using postgresql

Re: [GENERAL] ERROR: could not read block 4707 of relation 1663/16384/16564: Success

I am not sure how big your table is one way we implemented here was we selected the clean rows and outputted it to a csv file. And the rows affected we had to load from the backup, luckily we had the clean backup. Ex: assume you have 1,2,3,4,5100 rows and the corrupted is between 60-70. I o

[GENERAL] Updating 9.0.4 --> 9.1.1: How best to ???

Hi, I would like to know which if any is a recommended install and upgrade method. My situation is summarized as: I currently have Postgresql 9.0.4 installed via the Fedora Core FC15 yum repo, and 9.1.x is not there (yet). I decided to install the PGDG repo (pgdg-fedora91-9.1-5.noarch) to make

[GENERAL] Question about PARTIAL DATE type/s

Hi, I have text fields which contains dates in the format 'MM' (four positions for the year, two for the month). These fields are contained in text files which I load into the DB. When I convert this field to a date using to_date("PARTIAL_DATE_FIELD",'MM'); -- (a cast won't recog

Re: [GENERAL] Question about PARTIAL DATE type/s

I suspected that this would be the answer. Thank you lots for your kind help, Daniele & Tom [?] On 7 October 2012 16:46, Daniele Varrazzo wrote: > On Sun, Oct 7, 2012 at 3:03 PM, Tom Lane wrote: > > Daniele Varrazzo writes: > >> Note: it exploits to_date() parsing '200013' as '2001-01', which

[GENERAL] Function Profiler in Postgre

Hi, I have many functions which i want to finetune. Is there any profiler available which i can use to check performance of function and finetune it. Regards Ds

[GENERAL] fuzzystrmatch module buggy? observations

The fuzzystrmatch module ( http://www.postgresql.org/docs/9.2/static/fuzzystrmatch.html) is currently, as of 9.2.1, documented with the caution *"At present, the soundex, metaphone, dmetaphone, and dmetaphone_alt functions do not work well with multibyte encodings (such as UTF-8)"*. While the vene

[GENERAL] Using Postgresql 9.2 on windows 7 and windows vista

Hi, I am going to use PostgreSQL 9.2 with my application which runs on Windows 7/WIndows Visa 64 bit OS. Since these platforms are not officially supported by PostgreSQL, can i go ahead and use PostgreSQL on these platform? Regards D T

[GENERAL] Request for help setting up source tree

Hi, I want to make an extension but don't understand the source setup well. a) Do I need the full source of postgres locally? b) Where must the source be? The project dir is ~/nbprojects/my_pg_ext and I am using the code of the fuzzystrmatch contrib as my "template" from where to start c) My inst

Re: [GENERAL] Request for help setting up source tree

eans 7.3b2 that would be in Tools -> Options -> C/C++ -> Code Assistance -> C Compiler and suddenly everything works ... So then :-) On 20 November 2012 15:51, r d wrote: > Hi, > > I want to make an extension but don't understand the source setup well. > a) Do I n

Re: [GENERAL] what Linux to run

>> >> If we move to Linux, what is the preferred Linux for running Postgres >> on. This machine would be dedicated to the database only.=20 >> >> I'd like a recommendation for both a GUI hosted version and a non-GUI >> version. I haven't used Linux in the past but did spend several year s >> in a

[GENERAL] plpython large result set

Hello, I am hoping to use plpython to perform various transforms on query results of very large size. The documentation in the official 8.3 manual makes it appear as if the results of plpy.execute are read in at once (e.g., they appear to have random access and are mutable) rather than in the hid

Re: [GENERAL] Stalled post to pgsql-general

will post to proper group, sorry On Mon, Mar 2, 2009 at 8:10 AM, wrote: > Your message to pgsql-general has been delayed, and requires the approval > of the moderators, for the following reason(s): > > The author (K D ) > is not a member of any of the restrict_post groups. &g

[GENERAL] Simple query takes 5+ minutes

Hope this is the correct group. I am running 8.0.1 on XP P4 2.6 1GB for dev work and the following simple query takes 5+ minutes to complete. Would like to get this down to <2-3 seconds. Other RDBMS complete it in <1 second. select i.internalid, c.code from local.internal i inner join country.ip

[GENERAL] Survey...Please do help and Respond!!

reasons? · Are you switching any database in favor of an alternative? If so, which ones? · Are there any general trends you see in the database market? I sincerely thank you all for your time and efforts. Cheers! Regards, D-Licious ---(end of broadcast

[GENERAL] Solaris and Ident

I've used Postgres on Linux for several years, and I have relied on the 'ident' authentication method for system administration and other tasks. Now I need to get a postgres database up and running on Solaris. The problem is that 'ident' authentication is not supported on Solaris. I can't figure o

Re: [GENERAL] Solaris and Ident

I can't get the .pgpass file working. I think the problem may have to do with the fact that the user's home directory is '/'. Is there a way to specify a different location for .pgpass other than '~/.pgpass'? -- View this message in context: http://www.nabble.com/Solaris-and-Ident-tf3371429.h

[GENERAL] Geographic data sources, queries and questions

Greetings all, I have a couple issues regarding geographic names databases. 1) The first is this. I have 3 tables. Country, state and city. Country has a country_id to identify a country, state has a state_id and country_id to identify a state, and city has a city_id, state_id and country_id

Re: [GENERAL] Geographic data sources, queries and questions

which, if you are using a similar database what source did you use for geographic data? I'm having troubles with a reliable set. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Chuck D. > > Sent: Wednesday, May 23, 2

Re: [GENERAL] Geographic data sources, queries and questions

On Wednesday 23 May 2007 18:59, you wrote: > > I don't believe this is good design. You'll have to have a trigger or > something to verify that the country_id+state_id on the city table are > exactly equal to the country_id+state_id on the state table. If you > don't, you might have something li

Re: [GENERAL] SessionID, pretty please

thanks. Tom Lane wrote: > [EMAIL PROTECTED] writes: > > My troubles would be solved if I could reference a SessionID from > > within PG. Any hope? > > Create a sequence. At session start, nextval() it to assign a session > ID for your session. Then currval() returns your session ID whenever >

Re: [GENERAL] import/export or moving data between databases

Iavor Raytchev wrote: Dear Tom, We kind of read all documentation we could find, but that was the only way we could get - - export db structure into sql file - export the records we need into another sql file - import structure - turn off triggers - import the records - turn on triggers The main pr

Re: [GENERAL] Random not so random

of query and not at the moment of connect. A pseudo-random generator using the same seed will generate the same sequence. D. Stimits, stimits AT comcast DOT net ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Random not so random

Vivek Khera wrote: "DS" == D Stimits <[EMAIL PROTECTED]> writes: DS> If it uses the same seed from the connection, then all randoms within DS> a connect that has not reconnected will use the same seed. Which means DS> the same sequence will be generated each time, whic

Re: [GENERAL] C API, PQconnectdb and options Q.

D. Stimits wrote: I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly things work right, but I need more debug output, as I have a query that works fine from psql, but fails with the C API (perhaps this is because I use PQescapeString). The only way to know there is an err

Re: [GENERAL] PL/PGSQL for permutations?

Joe Conway wrote: D. Stimits wrote: > table field pair. E.G., if I had in table 'one': > left right > = > a b > a c > b d > > ...then I'd need a list of a, b, c, d, and produce a new table: > left right > = > a

[GENERAL] undefined reference to 'pg_detoast_datum'

nge to a newer version of PostgreSQL, then a newer version can't be used] D. Stimits ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] undefined reference to 'pg_detoast_datum'

Joe Conway wrote: D. Stimits wrote: > A google search shows very little concerning the pg_detoast_datum > undefined reference link error. It is looking more like the V1 has to > be skipped and I'll have to go back to V0 if I can't get this to work. You haven't shown us

Re: [GENERAL] [INTERFACES] more on undefined reference to 'pg_detoast_datum'

Tom Lane wrote: > "D. Stimits" writes: > > >... My question is, where the heck is > >CurrentMemoryContext and MemoryContextAlloc provided as an > >implementation which I can link with? > > > They're inside the backend, and you don't --- you a

[GENERAL] Was: Triggers, Stored Procedures, PHP

s false or am I totally missing the point of views? Shane D ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Was: Triggers, Stored Procedures, PHP

Doug McNaught wrote: It's false. You can treat a view just like a table and add clauses to your query that restrict it beyond what the view gives you. I think that's what you're asking about... Thanks for your reply. I found an example in the postgresql reference manual in the "CREATE VIEW

[GENERAL] ORDBMS vs OODBMS

Hello folks I'm an engineering student and I would be very interested to learn the pros and cons between these two DataBases: - Versant : commercial OODBMS (Object-Oriented) - PostgreSQL : open source ORDBMS (Object-Relational) (Other DB like Oracle are ERDBMS and not ORDBMS if I guess right)

[GENERAL] [Help] INSTALLing 7.02

Hi, If anyone out there would be so kind as to point out what may be the problem I would appreciate it immensely. (PS - I tried without the --with-CC and got the same error at the same place) ./configure --with-CC=/usr/opt/SUNWmd/sbin/cc loading cache ./config.cache checking host system

[GENERAL] Set valued attributes ?

Does anyone know how to make an attribute a collection of OIDs? I haven't found any reference of this object-oriented feature in Postgres online manuals. Please, let me know any hints/links or anything that could help me doing the following: === Assume that each row of tables is identified by OI

[GENERAL] no shared libs

Hi! I ve just upgraded from 6.2.1 to 6.3.2 and ended with no shared libs for libpq Making in the /interfaces/libpq(++) doesn't help - the libs are compiled only as libpq(++).a The configure script recognizes my system as linux-gcc which I think is standing now for linux-elf from the 6.2.1 rele

[GENERAL] European/American dates

Why does postgres (started *without* "-o -e") accept dates like "21-2-98" which is not (is it?) a valid American date? Thanx for the attention! Marin -= Why do we need gates in a world without fences? =-

Re: [GENERAL] GRANT/REVOKE problems

It doesnt make difference for postgres user. The result is the same for any user... Marin -= Why do we need gates in a world without fences? =- On Mon, 25 May 1998, Jose' Soares Da Silva wrote: > > Do you want revoke all previleges from postgres? > Remember that user postg

Re: [GENERAL] A couple of LIBPQ questions

On Sat, 6 Jun 1998, Marin D wrote: > > > > > (2) I noticed there are some C++ classes in /usr/include/libpq++ which > > look similar to code I'm writing for my own education and use. Is there > > any documentation which deals with these classes?

Re: [GENERAL] SQL Where Statement

On Sat, 6 Jun 1998, Michael wrote: > > I am trying to do a select with a WHERE clause excluding all fields that > don't start with 'A'..'Z' > > Something in the form of > WHERE lastname >NOT LIKE ('A'..'Z') AND >NOT LIKE ('a'..'z') SELECT * FROM somewhere WHERE lastname !~ '[A

Re: [GENERAL] A couple of LIBPQ questions

On Fri, 5 Jun 1998, Bruce Tong wrote: > (1) PQftype() returns a value of type "Oid", but I haven't been able to > find a list of what those values might be. I noticed in the header files a > value of zero is considered invalid, but that's it. The docs I've found > don't tell me anything other t

Re: [GENERAL] Foreign Keys

PGSRC_DIR/contrib/spi/refint* is the answer Marin -= Why do we need gates in a world without fences? =- On Mon, 8 Jun 1998, ENTER YOU NAME HERE wrote: > Hi all > I am using PostgreSQL as part of my MSc project. Because it is an > object-relational database it is a superset

Re: [GENERAL] Q: How to convert int to date?

On Tue, 23 Jun 1998, Mattias Kregert wrote: ->How do I convert INTEGER to DATE in 6.3.2? -> ->I have a table 'mytbl' with a column 'd' which is ->an integer, containing dates in YYMMDD form. Now, This is quite bad representation of date. U know Y2K, so

Re: [GENERAL] Replication fell out of sync

On 03/02/2015 03:25 PM, David Kerr wrote: Howdy, I had an instance where a replica fell out of sync with the master. Now it's in in a state where it's unable to catch up because the master has already removed the WAL segment. (logs) Mar 2 23:10:13 db13 postgres[11099]: [3-1] user=,db=,host

Re: [GENERAL] VACUUM FULL doesn't reduce table size

On 03/09/2015 08:57 AM, Adrian Klaver wrote: On 03/09/2015 08:49 AM, Kevin Grittner wrote: pinker wrote: INFO: vacuuming "my_table" INFO: "my_table": found 0 removable, 3043947 nonremovable row versions in 37580 pages DETAIL: 0 dead row versions cannot be removed yet. So there are no l

Re: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6

On 04/15/2015 12:14 PM, Andy Colson wrote: Postgresql is on version 9. What do you mean version 2 or 3? He probably means 9.2.7 to 9.3.6. Remember to a lot of people 9 means 9. That said, pg_upgrade is the way to do this as long as you can have an outage. JD -- Command Prompt, Inc. - h

Re: [GENERAL] Streaming-SQL Database PipelineDB (Based on PostgreSQL 9.4) - Available in Beta

On 04/22/2015 01:09 PM, Jeff Ferguson wrote: Hello (PostgreSQL) World, We recently shipped our streaming-SQL analytics database, PipelineDB , which is based on PostgreSQL 9.4, in beta and are looking for companies to participate as early access partners. You can rea

Re: [GENERAL] New column modifier?

On 04/29/2015 10:03 AM, John McKown wrote: I am wondering about useful something might be. So I hope ya'll don't mind me throwing out for feedback. I am fairly good with standard SQL, but not the more advanced DBA things such as TRIGGERs. I am reading good book, "PostgreSQL Server Programming" t

Re: [GENERAL] PostgreSQL HA config recommendations

On 04/29/2015 10:53 AM, Alex Gregory wrote: Hello- I have been doing lots of reading and I really want to make sure that I get this HA architecture I am working on correct. I figured the best way would be to reach out to the community for advice. I am installing Cisco Jabber and want to use

Re: [GENERAL] documenting tables version control

On 05/05/2015 01:13 PM, Suresh Raja wrote: Hi All: I have tables with different versions in the same schema. Like T1a, T1b, T1c T2a, T2b, T2c, T2d ... etc. I'm interested in documenting various version of tables, may be in excel sheet or may be in another schema in the database. I

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] Does PG support bulk operation in embedded C

On 05/19/2015 04:47 PM, Ravi Krishna wrote: To explain pls refer to this for DB2 http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html Essentially in one single sql call, we can do -- Add new rows -- Update a set of rows where each row is i

Re: [SQL] [GENERAL] Does PG support bulk operation in embedded C

On 05/19/2015 05:27 PM, Ravi Krishna wrote: Not sure whether I am understanding this. I checked embedded C and did not find any section which describes what I have asked, that is the ability to do multiple inserts, or updates or deletes in one sql call. For example, if my application does the fo

Re: [GENERAL] date with month and year

On 05/21/2015 10:01 AM, Daniel Torres wrote: I everybody, I'm new in the Postgresql world, and have an easy question: Is it possible to have date type data that only contain month and year?, how can I obtain that from a timestamp (without time zone) column? I've made this, but I think the result

Re: [GENERAL] WAL Streaming Failure PostgreSQL 9.4

On 05/28/2015 09:56 AM, Ivann Ruiz wrote: I'm trying to setup streaming replication but I'm stuck, please help! autovacuum launcher started| And then nothing else happens, please I really need help with this, I appreciate all comments. Any questions, please feel free to ask. I would like

Re: [HACKERS] Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1

On 05/28/2015 12:56 PM, Robert Haas wrote: FTR: Robert, you have been a Samurai on this issue. Our many thanks. Sincerely, jD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended"

Re: [GENERAL] postgres db permissions

On 06/02/2015 10:36 AM, Steve Pribyl wrote: Good Afternoon, Built a fresh 9.3. postgres server and added some users and noticed that any user can create tables in any database including the postgres database by default. Have I missed some step in securing the default install? How exactly

Re: [GENERAL] postgres db permissions

On 06/02/2015 11:08 AM, Steve Pribyl wrote: They all look like this. CREATE ROLE dbA NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; And how are you connecting to the database via psql? JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Center

Re: [GENERAL] postgres db permissions

On 06/02/2015 11:46 AM, Tom Lane wrote: Adrian Klaver writes: On 06/02/2015 11:04 AM, Steve Pribyl wrote: I have noted that "GRANT ALL ON SCHEMA public TO public" is granted on postgres.schemas.public. I am looking at this in pgadmin so excuse my nomenclature. Is this what is allowing wr

Re: [HACKERS] [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1

On 06/05/2015 01:56 PM, Tom Lane wrote: If we have confidence that we can ship something on Monday that is materially more trustworthy than the current releases, then let's aim to do that; but let's ship only patches we are confident in. We can do another set of releases later that incorporate

Re: [GENERAL] WAL archive "resend policy"

On 06/29/2015 12:49 PM, Edson Richter wrote: Dear all, Another question about WAR archiving: what is the "resend policy" if remote storage runs out of space? The failed archives will be resend automatically in future, or there is need for manual interation? They will be resent. Thanks,

Re: [GENERAL] PgPool Configuration Document required

On 06/30/2015 09:05 AM, Jimit Amin wrote: Dear Sir/Mam, Can I have technical documentation for configuration of PgPool? http://www.pgpool.net/mediawiki/index.php/Main_Page -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consultin

Re: [GENERAL] PgPool Configuration Document required

On 06/30/2015 09:35 AM, Jimit Amin wrote: Dear Sir, Sorry for this type of question, I have already configured PgPool but facing 3 issue. That's why I thought that I may have done wrong setup. I would suggest the pgpool mailing lists. JD -- Command Prompt, Inc. - http://www.commandprompt.c

Re: [GENERAL] Ubuntu 14.04 LTS install problem

On 07/01/2015 02:59 PM, Scott Marlowe wrote: postgresql. When I try via terminal apt-get install postgresql-9.3 there are the same messages about postgresql-common (>= 142~) ... defect packages ... This isn't really a postgresql problem this is a problem with an ubuntu machine with a broken

Re: [GENERAL] Download PostgreSQL 9.5 Alpha

On 07/03/2015 04:32 PM, Edson F. Lidorio wrote: Hello, PostgreSQL 9.5 Alpha not appear on the downloads list in [1] Where do I download for Windows? [1] http://www.enterprisedb.com/products-services-training/pgdownload#windows For those in the community who may not know, EnterpriseDB hosts

Re: [GENERAL] could not fork new process for connection: Resource temporarily unavailable

On 07/04/2015 12:19 PM, Jimit Amin wrote: ello, I have heavy transaction load production database 9.3 PPAS .Today Database is not able to give new process. I checked pg_stat_activity , there are so many transaction in waiting stage because of one procedure and lock on one table (Code inside pro

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On 07/08/2015 12:47 PM, John McKown wrote: ​Why are they converting? Would EnterpriseDB (a commercial version of PostgreSQL which has extensions to make it a "drop in" replacement for Oracle) be a possibility? http://www.enterprisedb.com/solutions/oracle-compatibility-technology Because EDB

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 08:34 AM, William Dunn wrote: Hello Aviel, On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila mailto:avie...@gmail.com>> wrote: How can I set a highly available postgresql in a share-nothing architecture? I suggest you review the official documentation on high-availability c

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 11:04 AM, William Dunn wrote: If you dig deeper into pgpool-II you will find that it does not have failover logic. Its intention is to pool connections and distribute query load among replicas, but it cannot differentiate node failure from network partition and cannot promote a sta

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 01:21 PM, William Dunn wrote: That's pretty cool! But the intended use of watchdog is so you can have multiple pgpool-II instances and failover among them (http://www.pgpool.net/docs/latest/pgpool-en.html#watchdog) rather than failure of Postgres. In the configuration described in

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 01:37 PM, William Dunn wrote: But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes a

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 02:48 PM, William Dunn wrote: Maybe Linux-HA which you recommended is the more promising option for open source tool. http://www.linux-ha.org/wiki/Main_Page The Postgres resource agent appears to monitor the instance by executing 'SELECT now();' which is typically the recommended

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 07:07 PM, Tatsuo Ishii wrote: But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes

Re: [GENERAL] Delete rule does not prevent truncate

On 07/22/2015 06:13 AM, Tim Smith wrote: Melvin, May I point out that the manual states : "TRUNCATE quickly removes all rows from a set of tables. It has the same effect as an unqualified DELETE on each table" This is actually wrong. The end result is the same but it does not in any way have

Re: [GENERAL] Delete rule does not prevent truncate

On 07/22/2015 06:24 AM, Tim Smith wrote: Adrian, It still doesn't make much sense, especially as given the rather obscure and questionable design decision of allowing triggers to refer to truncate ops, but not allowing rules to refer to truncate ops !!! Actually it makes perfect sense becaus

Re: [GENERAL] Delete rule does not prevent truncate

On 07/22/2015 08:42 AM, Geoff Winkless wrote: On 22 July 2015 at 16:32, Joshua D. Drake mailto:j...@commandprompt.com>>wrote: This is actually wrong. The end result is the same but it does not in any way have the same effect. ​ "in any way"? ​ ​I'd say in the p

Re: [GENERAL] Delete rule does not prevent truncate

On 07/24/2015 02:32 AM, Andres Freund wrote: On 2015-07-24 10:29:21 +0100, Tim Smith wrote: That's not the point. Backups are important, but so is the concept of various layers of anti-fat-finger protection. Restoring off backups should be last resort, not first. Oh, comeon. Install a TRU

Re: [GENERAL] Postgresql upgrade from 8.4 to latest

On 07/28/2015 01:12 PM, AI Rumman wrote: Hi, I need to upgrade Postgresql database from 8.4 to latest stable version (9.4). The db size is almost 2.5 TB. Is pg_upgrade in-place is a good idea for it? With quite a bit of testing, yes. But keep in mind, it is still an outage. JD Thanks fo

Re: [GENERAL] Postgresql upgrade from 8.4 to latest

On 07/28/2015 01:35 PM, AI Rumman wrote: But what I read, in-place upgrade has smaller outage, compared to dump/restore. Correct, in fact if you do it with the link option, it will be very fast. But so many articles on having bugs afterwards. Do you think it is a good idea to use pg_upgrade

Re: [GENERAL] Synchronous replication and read consistency

On 07/29/2015 02:27 PM, Ravi Krishna wrote: "Not necessarily. There has been discussion of adding a new mode which will delay the commit on the primary until it is visible on a synchronous standby, but I don't recall where that left off. " Joshua: THis essentially contradicts your statement

  1   2   3   4   5   6   7   8   9   10   >