Re: [GENERAL] Build RPM from Postgres Source

2013-07-13 Thread James B. Byrne
uch the same on any RHEL derived distro regardless of the package. Good luck. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilto

Re: [GENERAL] Need help extripating plpgsql

2013-02-22 Thread James B. Byrne
E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via p

Re: [GENERAL] Need help extripating plpgsql

2013-02-21 Thread James B. Byrne
On Thu, February 21, 2013 16:02, Adrian Klaver wrote: > On 02/21/2013 12:14 PM, James B. Byrne wrote: >> >> The current arrangement is not really satisfactory as it requires >> either separate template databases for each userid granted the >> DBCREATE role or the super

Re: [GENERAL] Need help extripating plpgsql

2013-02-21 Thread James B. Byrne
On Thu, February 21, 2013 13:23, Merlin Moncure wrote: > On Thu, Feb 21, 2013 at 11:48 AM, James B. Byrne > wrote: >> >> On Thu, February 21, 2013 12:38, James B. Byrne wrote: >>> I am trying, without success, to create a PG-9.2 database without >>> including

Re: [GENERAL] Need help extripating plpgsql

2013-02-21 Thread James B. Byrne
On Thu, February 21, 2013 12:38, James B. Byrne wrote: > I am trying, without success, to create a PG-9.2 database without > including the plpgsql extension. I have tried specifying template0 > and the database is nonetheless created with plpgsql. I have deleted > plpgsql from templ

[GENERAL] Need help extripating plpgsql

2013-02-21 Thread James B. Byrne
created databases would have all of their components owned by the database owner. How do I resolve this problem? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Broc

Re: [GENERAL] Howto see template objects in PGAdmin3

2013-02-14 Thread James B. Byrne
On Thu, February 14, 2013 06:23, Guillaume Lelarge wrote: > On Tue, 2013-02-12 at 15:32 -0500, James B. Byrne wrote: >> PG-9.2 >> PGAdmin3-1.16.0 >> >> I am attempting to do this from inside PGAdmin3 but I find that I no >> longer see either template0 or tem

[GENERAL] Howto see template objects in PGAdmin3

2013-02-12 Thread James B. Byrne
template0 to the test software. I am attempting to do this from inside PGAdmin3 but I find that I no longer see either template0 or template1 in the object tree. Where are they found? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca

Re: [GENERAL] [SOLVED] Problems with a custom LOCALE

2012-12-17 Thread James B. Byrne
On Sun, December 16, 2012 15:13, Tom Lane wrote: > "James B. Byrne" writes: >>>> PG::Error: ERROR: encoding "UTF8" does not match locale >>>> "en...@-mmm-dd.utf-8" >>>> DETAIL: The chosen LC_CTYPE setting requires enco

Re: [GENERAL] Problems with a custom LOCALE

2012-12-16 Thread James B. Byrne
On Fri, December 14, 2012 17:40, Tom Lane wrote: > "James B. Byrne" writes: >> PG::Error: ERROR: encoding "UTF8" does not match locale >> "en...@-mmm-dd.utf-8" >> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1&quo

[GENERAL] Problems with a custom LOCALE

2012-12-14 Thread James B. Byrne
ge # strings lc_monetary = 'en_US.UTF-8' # locale for monetary formatting lc_numeric = 'en_US.UTF-8' # locale for number formatting lc_time = 'en_US.UTF-8' # locale for time formatting So, w

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 10:21, James B. Byrne wrote: > > This is a patch for /etc/init.d/postgresql-9.2 to retrieve the port > from the postgresql.conf file and override the default setting if it > A slight, but important, correction that handles leading white space in the fir

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 10:21, James B. Byrne wrote: > > On Fri, December 14, 2012 09:52, Adrian Klaver wrote: > >> >> Assuming an RPM install, see Devrims reply. > > Might one inquire as to why it is necessary to override the > configuration file in the startu

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 09:52, Adrian Klaver wrote: > > Assuming an RPM install, see Devrims reply. Might one inquire as to why it is necessary to override the configuration file in the startup script? -- *** E-Mail is NOT a SECURE channel *** James B.

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 09:40, Adrian Klaver wrote: > On 12/14/2012 06:26 AM, James B. Byrne wrote: >> I wish to run an instance of PG-9.2 concurrently with our production >> version (9.1). I have changed the listening port number. >> >> listen_addresses = 'p

[GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
1299) using socket file "/tmp/.s.PGSQL.5432"? 2012-12-14 09:13:41 EST: LOCATION: CreateLockFile, miscinit.c:822 -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-l

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-28 Thread James B. Byrne
uired by the pg_dump file because of the ownership of the extension which triggered this entire discussion. I have removed plpgsql from template1 on all the systems affected. The tests now run against 9.1 fine. Regards, -- *** E-Mail is NOT a SECURE channel *** Ja

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-28 Thread James B. Byrne
tension in that database continues to show the plpgsql owner as postgres. psql on the other hand shows the new language owner as expected. By the way. Thank you very much for your assistance with this. It is greatly appreciated. Regards, -- *** E-Mail is NOT a SECURE channel

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-28 Thread James B. Byrne
means that only the superuser can restore databases in 9.1 or build them from scripts; unless the default template is altered. Is this desired? What then does GRANT CREATE DATABASE mean in 9.1 then? It is certainly at odds with the behaviour in 8.x releases. -- *** E-Mail is NOT a SECURE

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-28 Thread James B. Byrne
On Tue, February 28, 2012 12:52, Adrian Klaver wrote: > On 02/28/2012 09:50 AM, James B. Byrne wrote: >> >> >> Sigh. I will have to think on this before changing >> anything. >> >> To my mind, the most straight-forward way of dealing >> with >

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-28 Thread James B. Byrne
ALTER EXTENSION plpgsql OWNER TO devl; ERROR: syntax error at or near "OWNER" LINE 1: ALTER EXTENSION plpgsql OWNER TO devl; -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://w

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-28 Thread James B. Byrne
DATABASE. > Sigh. I will have to think on this before changing anything. To my mind, the most straight-forward way of dealing with this is to remove the language from template1 altogether. Thereafter, the db owner must explicitly add it back in where required. So, the default would be no exte

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
| postgres | UTF8 | | | | (5 rows) Collation, C-Type and Access Privileges columns removed. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte &a

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
On Mon, February 27, 2012 16:37, Adrian Klaver wrote: > On Monday, February 27, 2012 1:23:22 pm James B. Byrne > wrote: >> Obviously, I am missing something important here. The >> database in question is created thusly: >> >> CREATE DATABASE test >> WITH OWN

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
; ALTER EXTENSION plpgsql OWNER TO postgres; So, why is the plpgsql extension in test owned by postgres and not by devl to begin with? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
t;OWNER" SQL state: 42601 Character: 25 So, as I am unfamiliar with the EXTENSION syntax, what is wrong with the preceding statement? What is the correct syntax? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
On Mon, February 27, 2012 15:44, Tom Lane wrote: > "James B. Byrne" writes: >> 1. Can the comments be suppressed? > > No. > >> 2. Why is this an error in the first place? > > Because you're not running the script as superuser. > >

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
On Mon, February 27, 2012 14:30, Adrian Klaver wrote: > On 02/27/2012 08:51 AM, James B. Byrne wrote: > >> >> The options seem to be run the script as the owner of >> the >> plpgsql EXTENSION or do not include the comment. >> >> How does one instruct pg_

Re: [GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
On Mon, February 27, 2012 13:54, Adrian Klaver wrote: > On 02/27/2012 08:51 AM, James B. Byrne wrote: >> >> The options seem to be run the script as the owner of >> the >> plpgsql EXTENSION or do not include the comment. >> >> How does one instruct pg_dum

[GENERAL] Having a problem with RoR-3.1.1 and Pg-9.1

2012-02-27 Thread James B. Byrne
On: Fri, 24 Feb 2012 07:33:01 -0800, Adrian Klaver wrote: > On Friday, February 24, 2012 7:16:47 am James B. Byrne > wrote: >> CentOS-5.7 >> RoR-3.1.1 >> Pg-9.1 >> >> I am trying to run a test suite against Pg-9.1 for a >> RoR-3.1.1 based application

[GENERAL] Having a problem with RoR-3.1.1 and Pg-0.1

2012-02-24 Thread James B. Byrne
T a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general maili

Re: [GENERAL] Mixed Pg-9.1.2 and 8.4.4 environment

2012-01-11 Thread James B. Byrne
On Tue, January 10, 2012 09:28, Adrian Klaver wrote: > On Tuesday, January 10, 2012 6:17:27 am James B. Byrne > wrote: >> >> My question: Is their a way to specify a pg_dump option >> to retain compatibility with a lower version pg >> database? >> Alternati

[GENERAL] PGAdmin3 for CentOS-5_186_64 and pgdg91

2012-01-11 Thread James B. Byrne
-1.14.0-3.rhel5.i86_64 or why it is not available from pgdgrpm.org? Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561

[GENERAL] Mixed Pg-9.1.2 and 8.4.4 environment

2012-01-10 Thread James B. Byrne
[archiver (db)] COPY failed: ERROR: invalid input syntax for type bytea CONTEXT: COPY wiki_content_versions, line 1, column data: "\x68312e205b5b57696b6953746172747c48617274652026204c796e65204c696d697465642053746172745d5d0d0a0d0a0d..." WARNING: errors ignored on restore: 4 -- ***

[GENERAL] PGAdmin3 for 9.1 and CentOS-5_x86_64

2012-01-04 Thread James B. Byrne
his inbox. Does anyone here know if there is reason why CentOS-5 has the i386 package built for pgadmin3 v1.14.1 but not the x86_64? Or does it exist and I am simply not finding it? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte

[GENERAL] PostgreSQL server architecture

2011-12-20 Thread James B. Byrne
likely to be using five years from now I am soliciting informed option over which option is considered a better choice for the long term. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited

Re: [GENERAL] OT DBA type question - GRANT PRIVILEGE

2011-12-09 Thread James B. Byrne
On Fri, December 9, 2011 12:13, James B. Byrne wrote: Just to clarify the question. What I am asking basically comes down to if separate user ids are added for most individuals that access the database or not. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] OT DBA type question - GRANT PRIVILEGE

2011-12-09 Thread James B. Byrne
hannel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list

[GENERAL] OT DBA type question - GRANT PRIVILEDGE

2011-12-08 Thread James B. Byrne
that is fine with me. Thanks, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1

[GENERAL] Re: [pgsql-general] Need Help With a A Simple Query That's Not So Simple

2011-11-01 Thread James B. Byrne
gt; - Bill Thoen I believe that what you are trying to do is called relational algebra division. Take a look at these references and see if either fits your needs: http://en.wikipedia.org/wiki/Relational_algebra#Division_.28.C3.B7.29 http://www.cs.arizona.edu/~mccann/research/divpresentation.pdf

Re: [GENERAL] Error Importing CSV File

2011-07-15 Thread James B. Byrne
The Well-Grounder Rubist" by David A. Black before you go much further into your project. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive

[GENERAL] Infinity dates in RoR was How to handle bogus nulls from ActiveRecord

2011-05-17 Thread James B. Byrne
On Fri, May 13, 2011 13:04, James B. Byrne wrote: > > I have opened an issue for this with the ActiveRecord folks. > > https://github.com/rails/rails/issues/544 > This has been addressed by the AR team and is committed to master. +-Infinity support for dates is slated for gener

Re: [GENERAL] How to handle bogus nulls from ActiveRecord

2011-05-13 Thread James B. Byrne
ttps://github.com/rails/rails/issues/544 -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario

Re: [GENERAL] How to handle bogus nulls from ActiveRecord

2011-05-13 Thread James B. Byrne
dapter gem. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada

Re: [GENERAL] How to handle bogus nulls from ActiveRecord

2011-05-12 Thread James B. Byrne
the system. However, leaving untouched expected_by values that are less than the infinite value is doable and is a better approach. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.har

Re: [GENERAL] How to handle bogus nulls from ActiveRecord

2011-05-12 Thread James B. Byrne
Or we choose for the default value a fixed date far, far into the future. +Infinity was chosen as a default to avoid the complexities of dealing with NULL logic in SELECTS. I suppose that the simplest solution is to go with a date of -12-31 and treat that value like infinity. -- ***

[GENERAL] How to handle bogus nulls from ActiveRecord

2011-05-12 Thread James B. Byrne
are of but should provide for. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +

[GENERAL] Passing infinity as a timestamp value in Ruby

2011-03-30 Thread James B. Byrne
s known to anyone here then I would like to learn of it. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Ham

Re: [GENERAL] NULL value vs. DEFAULT value.

2011-03-08 Thread James B. Byrne
On Tue, March 8, 2011 10:09, Scott Ribe wrote: > On Mar 8, 2011, at 7:54 AM, James B. Byrne wrote: > >> My question is: Why am I getting a NULL exception? > > Because you're trying to insert NULL explicitly? Yes, that is the problem. Evidently RoR's ActiveRecord

[GENERAL] NULL value vs. DEFAULT value.

2011-03-08 Thread James B. Byrne
0 NOT NULL, weight_mass_net_uom character varying(3) DEFAULT ' '::character varying NOT NULL, . . . ); My question is: Why am I getting a NULL exception? Should I only specify DEFAULT and drop the NOT NULL constraint? -- *** E-Mail is NOT a SECURE channel

Re: [GENERAL] Screencasts for PostgreSQL

2011-03-04 Thread James B. Byrne
g a browse through these. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada

[GENERAL] How to approach dynamic status reporting

2011-03-02 Thread James B. Byrne
re if this sort of thing crops up elsewhere and, if so, how is it handled? Sincerely, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive

[GENERAL] Screencasts for PostgreSQL

2011-03-01 Thread James B. Byrne
channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (p

Re: [GENERAL] Getting a sample data set.

2011-01-18 Thread James B. Byrne
s, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3

Re: [GENERAL] Getting a sample data set.

2011-01-18 Thread James B. Byrne
t; s2.somecolumn > ) > I can see the motivation for something like DISTINCT ON. I take it that this syntax is peculiar to PostgreSQL?: -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited

[GENERAL] Getting a sample data set.

2011-01-18 Thread James B. Byrne
terials I have to hand. I cannot believe that I am the first person to require this sort of thing of SQL so if anyone can point me to a reference that explicitly sets out how to accomplish this I would greatly appreciate it. -- *** E-Mail is NOT a SECURE channel *** James B. Byrn

[GENERAL] Ad hoc report writer

2011-01-17 Thread James B. Byrne
PostgreSQL? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada

Re: [GENERAL] Set new owner on cloned database

2010-12-08 Thread James B. Byrne
ses, even it it did seem a bit convoluted. The REASSIGN OWNED BY seems the more sensible approach. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive

[GENERAL] Set new owner on cloned database

2010-12-08 Thread James B. Byrne
whatever, remains owned by the original owner. Is there no way to change the owner everywhere in the cloned database using cretedb? Or am I constrained to do a dump all and restore? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte

Re: [GENERAL] PG84 and SSL on CentOS-5.5 was PG84 and SELinux

2010-12-07 Thread James B. Byrne
w running with ssl enabled. Many thanks for the hints and suggestions. They did in fact eventually point me in the right direction. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.

Re: [GENERAL] PG84 and SSL on CentOS-5.5 was PG84 and SELinux

2010-12-07 Thread James B. Byrne
The message that I presently get makes no sense at all to me. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561

[GENERAL] PG84 and SSL on CentOS-5.5 was PG84 and SELinux

2010-12-07 Thread James B. Byrne
installed Might there be a problem between the server being compiled for i386 and openssl for i686? I cannot for the life of me determine what configuration problem causes this error. On Fri, December 3, 2010 16:04, James B. Byrne wrote: > When I try to start the server with ssl=on

Re: [GENERAL] PG84 and SELinux

2010-12-06 Thread James B. Byrne
On Mon, December 6, 2010 13:29, James B. Byrne wrote: >> > > The problem was an expired pki certificate. When we first used ssl > for pg we did not have our private CA set up. So we generated a > self-signed certificate. That certificate expired this past July > and I inf

Re: [GENERAL] PG84 and SELinux

2010-12-06 Thread James B. Byrne
l.conf ssl option to on and restarting the server no longer causes any error. Than you all for the help. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive

Re: [GENERAL] PG84 and SELinux

2010-12-04 Thread James B. Byrne
On Sat, December 4, 2010 01:11, Tom Lane wrote: > "James B. Byrne" writes: >> I wrote too soon. What I did was uncomment the ssl option. I >> neglected to change the setting from off to on. > >> When I try to start the server with ssl=on it fails with this

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread James B. Byrne
On Wed, December 1, 2010 16:54, Tom Lane wrote: > "James B. Byrne" writes: >> Earlier today I attempted to upgrade a production server >> from 8.1 to 8.4 using the pgdg-84-centos.repo. I say >> attempted because I could never get it to support ssl >> conne

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread James B. Byrne
On Thu, December 2, 2010 15:32, James B. Byrne wrote: > > On Thu, December 2, 2010 15:23, Devrim GÜNDÜZ wrote: >> On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote: >>> AFAIK, the Red Hat RPMs work out-of-the-box with SELinux; >> >> They should -- we are using

Re: [GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread James B. Byrne
*** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3

[GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread James B. Byrne
column layouts in the new database. Is there a way to load the data dumped from a single table in one database into a new, possibly differently named, table in a different database, using PG utilities? -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] PG84 and SELinux

2010-12-02 Thread James B. Byrne
start the server before I try again. If there was just something odd about the SELinux contexts on that particular host then that should clear it up. I will report whichever way it goes thereafter. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailt

Re: [GENERAL] PG84 and SELinux

2010-12-01 Thread James B. Byrne
On Wed, December 1, 2010 16:54, Tom Lane wrote: > "James B. Byrne" writes: >> Earlier today I attempted to upgrade a production server from 8.1 >> to >> 8.4 using the pgdg-84-centos.repo. I say attempted because I >> could >> never get it

Re: [GENERAL] PG84 and SELinux

2010-12-01 Thread James B. Byrne
s > that > the data directory tree wasn't correctly labeled as postgresql_db_t. > Maybe a restorecon would have helped? > > regards, tom lane > I tried a restorecon as suggested by sealert at the first error. It had no effect insofar as I could determin

[GENERAL] PG_ERROR 42501 permissions error

2010-12-01 Thread James B. Byrne
n anyone here clue me in as to what I am doing wrong? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontari

[GENERAL] PG84 and SELinux

2010-12-01 Thread James B. Byrne
== allow postgresql_t var_lib_t:dir rmdir; allow postgresql_t var_lib_t:file { write getattr link read unlink append }; Is this to be expected? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Lim

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread James B. Byrne
On Thu, November 25, 2010 21:58, Robert Treat wrote: > On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne > wrote: >> > > Looks to me like the problem is you are trying to ORDER BY columns > in > "ca_customs_entry", but there is no such table for that (don't

[GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread James B. Byrne
r with the software maintainers. On the other hand, if there is another cause of this then I would like to have that information as well. Sincerely, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited

[GENERAL] PG handling of date expressions

2009-07-19 Thread James B. Byrne
clause comparing a date to a numeric expression such as the one above? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905

Re: [GENERAL] BR/

2009-07-10 Thread James B. Byrne
> > BTW it seems necessary to clarify that LOCATION lines correspond > to the LOG/NOTICE/WARNING/ERROR line immediately _above_ it, not > the one below. > So noted, with thanks. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnema

Re: [GENERAL] BR/

2009-07-10 Thread James B. Byrne
On Fri, July 10, 2009 18:48, Scott Marlowe wrote: > On Fri, Jul 10, 2009 at 2:13 PM, James B. > Byrne wrote: >> >> 2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133) >> hll_theheart_db_admin : LOCATION:  exec_simple_query, >> postgres.c:1

Re: [GENERAL] Inserted data is disappearing

2009-07-10 Thread James B. Byrne
close to the very top of the run log, which seems congruent with the one ROLLBACK just before the very end. Evidently, all this test processing takes place within a single, never completed, transaction. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemail

[Fwd: Re: [GENERAL] How to trace client sql requests?]

2009-07-10 Thread James B. Byrne
w what is going on. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 075

[GENERAL] BR/

2009-07-10 Thread James B. Byrne
art_db_admin : LOCATION: exec_simple_query, postgres.c:1105 2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133) hll_theheart_db_admin : LOG: 0: duration: 0.782 ms statement: SELECT * FROM "currencies" The client program that receives this result reports that there

Re: [GENERAL] How to trace client sql requests?

2009-07-10 Thread James B. Byrne
ne. Is there a server side technique that I can use which will tell me what data this statement returned or if it found nothing? In any case, I see the INSERTS and I can find NO DELETES at all. Is there any other way to remove some or all data from a table? -- *** E-Mail is NOT a

[GENERAL] How to trace client sql requests?

2009-07-10 Thread James B. Byrne
RE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@

[GENERAL] PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors

2009-07-02 Thread James B. Byrne
correct. If anything is obviously wrong, or even mildly suspicious, I would appreciate a nudge in the right direction. This issue at least has no overlong dates. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca H

Re: [GENERAL] BETWEEN not matching on timestamp value]

2009-06-30 Thread James B. Byrne
On Tue, June 30, 2009 14:07, Tom Lane wrote: > > > It's the eight-digit year field that it's unhappy with ... > Duuuh! I suppose that it would... Thanks, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@hart

Re: [GENERAL] BETWEEN not matching on timestamp value

2009-06-30 Thread James B. Byrne
E currency_exchange_rates ADD COLUMN effective_from timestamp without time zone; ALTER TABLE currency_exchange_rates ALTER COLUMN effective_from SET STORAGE PLAIN; ALTER TABLE currency_exchange_rates ALTER COLUMN effective_from SET NOT NULL; -- *** E-Mail is NOT a SECURE

[GENERAL] BETWEEN not matching on timestamp value

2009-06-30 Thread James B. Byrne
g here? Have I missed something dead obvious? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario

Re: [GENERAL] cygwin and postgresql

2009-06-15 Thread James B. Byrne
the best of my ability to recollect, the owner of the development and test databases had dbcreate privileges. If the problem persists under the cygwin environment then I will revisit the native pg installation for testing. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] cygwin and postgresql

2009-06-15 Thread James B. Byrne
der one roof, so to speak, and begin checking things out from that initial point. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 90

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
Found it. The cygwin executables for postgres are installed under /usr/sbin, which is NOT in the PATH thus the problem, and the obvious solution. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Lim

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
ot;-server" in it. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 90

[GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
: pg_config.exe, pg_dump.exe and pg_dumpall.exe but no initdb.exe anywhere. Is there something about initdb that I do not understand or some reason why it would not form part of the cygwin installation? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn

Re: [GENERAL] search for partial dates

2009-06-12 Thread James B. Byrne
Is my appreciate correct? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757

[GENERAL] search for partial dates

2009-06-11 Thread James B. Byrne
Given a datetime column, not null, is there a single syntax that permits searching for all dates in a given year, year+month, and year+month+day such that a single parameterised query can handle all three circumstances? -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] Help with join syntax sought supplemental

2009-05-21 Thread James B. Byrne
ther hand, in case I was doing something out of ignorance that was notoriously wrong, it seemed best to ask. Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-

Re: [GENERAL] Help with join syntax sought supplemental

2009-05-20 Thread James B. Byrne
On Wed, May 20, 2009 13:07, James B. Byrne wrote: > This seems to be working. I had to take a different approach as I > had misapprehended GROUP BY completely. > > > SELECT * > FROM currency_exchange_rates AS xchg1 > WHERE id > IN ( > SELECT id > FROM cu

Re: [GENERAL] Help with join syntax sought

2009-05-20 Thread James B. Byrne
-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via p

Re: [GENERAL] Help with join syntax sought

2009-05-20 Thread James B. Byrne
"2009-05-19 20:40:00" "CLSE" 0.843100 and if requested for the 5 most recent then I want to see this: CAD AUD "2009-05-19 20:40:00" "CLSE" 1.131200 CAD AUD "2009-05-19 16:15:00" "NOON" 1.146300 CAD AUD "2009-05-17 20:4

  1   2   >