Re: [GENERAL] Monitoring Tool for PostgreSQL

We use a PERL script to handle this sort of thing. It’s nice this way since we can run them from just about anywhere. bobb On Oct 18, 2017, at 12:37 PM, Fabricio Pedroso Jorge > wrote: Hi all, is there a "official" monitoring tool for

Re: [GENERAL] Problems with the time in data type timestamp without time zone

Where is the machine running the database physically located, in another timezone possibly? bobb On Oct 18, 2017, at 10:33 AM, David G. Johnston > wrote: On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña

Re: [GENERAL] Issue with json_agg() and ordering

>> >> I guess that the order by should be in the aggregation. >> >> SELECT json_agg(a.* ORDER BY a.last_name, a.last_year DESC) >> FROM my_table a; > > yes. however, you would say, json_agg(a... not 'a.*'). The .* > notation only works in certain contexts, and is transformed at parse > time to,

[GENERAL] Issue with json_agg() and ordering

aggregate function LINE 1: ...foo='f' order by last_name ... I suspect It doesn't really matter what my table looks like for the purposes of the above, but if you need something to go by: create table my_table( last_name text, first name text, foo text, bar boolean ); Thanks ! Bob -- Sent

Re: [GENERAL] Postgres processes getting stuck (bug?)

pg_terminate_backend() didn’t work, as the signal queued behind the kernel wait. We had to bounce the database to get rid of the problem. Immediately afterwards we disabled the trigger. HTH, Bob Lunney > On Apr 29, 2016, at 1:30 PM, Ciprian Grigoras <ciprian.grigo...@vitals.com> > wrote:

Re: [GENERAL] Initdb --data-checksums by default

(a one way > operation). > > -- > Stuart Bishop <stu...@stuartbishop.net> > http://www.stuartbishop.net/ > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

XFS absolutely does. Its well supported on Redhat and CentOS 6.x and 7.x. Highly recommended. Don’t know about OCFS2. Bob Lunney Lead Data Architect MeetMe, Inc. > On Apr 8, 2016, at 8:56 AM, Marllius <marll...@gmail.com> wrote: > > Hi guys! > > The OCFS2 and X

Re: [GENERAL] Processing data from table using awk.

Just to throw in an idea. I almost exclusively use PERL for this type of thing. A bunch of examples out on the web using DBI, and the main aspects are portable across many databases, not just POSTGRES. Just my two cents. AWK would work too, I’ve used it myself, and got very complicated with

Re: [GENERAL] PG 9.4.4 issue on French Windows 32 bits

login -c show all | grep lc_ s'il vous plaît. Also check if any code is setting client_encoding or any of the lc_* options on the fly. Bob Lunney Senior Database Engineer AWeber Communications, LLC 1100 Manor Drive Chalfont, PA 18914 USA On Jul 8, 2015, at 12:48 PM, Daniel Verite dan

[GENERAL] How to retrieve Comment text using SQL, not psql?

for every article.' - Bob Futrelle

Re: [GENERAL] Re: Stuck trying to backup large database - best practice? How about a cloud service?

Many worthwhile things cost money. I never suggested you wouldn't have to pay. - Bob On Tue, Jan 13, 2015 at 12:27 AM, Michael Nolan htf...@gmail.com wrote: On Mon, Jan 12, 2015 at 7:46 PM, Bob Futrelle bob.futre...@gmail.com wrote: You should be able to find a cloud provider that could

[GENERAL] Re: Stuck trying to backup large database - best practice? How about a cloud service?

You should be able to find a cloud provider that could give you many TB. Or so they like to claim. - Bob

Re: [GENERAL] Very high latency, low bandwidth replication

this days are mostly behind us :-) On 30 June 2014 13:05, Francisco Olarte fola...@peoplecall.com wrote: Hi Bob. On Mon, Jun 30, 2014 at 10:05 AM, Bob Jolliffe bobjolli...@gmail.com wrote: What are people's thoughts about a more optimal solution? I would like to use a more incremental

Re: [GENERAL] Very high latency, low bandwidth replication

Thanks Stuart. I'll do some measurements on plaintext dump to git. On 2 July 2014 09:46, Stuart Bishop stu...@stuartbishop.net wrote: On 30 June 2014 15:05, Bob Jolliffe bobjolli...@gmail.com wrote: What are people's thoughts about a more optimal solution? I would like to use a more

[GENERAL] Very high latency, low bandwidth replication

a more incremental approach to replication. This does not have to be a live replication .. asynchronously triggering once every 24 hours is sufficient. Also there are only a subset of tables which are required (the rest consist of data which is generated). Appreciate any advice. Regards Bob

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

I have this table: CREATE TABLE REPORT_STYLE ( REPORT_STYLE_NAME VARCHAR(75) NOT NULL, REPORT_STYLE_VERSION NUMERIC(8,0) NOT NULL, UPDATE_TS TIMESTAMP NOT NULL, UPDATE_USER_NAME VARCHAR(30) NOT NULL, STYLE_DESCR VARCHAR(200), JASPER_STYLE XML ); ALTER TABLE REPORT_STYLE ADD

[GENERAL] Installed postgres.app 9.3.1.0. pgadmin doesn't appear to see it

was rolling along with 9.2 getting lots of good work done via Eclipse/JDBC. But now I'm stuck. Sorry for being so dense. But I've never been afraid to ask questions. The answers I get increase my understanding of whatever the topic is. Thanks in advance for helping a tyro. - Bob

[GENERAL] pg_hba.conf broken after cluster upgrade

than one line (in any order) leads to this error. Any idea what on earth can I have done and how can I fix it? Bob

Re: [GENERAL] I need more specific instructions for switching to digest mode for this list

Me bad. It was right there in front me. I'm now in Digest Mode. - Bob On Wed, Oct 9, 2013 at 12:00 PM, Igor Neyman iney...@perceptron.com wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Raymond

[GENERAL] I need more specific instructions for switching to digest mode for this list

Trying to switch to the digest didn't work. How do I find more specific details about switching? On Wed, Oct 9, 2013 at 12:27 AM, Bob Futrelle bob.futre...@gmail.comwrote: set pgsql-general digest

[GENERAL]

set pgsql-general digest

[GENERAL] How to restore some DBs to a new server?

not disturbing my current DBs. So I would like to reload both the dumps into New, but I can't find the magic invocation that does this, in pgAdmin3 or using pg_restore or directly in psql. I realize that this isn't rocket science, so I'll blush a bit when the simplicity of it is revealed. - Bob

[GENERAL] Cleaning up a text import

(both '% U' from '%%UTK-208%%U') . However I would need to know what it is that needs to be trimmed from future imports, which isn't always possible. I would appreciate any suggestions on how to resolve this. Many thanks in advance. Bob

[GENERAL] pgAdmin shows two servers with the identical data

started with it late last year and have never looked back. PG is definitely one cool DB system. Thanks guys. My data is 120,000 biology papers, HTML, and a great deal of secondary data I generate from them. - Bob Futrelle

[GENERAL] JDBC - Need to declare variables for values in insert statement

collect metadata from XML articles such as title, journalName, volume, year. For each article I need to create a pg table record and insert the values for the various metadata items in the article. This is my first post to this list. Thanks, - Bob

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

Here's a small, but complete code example - Bob package us.tsos.dbs.pg; import java.sql.*; /** * This is an effort to get a computed value from a Java function * (or data object) included properly in the VALUES entries. * So, how can I declare an SQL variable and set its value to some Java

Re: [GENERAL] database design best pratice help

Yes. The general rules are: Many normalized tables. OK. Denormalizing simply to reduce the number of tables. Not OK. - Bob On Mon, Jan 28, 2013 at 1:47 PM, Kevin Grittner kgri...@ymail.com wrote: Jose Soares jose.soa...@sferacarta.com wrote: In my db I have about one hundred tables

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

.) --- Bob On Mon, Jan 28, 2013 at 1:59 PM, Edson Richter edsonrich...@hotmail.comwrote: You have two options: st.execute(insert into hello values ('bKey', +f1()+)); or PreparedStatement st = db.prepareStatement(insert into hello values ('bKey', ?)); st.setInteger(1, f1()); where 1

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

worked, doing what I needed. My new understanding now allows me to do a ton of good NLP stuff. Back to the future. Thanks all, - Bob On Mon, Jan 28, 2013 at 2:22 PM, Edson Richter edsonrich...@hotmail.comwrote: I would recommend the reading of the excellent The Java Tutorial, that has

[GENERAL] Server to run Postgresql

Hi I have an unused computer which I am considering turning into a server to run my Postgresql database. Is this even possible to do? If so, can someone suggest an open source server that is relatively easy to set up? Windows based would be ideal. Bob

[GENERAL] Using Insert with case

attempting to use the above. However, with or without the enclosing brackets I get a syntax error on the word into. Help will be appreciated. Bob

Re: [GENERAL] Using Insert with case

Hi Alban Probably no difference except I have four cases and I was trying, in an attempt to save processing time, to compact commands a little. Bob -Original Message- From: Alban Hertroys Sent: Tuesday, August 07, 2012 3:40 PM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL

Re: [GENERAL] Trouble with NEW

OWNER TO postgres; -- Trigger: pidnum on project.project -- DROP TRIGGER pidnum ON project.project; Help would be appreciated. Bob -Original Message- From: Adrian Klaver Sent: Wednesday, July 18, 2012 5:47 PM To: Bob Pawley Cc: Alan Hodgson ; pgsql-general@postgresql.org Subject: Re

Re: [GENERAL] Trouble with NEW

In all my reading of new and old I never made that connection. Thanks Adrian Bob -Original Message- From: Adrian Klaver Sent: Thursday, July 19, 2012 6:50 AM To: Bob Pawley Cc: Alan Hodgson ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Trouble with NEW On 07/19/2012 06

[GENERAL] Trouble with NEW

p_id.fluids.fluid_id = NEW.fluid_id; I receive an error ”record “new” has no field “fluid_id” “. Bob

Re: [GENERAL] Trouble with NEW

It's an insert after trigger function. The table has a column named fluid_id. Bob -Original Message- From: Alan Hodgson Sent: Wednesday, July 18, 2012 11:15 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Trouble with NEW On Wednesday, July 18, 2012 11:07:34 AM Bob Pawley

Re: [GENERAL] Trouble with NEW

character varying(100), pump1 character varying(5), pump2 character varying(5), CONSTRAINT fluid_pk PRIMARY KEY (fluid_id) ); Bob -Original Message- From: Adrian Klaver Sent: Wednesday, July 18, 2012 1:07 PM To: Bob Pawley Cc: Alan Hodgson ; pgsql-general@postgresql.org Subject: Re

[GENERAL] DDL Triggers

Could someone point me to documentation regarding DDL triggers in Postgresql? Bob

Re: [GENERAL] DDL Triggers

. I am attempting to have the dropped table trigger a function as it is being populated by insert commands. DDL trigger was mentioned as a possibility on the GDAL list. Any suggestions will be welcome. Bob -Original Message- From: Adrian Klaver Sent: Wednesday, February 15, 2012 8

[GENERAL] Triggering a function on table overwrite

Hi Normally when I need to run a function during an insert I make it a trigger function of that table. However, in this case, I need to overwrite the table with which the trigger is attached. I would appreciate any suggestions on how to do this. Bob

[GENERAL] DB Dump

was created as part of the transaction. What am I missing? pg_dump -h localhost -p 5432 -U postgres -v -f PDW_cp_Nov_2011.backup PDW Bob

Re: [GENERAL] DB Dump

The file doesn't exist. Just in case, I modified the dump to pg_dump -h localhost -p 5432 -U postgres -v -f PDW2_cp_Nov_2011.backup PDW and got the same error. Bob -Original Message- From: Guillaume Lelarge Sent: Wednesday, November 09, 2011 9:48 AM To: Bob Pawley Cc: Postgresql

Re: [GENERAL] DB Dump

Following is a copy of the end of running the dump - pg_dump: saving standard_conforming_strings = off pg_dump: saving database definition pg_dump: [archiver] could not open output file PDW_cp_Nov_2011.backup: Permiss ion denied pg_dump: *** aborted because of error Bob -Original Message

Re: [GENERAL] DB Dump

I'm logged on to my computer as an administrator(and am the only user). What other permission do I need?? Bob -Original Message- From: Adrian Klaver Sent: Wednesday, November 09, 2011 10:00 AM To: Bob Pawley Cc: Guillaume Lelarge ; Postgresql Subject: Re: [GENERAL] DB Dump On 11/09

Re: [GENERAL] DB Dump

Opening Command Prompt as administrator solved my problem. Thanks everybody. Bob -Original Message- From: Raymond O'Donnell Sent: Wednesday, November 09, 2011 10:41 AM To: Bob Pawley Cc: Adrian Klaver ; Guillaume Lelarge ; Postgresql Subject: Re: [GENERAL] DB Dump On 09/11/2011

[GENERAL] Dump Error Message

, tgconstrrelid::pg_catalog.regclass AS tgconstrrelname FROM pg_catalog.pg_trigger t WHERE tgrelid = '19069'::pg_catalog.oid AND tgconstraint = 0” When I execute this command in the SQL pane of PGAdmin and remove “AND tgconstraint = 0” the selct shows a row which is unfamiliar to me. Bob

Re: [GENERAL] Are file system level differential/incremental backups possible?

Is it possible to do a full file system level backup of the data directory, say once a week, and differentials or incrementals daily? I'd love to be able to do this, but you can't do it usefully at a file-system level. There's too much churn in the data files for even a binary diff to be

Re: [GENERAL] pg 8.3 replication causing corruption

Any movement on this? There is considerable interest in any known issues resolving reproducible issues with postgres replication.   Do you happen to remember if set up the standby when the master was under high load conditions?  Any interesting/unexplained messages in the standby logs? I'm

Re: [GENERAL] pg 8.3 replication causing corruption

have you had any power events?  hard shutdowns, etc? I wonder if the problem is in the clog files, and not the heap itself. Nothing unusual for as long as I can tell. Reminder that as long as I don't restart the primary's pg process, everything works fine (secondary's data is intact). It's

Re: [GENERAL] Are file system level differential/incremental backups possible?

If you drop or truncate a table between the full and the incremental backup, will that file be resurrected? Such resurrected files will not disturb PostgreSQL, but if you keep them around, you might end up with a lot of dead files if you have to restore a couple of times. That makes

Re: [GENERAL] pg 8.3 replication causing corruption

Should replication cause corruption on the secondary when stopping/starting the primary? I wasn't aware 8.3 had any built in replication?  what sort of replication add-ons are you using? Continuous archiving / WAL shipping as described in:

[GENERAL] Are file system level differential/incremental backups possible?

Is it possible to do a full file system level backup of the data directory, say once a week, and differentials or incrementals daily? I'm wondering if there are files that would normally be removed that a restore: Full then diff/inc would not remove and perhaps corrupt/confuse things. Process:

Re: [GENERAL] pg 8.3 replication causing corruption

Should replication cause corruption on the secondary when stopping/starting the primary? I wasn't aware 8.3 had any built in replication?  what sort of replication add-ons are you using? Continuous archiving / WAL shipping as described in:

Re: [GENERAL] pg 8.3 replication causing corruption

Should replication cause corruption on the secondary when stopping/starting the primary?  (pg 8.3.12, windows 2008 R2 on both servers) No, it shouldn't. Any duplicate keys would represent a serious error. It sounds like you're using warm standby, but when you say run pg_start_backup() AFTER

Re: [GENERAL] Are file system level differential/incremental backups possible?

Anyway, a better way for you would be to do a regular backup (with pg_start_backup, copy and pg_stop_backup) and then use wal archive_command to keep the xlogs between 2 full backups. Thanks Julien. Can pg_start/stop_backup() be used for regular full file system backups? All of the

Re: [GENERAL] pg 8.3 replication causing corruption

Something about your setup is suspect. Disks perhaps. Disk: Fusion IOdrive (1.2TB NAND drive) I've read that one should set wal_sync_method=fsync_writethrough for Windows servers. It's currently set to open_datasync, I have no idea what effect that will have other than I've read less

Re: [GENERAL] Are file system level differential/incremental backups possible?

The base backup necessary to initialize a warm standby server is a full file system backup of the database, which can also be used for restores to any point in time after the base backup is completed, assuming you also have all the archived WAL files. Thanks to both of you. I currently

[GENERAL] pg 8.3 replication causing corruption

nightly backup. I'm doing something wrong Thanks for any help/pointers! *-Bob Hatfield*

[GENERAL] Replication/WAL shipping. db errors on slave after stop/start master

xyz_pkey SQL state: 23505 Detail: Table contains duplicated values. Where xyz is the table name (real name removed) and it's not always on the same table. Note that I accidentally discovered this have attempting a reindex on the triggered slave database. -Bob Logs: head of postgresql...log

[GENERAL] Searching through trigger functions

Hi I have an error somewhere in one of the trigger functions in my database. The error message only told me it was a ‘Select * From (table name). Is there a global method of finding where this expression resides other than searching each script individually. Bob

[GENERAL] Arrays

Hi Is there a method of counting the number of elements in an array?? Bob

[GENERAL] PSQLRestore

Hi I’m having problems making PostgreDAC’s PSQLRestore work without an access violation. Could someone please point me to an example code that I can check? (My PSQLDump is working well, so I am using a valid restore file.) Bob

Re: [GENERAL] PSQLRestore

-Original Message- From: Adrian Klaver Sent: Thursday, September 08, 2011 1:41 PM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] PSQLRestore On 09/08/2011 09:09 AM, Bob Pawley wrote: Hi I’m having problems making PostgreDAC’s PSQLRestore work without an access violation

Re: [GENERAL] PSQLRestore

-Original Message- From: Raymond O'Donnell Sent: Thursday, September 08, 2011 3:23 PM To: Bob Pawley Cc: Adrian Klaver ; Postgresql Subject: Re: [GENERAL] PSQLRestore On 08/09/2011 23:02, Bob Pawley wrote: The problem seems to be in this code which I am using to transfer from

Re: [GENERAL] Variable column name

-Original Message- From: Bill Moran Sent: Thursday, September 01, 2011 8:19 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] Variable column name http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html Section 39.5.4 If you're not familiar with plpgsql at all, you

Re: [GENERAL] Variable column name

-Original Message- From: Raymond O'Donnell Sent: Friday, September 02, 2011 10:38 AM To: Bob Pawley Cc: Bill Moran ; Postgresql Subject: Re: [GENERAL] Variable column name On 02/09/2011 18:33, Bob Pawley wrote: -Original Message- From: Bill Moran Sent: Thursday

Re: [GENERAL] Variable column name

-Original Message- From: Bill Moran Sent: Friday, September 02, 2011 10:53 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] Variable column name In response to Bob Pawley rjpaw...@shaw.ca: I am getting an error -- column 1 does not exist snip Select 1 into column

[GENERAL] Variable column name

creating 20 to 40 hard coded statements?? Bob

Re: [GENERAL] Variable column name

-Original Message- From: Bill Moran Sent: Thursday, September 01, 2011 7:59 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] Variable column name In response to Bob Pawley rjpaw...@shaw.ca: I want to add information to multiple columns (20 – 40) by employing a loop. Each

[GENERAL] Updating Arrays

of the array Update library.compare set _base[2] = '{2}' where process_id = 2; I get an error “invalid input syntax for type numeric: {2}” Bob Create table library.compare ( id serial UNIQUE, process_id int4, device_id int4, _base decimal[] ); Insert into library.compare (process_id) values ('2');

Re: [GENERAL] Updating Arrays

I'm not sure what you mean. _base -- not base -- is the column name. Bob -Original Message- From: Merlin Moncure Sent: Monday, August 22, 2011 11:03 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] Updating Arrays On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley rjpaw...@shaw.ca

Re: [GENERAL] Postgredac Dump

left the schema and tables empty as I understand that doing so will dump the whole database. Any help would be appreciated. Bob From: raghu ram Sent: Thursday, May 12, 2011 11:36 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] Postgredac Dump On Thu, May 12, 2011 at 10:02 PM, Bob

Re: [GENERAL] Postgredac Dump

The last log entry was two hours before I attempted to dump. Bob -Original Message- From: Raymond O'Donnell Sent: Friday, May 13, 2011 10:44 AM To: Bob Pawley Cc: raghu ram ; Postgresql Subject: Re: [GENERAL] Postgredac Dump On 13/05/2011 18:30, Bob Pawley wrote: Hi Raghu

Re: [GENERAL] Postgredac Dump

Hi Ray I finally got it to dump. I switched the argument so that the path is first and the file name is after the comma. I found this hint on a very useful site that shows a number of examples of PostgresDAC. http://www.keashsoft.com/postgrestutorial/4.html Bob -Original Message

[GENERAL] Postgredac Dump

Hi Can anyone point me to an example of how to use the Postgresdac Dump component?? Bob

[GENERAL] Urgent Order

Hello This is Bob and I will like to order ( Indexing Table )Do get back to me with the types and cost for the ones you do carry and let me know if there is an extra cost when using visa or master Card.Kindly get back to me with your name Are you the sales manager or the Owner? Regards Bob

Re: [GENERAL] Different views of remote server

is a point. Bob -Original Message- From: Adrian Klaver Sent: Thursday, April 21, 2011 7:22 PM To: pgsql-general@postgresql.org Cc: Bob Pawley ; Scott Marlowe Subject: Re: [GENERAL] Different views of remote server On Thursday, April 21, 2011 9:24:57 am Bob Pawley wrote: Hi Scott According

Re: [GENERAL] Different views of remote server

accessing as a local connection. This is the remote database which I dumped and then restored as a local. These fields are not only not visible but they return null when I do a simple select query. I could really do with some suggestions. Bob -Original Message- From: Adrian Klaver Sent

Re: [GENERAL] Different views of remote server

If it's empty space at the beginning it goes on for a long time. Can I send the table as an sql dump as an attachment with the list?? Bob -Original Message- From: Adrian Klaver Sent: Friday, April 22, 2011 1:29 PM To: Bob Pawley Cc: pgsql-general@postgresql.org ; Scott Marlowe

Re: [GENERAL] Different views of remote server

Hi Adrian I looked at the table in JEdit. The binary strings for the missing fields are considerably longer than the others. What limiting factor have I probably exceeded?? Bob -Original Message- From: Adrian Klaver Sent: Wednesday, April 20, 2011 4:14 PM To: pgsql-general

Re: [GENERAL] Different views of remote server

Hi Scott According to NSAuditor(www.nsauditor.com) there is only one server with port 5432. When I enter information into the remote database it shows up on the same database that has this problem. How do I determine my 'connection credentials'? Bob -Original Message- From

[GENERAL] Different views of remote server

number of servers are present (only one present on the remote computer). I’ve run out of ideas - Would anyone have any thoughts of what might be going on??? Bob PS – I have tried one other thing - dumping the database from the remote server and restoring it to the local server

Re: [GENERAL] how to avoid repeating expensive computation in select

enable only a single computation of the data for any given row as long as the same args are used as parameters. But, is this safe, or have any pitfalls I would need to look out for? Thanks! Bob --- On Thu, 2/3/11, Tom Lane t...@sss.pgh.pa.us wrote: From: Tom Lane t...@sss.pgh.pa.us Subject

[GENERAL] how to avoid repeating expensive computation in select

(value)) 0.5; Any ideas anyone! Thanks in advance! Bob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] how to avoid repeating expensive computation in select

(value)) 0.5; Any ideas anyone! Thanks in advance! Bob -- 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] how to avoid repeating expensive computation in select

a variable with this 'constantdata...'::X value, and then pass this variable in both calls. Would this work? Thanks again! Bob --- On Thu, 2/3/11, Bill Moran wmo...@potentialtech.com wrote: From: Bill Moran wmo...@potentialtech.com Subject: Re: [GENERAL] how to avoid repeating expensive

Re: [GENERAL] Remote Connection

Hi Bill Thanks for answering. The problem turned out to be the excessive permissions required in Windows 7 Firewall. It appears to be working now. Bob -Original Message- From: Bill Moran Sent: Monday, January 10, 2011 5:55 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL

[GENERAL] Remote Connection

opening. The postgresql log follows. Can someone please interpret it for me? Bob 2011-01-07 09:03:55 PSTERROR: unrecognized configuration parameter ssl_renegotiation_limit 2011-01-07 09:03:55 PSTSTATEMENT: SET ssl_renegotiation_limit=0 2011-01-07 09:04:08 PSTLOG: could not receive data from

Re: [GENERAL] Restore problem

-Original Message- From: Alban Hertroys Sent: Wednesday, December 29, 2010 4:03 AM To: Bob Pawley Cc: Adrian Klaver ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On 29 Dec 2010, at 4:40, Bob Pawley wrote: It seems that this has affected just the triggers

Re: [GENERAL] Restore problem

permissions in Win 7 during install and uninstall of PostgreSQL. Bob -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general

[GENERAL] Restore problem

. Is there some way of correcting this – or re restoring the database, so that I don’t have to go through the whole code line by line? Bob

Re: [GENERAL] Restore problem

-Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 4:21 PM To: pgsql-general@postgresql.org Cc: Bob Pawley Subject: Re: [GENERAL] Restore problem On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote: Hi I have restored a database using psql to windows version

Re: [GENERAL] Restore problem

Yes I was just looking at it. It seems that it was dumped in that form. Any thoughts on how that could happen?? Not that it will help in this instance. Bob -Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 6:09 PM To: Bob Pawley Cc: pgsql-general

Re: [GENERAL] Restore problem

-Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 6:09 PM To: Bob Pawley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote: -Original Message- From: Adrian Klaver Sent

Re: [GENERAL] Restore problem

-Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 6:51 PM To: Bob Pawley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote: Bob -- Adrian Klaver adrian.kla...@gmail.com

Re: [GENERAL] Restore problem

-Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 7:06 PM To: Bob Pawley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On 12/28/2010 07:05 PM, Bob Pawley wrote: -Original Message- From: Adrian Klaver Sent: Tuesday, December

Re: [GENERAL] Restore problem

-Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 7:06 PM To: Bob Pawley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On 12/28/2010 07:05 PM, Bob Pawley wrote: -Original Message- From: Adrian Klaver Sent: Tuesday, December

Re: [GENERAL] Restore problem

-Original Message- From: Adrian Klaver Sent: Tuesday, December 28, 2010 7:33 PM To: Bob Pawley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On 12/28/2010 07:27 PM, Bob Pawley wrote: -Original Message- From: Adrian Klaver Sent: Tuesday, December

Re: [GENERAL] Restore problem

-Original Message- From: Alan Hodgson Sent: Tuesday, December 28, 2010 8:12 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore problem On December 28, 2010, Adrian Klaver adrian.kla...@gmail.com wrote: On 12/28/2010 07:40 PM, Bob Pawley wrote: Open the file

[GENERAL] Restore

for the password of my computer - which doesn’t exist. How can I get around this?? Bob

  1   2   3   4   5   >