Re: [GENERAL] Using cp to back up a database?

2017-10-09 Thread Larry Rosenman
If you want a consistent database (you *REALLY* do), pg_dump is the correct tool. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106 From: on behalf

Re: [GENERAL] Allowing multiple versions of PG under NetBSD

2016-07-29 Thread Larry Rosenman
On 2016-07-29 15:17, D'Arcy J.M. Cain wrote: On Fri, 29 Jul 2016 15:09:59 -0500 Larry Rosenman wrote: >> version to the bare version of the binary name. Example: >> - psql.8.3 >> - psql.9.1 >> - psql.9.3 >> - psql ==> psql.9.3 >> >> Other

Re: [GENERAL] Allowing multiple versions of PG under NetBSD

2016-07-29 Thread Larry Rosenman
On 2016-07-29 15:14, Bruce Momjian wrote: On Fri, Jul 29, 2016 at 03:09:59PM -0500, Larry Rosenman wrote: >>I might take a look at the NetBSD package (I'm a developer) to see how >>hard it would be to allow multiple versions. We do keep all the lib >>stuff in a separate

Re: [GENERAL] Allowing multiple versions of PG under NetBSD

2016-07-29 Thread Larry Rosenman
On 2016-07-29 15:06, Larry Rosenman wrote: On 2016-07-29 15:04, D'Arcy J.M. Cain wrote: On Fri, 29 Jul 2016 15:07:53 -0400 Bruce Momjian wrote: > The answer is either chroot or mount and run pg_upgrade on another > server. If you can afford the downtime you can also delete PG, &g

Re: [GENERAL] Allowing multiple versions of PG under NetBSD

2016-07-29 Thread Larry Rosenman
ing to the correct library can you think of any other issues with this? Data Directory naming, as well as keeping the init-scripts straight. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 17716 Limpia Crk, R

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-29 Thread Larry Rosenman
FreeBSD? The current FreeBSD Ports collection ports only allow ONE version to be installed at a time. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 17716 Limpia Crk, Round Rock, TX 78664-7281 -- Sent via

Re: [GENERAL] Corrupted Dabatabase

2016-06-27 Thread Larry Rosenman
ve you run fsck on the filesystem? Is there any messages in /var/log/messages? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 17716 Limpia Crk, Round Rock, TX 78664-7281

Re: [GENERAL] Timestamp with timezone output

2016-05-25 Thread Larry Rosenman
results with different timezones: > > -[ RECORD 6 ]---+--- > expiration_date | 2015-09-07 00:00:00+02 > -[ RECORD 7 ]---+--- > expiration_date | 2015-11-27 00:00:00+01 > > Shouldn't all value be converted to the same timezone ? > > Thank you for your help ! D

Re: [GENERAL] FreeBSD x86 and x86_64

2016-02-23 Thread Larry Rosenman
s py-postgresql rubygem-dm-postgres-adapter rubygem-do_postgres borg.lerctr.org /usr/ports/databases $ I'm running 9.5.1 on both 11-CURRENT, and 10.x -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 7011

Re: [GENERAL] Postgresql 9.4 and ZFS?

2015-09-29 Thread Larry Rosenman
? > HowDoesZFSonLinuxHandleAdvacedFormatDrives > > EG: 2^13 = 8192 > > > > No, that would be: zfs create -o blocksize=8192 /path/to/pgdata this is for the DATASET, not the POOL > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make ch

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-17 Thread Larry Rosenman
Gavin Flower wrote: >On 18/05/13 03:06, Larry Rosenman wrote: >> On 2013-05-16 18:35, David Kerr wrote: >> >>> - I'll take a look tomorrow, but we WERE seeing Seq Scan's against >>> - multi-million >>> - row tables, so I suspect Tom is righ

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-17 Thread Larry Rosenman
likely, although you could try enable_seqscan=false as well. Dave The 9.2 upgrade DOES fix my issue. Thanks again, Tom and everyone. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 (c) E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 7868

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-16 Thread Larry Rosenman
On 2013-05-16 17:52, David Kerr wrote: On Fri, May 10, 2013 at 11:01:15AM -0500, Larry Rosenman wrote: - On 2013-05-10 10:57, Tom Lane wrote: - >Larry Rosenman writes: - >On 2013-05-10 09:14, Tom Lane wrote: - >... and verify you get a cheap plan for each referencing table. - >

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-10 Thread Larry Rosenman
On 2013-05-10 10:57, Tom Lane wrote: Larry Rosenman writes: On 2013-05-10 09:14, Tom Lane wrote: ... and verify you get a cheap plan for each referencing table. We don't :( Ugh. I bet the problem is that in some of these tables, there are lots and lots of duplicate account ids, such

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-10 Thread Larry Rosenman
On 2013-05-10 09:14, Tom Lane wrote: Larry Rosenman writes: Any ideas on how to figure out if we ARE getting seqscan check plans, and better fix it? Try an EXPLAIN ANALYZE VERBOSE on something that just deletes one row, and wait however long it takes. The printout should show how much time is

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-10 Thread Larry Rosenman
On 2013-05-09 16:43, Larry Rosenman wrote: On 2013-05-09 16:40, Tom Lane wrote: Larry Rosenman writes: On 2013-05-09 16:22, Tom Lane wrote: Perhaps it's blocked on a lock? Did you look into pg_locks? Did you note whether the process was consuming CPU time and/or doing IO? all the locks

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-09 Thread Larry Rosenman
On 2013-05-09 16:40, Tom Lane wrote: Larry Rosenman writes: On 2013-05-09 16:22, Tom Lane wrote: Perhaps it's blocked on a lock? Did you look into pg_locks? Did you note whether the process was consuming CPU time and/or doing IO? all the locks were clear, and it was consuming CPU and do

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-09 Thread Larry Rosenman
On 2013-05-09 16:22, Tom Lane wrote: Larry Rosenman writes: Ideas on how to debug? Perhaps it's blocked on a lock? Did you look into pg_locks? Did you note whether the process was consuming CPU time and/or doing IO? regards, tom lane all the locks were clear, a

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-09 Thread Larry Rosenman
On 2013-05-09 16:20, Shaun Thomas wrote: On 05/09/2013 03:58 PM, Larry Rosenman wrote: "SELECT 1 FROM ONLY "public"."ibmgbs_values" x WHERE $1 OPERATOR(pg_catalog.=) "account_id" FOR SHARE OF x" This is the statement it canceled on. I've found

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-09 Thread Larry Rosenman
On 2013-05-09 15:50, Larry Rosenman wrote: On 2013-05-02 10:08, Tom Lane wrote: Larry Rosenman writes: Question: Do all these need to have a bare index just on the account_id column, or is a multicolumn index with account_id first sufficient for the check to be reasonably quick? I would think

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-09 Thread Larry Rosenman
On 2013-05-02 10:08, Tom Lane wrote: Larry Rosenman writes: Question: Do all these need to have a bare index just on the account_id column, or is a multicolumn index with account_id first sufficient for the check to be reasonably quick? I would think that such an index would be sufficient, but

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-02 Thread Larry Rosenman
On 2013-05-02 10:08, Tom Lane wrote: Larry Rosenman writes: Question: Do all these need to have a bare index just on the account_id column, or is a multicolumn index with account_id first sufficient for the check to be reasonably quick? I would think that such an index would be sufficient

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-02 Thread Larry Rosenman
On 2013-05-01 10:17, Larry Rosenman wrote: I have an app that we have a number of tables that all have FK relationships with the account table. We did a massive (2900+ account, probably multi-thousand rows) delete from all the tables, and the delete from the account table is taking a lot of

Re: [GENERAL] LONG delete with LOTS of FK's

2013-05-01 Thread Larry Rosenman
On 2013-05-01 10:23, Shaun Thomas wrote: On 05/01/2013 10:17 AM, Larry Rosenman wrote: I have an app that we have a number of tables that all have FK relationships with the account table. OK so far. Referenced by: * Redacted one-billion foreign keys Wow. I really hope every single

[GENERAL] LONG delete with LOTS of FK's

2013-05-01 Thread Larry Rosenman
ot; CONSTRAINT "text_search_data_account_id_fkey" FOREIGN KEY (account_id) REFERENCES account(id) TABLE "troweprice2_values" CONSTRAINT "troweprice2_values_account_id_fkey" FOREIGN KEY (account_id) REFERENCES account(id) TABLE "usage" CONSTRAINT "usage_account_id_f

Re: [GENERAL] 9.1.4: pg_restore: couldn't uncompress data?

2012-07-30 Thread Larry Rosenman
On Mon, July 30, 2012 9:14 pm, Craig Ringer wrote: > On 07/24/2012 09:50 PM, Larry Rosenman wrote: >> This one is concerning. Trying to restore a backup from one system to >> another, and got this: >> >> pg_restore: restoring data for table "userid" &g

[GENERAL] 9.1.4: pg_restore: couldn't uncompress data?

2012-07-24 Thread Larry Rosenman
of error [lrosenman@bpsandbox-db2 ~]$ ls -l db* -rw-rw-r-- 1 lrosenman blueprint 10838183690 Jul 23 17:58 db.backup.2012_07_21T062258 [lrosenman@bpsandbox-db2 ~]$ The file is the same size on both systems, and was transferred with scp. Any ideas why I would see this? -- Larry Rosenman

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Larry Rosenman
; >>>>> https://www.dbainspace.com/finalists/joe-miller >>>>> >>>>> Voting is open for 7 days. Don't let one of those Oracle or >>>>> SQL Server punks win :p >>>> so jealous -- I didn't make the cut. Well, you'll

Re: [GENERAL] When is the release date for Postgres 8.5?

2010-01-22 Thread Larry Rosenman
On Fri, 22 Jan 2010, John R Pierce wrote: Larry Rosenman wrote: Yeah. The question of "when do we call it 9.0" has come up multiple times over the past few release cycles, and "when we get built-in replication" has always been one of the more popular answers. If HS

Re: [GENERAL] When is the release date for Postgres 8.5?

2010-01-22 Thread Larry Rosenman
: - "Larry Rosenman" writes: On Thu, January 21, 2010 5:53 pm, Andreas Joseph Krogh wrote: Care to shed some light on what features (yes, we users care about features) warrant this major version-bump? Is there a link somewhere? AFAIR, it was stated if Hot Standby AND Streaming Repli

Re: [GENERAL] 64bits or 32 bits on ESX?

2010-01-21 Thread Larry Rosenman
I have seen no difference in performance. Now, if you want large memory for a DB server, and you should, 64 is the way to go. I'm currently running CentOS 5 64-Bit vm's for the SaaS app I support. Works great on ESX 4U1. -- Larry Rosenman http://www.lerct

Re: [GENERAL] PG_DUMP/PG_RESTORE duplicate Rows?

2009-12-01 Thread Larry Rosenman
Never mind. I had my appserver up, and it probably screwed up. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message- From: pgsql-general

[GENERAL] PG_DUMP/PG_RESTORE duplicate Rows?

2009-12-01 Thread Larry Rosenman
? Yes, we're moving to 8.4.1 on our next release (12-12-2009). I cleaned it up by: druckerdb=> delete from last_run where ctid='(0,10)' or ctid='(0,60)'; DELETE 2 and putting the constraint back in place. -- Larry Rosenman http://w

Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Larry Rosenman
On Tue, 5 Feb 2008, Dave Page wrote: On Feb 5, 2008 3:07 PM, Larry Rosenman <[EMAIL PROTECTED]> wrote: On Tue, 5 Feb 2008, Dave Page wrote: Another option which may be doable for someone with more knowledge of make would be to build binaries for all architectures seperately (you can

Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Larry Rosenman
to choose an index scan if your joining column's datatypes do not match -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---

Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Larry Rosenman
nd just built it twice, and then lipo'd the 2 bin and lib directory files together as a quick hack. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index s

Re: [GENERAL] postgres query log analysis?

2006-10-09 Thread Larry Rosenman
> > Is there any other option? When you enable query logging in your > PGSQL logs what do you do with the output? > > Thanks! > Look into pgfouine on pgFoundry. http://pgfoundry.org/projects/pgfouine/ -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1

Re: [GENERAL] postmaster: StreamConnection: accept: No such device or address

2006-07-18 Thread Larry Rosenman
hanks, > reid Is something cleaning /tmp of the unix socket? Older versions didn't keep the timestamp updated, and /tmp cleaning utilities could remove the socket. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerct

Re: [GENERAL] php 5.1.4 w/ PostgreSQL 8.1.4

2006-06-05 Thread Larry Rosenman
port. > > Everything was build the usual way from ports on FreeBSD 5.4. > > Regards, > Iv do you have a reproduce script? I have FreeBSD/amd64 6.1-RELEASE, pg 8.1.4, PHP 5.1.4, Apache 2.2.2 all from ports, playing nicely. Just another data point (yes, I know the apache is differen

Re: [GENERAL] autovacuum "connections" are hidden

2006-05-18 Thread Larry Rosenman
would it help people who are trying to determine if > pg_autovacuum is running? Would the connection still appear while > pg_autovacuum is sleeping? I believe while autovacuum is sleeping, the process is gone. I.e. it gets spawned anew for each pass looking for work. -- Larry Rosenman

Re: [GENERAL] out of memory for query result

2006-05-03 Thread Larry Rosenman
e prior month's data which had fewer results). This would either > point to an issue with a) amd64 memory allocation or b) palloc > interacting with 64bit memory or c) some other change. My suspicion is that it has to do with pointers being 8 bytes vs 4 bytes in amd64. -- Larry Rosenman

Re: [GENERAL] psql is slow and it does not take much resources

2006-05-03 Thread Larry Rosenman
taking 3% of them. > I'll bet your WAL disk is mostly WAIT-I/O, waiting for the WAL log flushes at end of transaction. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.

Re: [GENERAL] psql is slow and it does not take much resources

2006-05-03 Thread Larry Rosenman
tch the inserts between BEGIN;/COMMIT; pairs, or, better yet set it up as a COPY. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: ww

Re: [GENERAL] psql is slow and it does not take much resources

2006-05-03 Thread Larry Rosenman
at could be the problem? Is that the server is just slow reading > from the file? It has a 300GB SCSI drive. > > Is there any way to make this work faster? I would like to recreate > the db at least once a month, but this taked too much time... > > Thanks in advance for any advi

Re: [GENERAL] Autovacuum Logging

2006-04-28 Thread Larry Rosenman
then look, > which will of course contain a whole lot of other chatter at that > level. > > The best solution I have seen so far is the idea of a GUC to control > autovacuums chatter level. I hope we get that becuase the above will > be a regression imho. I'

Re: [GENERAL] SESSION_USER vs. CURRENT_USER

2006-02-06 Thread Larry Rosenman
attribute of a function. CURRENT_USER is what is used for permission checks. see the manual. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: ww

Re: [GENERAL] Data type that corresponds to bigserial...

2006-01-18 Thread Larry Rosenman
bytes > used to store the integer, or something like that. > > If I set the data type of the foreign key to "int8" in pgAdmin, will > this correspond to the integer type stored by the bigserial data > type? > > In other words, are int8 and bigint the same thing? >

Re: [GENERAL] About Full-text searching under postgresql

2006-01-17 Thread Larry Rosenman
rticle/21674/0/page/3 or http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ Those are good places to start. using the contrib/tsearch2 module. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531

Re: [GENERAL] Granting Privleges on All Tables in One Comand?

2006-01-12 Thread Larry Rosenman
on the TODO list: > > Also, you can do it today by making a plpgsql function that iterates > through all the tables and does GRANTs. There are examples in the > mailing list archives. (The TODO item would probably have been done > by now if it weren't so easy to work aroun

Re: [GENERAL] Can't connect to postgresql using 'psql -d database -U user -W'

2006-01-05 Thread Larry Rosenman
d you are not running the command as the unix user postgres. Check your pg_hba.conf file and the documentation on the pg_hba.conf file: http://www.postgresql.org/docs/current/static/client-authentication.html #AUTH-PG-HBA-CONF -- Larry Rosenman Database Support Engineer PERVASIVE

Re: [GENERAL] storing PDFs

2006-01-01 Thread Larry Rosenman
former employer of mine. Works great. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US ---(end of broadcast)--- T

Re: [GENERAL] querying PostgreSQL version?

2005-10-26 Thread Larry Rosenman
On Oct 26, 2005, at 7:52 AM, Zlatko Matić wrote: Hello. Is there any way to check the version of PostgreSQL by a query? Maybe by querying catalog tables? Thanks, select version(); Zlatko -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-351-4152

Re: [GENERAL] insert a value into a table

2005-10-21 Thread Larry Rosenman
double the backslashes.  They are an escape character.     --Larry Rosenman http://www.lerctr.org/~lerPhone: +1 972-414-9812 E-Mail: ler@lerctr.orgUS Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Re: [GENERAL] PostgreSQL on Dual Processors, Dual-Core AMD Chips

2005-10-18 Thread Larry Rosenman
chips? Any information would be helpful... Thank you! Each connection is a separate process, so yes it will, assuming multiple connections to the backend. There are numerous threads in the archives on why we don't use threading. -- Larry Rosenman

Re: [GENERAL] Cannot compile on Slackware 10.2

2005-10-12 Thread Larry Rosenman
Shot in the dark: Check your clock. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Re: [GENERAL] [SQL] How to add 1 hour in a date or time stamp?

2005-04-18 Thread Larry Rosenman
On Monday 18 April 2005 08:38 am, Dinesh Pandey wrote: > How to add 1 hour in a date or time stamp? timestamp + '1 hour'::interval is one way. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-351-4152 E-Mail: ler@lerctr.org US Mail

Re: [GENERAL] Scalability with large numbers of tables

2005-02-20 Thread Larry Rosenman
;> directories take a significant time. (In other applications I've >> generally used a guide of 100-1000 files per directory before adding >> extra layers, but I don't know how valid this is.) PostgreSQL breaks tables down into 1GB segments, and oversized attrib

Re: [GENERAL] Can't build libpq test example

2005-02-09 Thread Larry Rosenman
testlibpq.o >> PQntuples testlibpq.o >> ld fatal: Symbol referencing errors. No output written to testlibpq >> >> ---(end of >> broadcast)--- >> TIP 2: yo

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-08 Thread Larry Rosenman
Oleg Bartunov wrote: > On Tue, 8 Feb 2005, Larry Rosenman wrote: > >> Oleg Bartunov wrote: >>> On Tue, 8 Feb 2005, Larry Rosenman wrote: >>> >>>> >>>> It doesn't seem to like pieces with hyphens ('-') in the name, when

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-08 Thread Larry Rosenman
Oleg Bartunov wrote: > On Tue, 8 Feb 2005, Larry Rosenman wrote: > >> >> It doesn't seem to like pieces with hyphens ('-') in the name, when I >> try To update blacklist set new_domain_lt=text2ltree(domain) I get a >> Syntax error (apparently for th

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-08 Thread Larry Rosenman
Oleg Bartunov wrote: > On Tue, 8 Feb 2005, Larry Rosenman wrote: > >> On Tue, 8 Feb 2005, Oleg Bartunov wrote: >> >>> On Mon, 7 Feb 2005, Larry Rosenman wrote: >>> >>>> Oleg Bartunov wrote: >>> >>> Larry, I pointed you to pg_

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-08 Thread Larry Rosenman
On Tue, 8 Feb 2005, Oleg Bartunov wrote: On Mon, 7 Feb 2005, Larry Rosenman wrote: Oleg Bartunov wrote: Larry, I pointed you to pg_trgm module mostly following Martijn's suggestions. Now, I see you need another our module - ltree, see http://www.sai.msu.su/~megera/postgres/gist/ltree/ for de

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-07 Thread Larry Rosenman
he index with the 254 domains I have in my fecal roster, but it's also about 5x as fast as the other REGEX lookup. Thanks for the ideas! LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org U

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-07 Thread Larry Rosenman
=# select * from blacklist limit 1; insert_when | insert_who | domain | message ++--+--- -- 2003-12-22 21:02:49-06 | ler| 008\.net | 127.0.0.1 MX, SPAMMER (008.net) (1 row) exim=# Thanks! LER -- La

Re: [GENERAL] timestamps

2004-05-25 Thread Larry Rosenman
ery to do it? You are looking for a trigger. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail:

Re: [GENERAL] [pgsql-advocacy] Fwd: Favorite DB poll on ORA

2004-02-07 Thread Larry Rosenman
s Aglio Database Solutions San Francisco -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description: PGP signature

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Larry Rosenman
hrough Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail:

Re: [GENERAL] Parse error help needed...

2004-01-12 Thread Larry Rosenman
--(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description: PGP signature

Re: [GENERAL] bind-dlz with postgresql driver ...

2003-12-17 Thread Larry Rosenman
-(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Larry Rosenman

Re: [GENERAL] FW: Postgres 7.4 runing on BSD

2003-12-05 Thread Larry Rosenman
--On Friday, December 05, 2003 17:29:06 -0500 Vivek Khera <[EMAIL PROTECTED]> wrote: "LR" == Larry Rosenman <[EMAIL PROTECTED]> writes: LR> --On Friday, December 05, 2003 12:43:24 -0800 "Gregory S. Williamson" LR> <[EMAIL PROTECTED]> wrote: If anyone

Re: [GENERAL] FW: Postgres 7.4 runing on BSD

2003-12-05 Thread Larry Rosenman
dconfig -m /usr/local/lib ===> Registering installation for gettext-0.11.5_1 ===> Returning to build of gmake-3.80_1 Error: shared library "intl.5" does not exist *** Error code 1 ---(end of broadcast)--- TIP 4: Don't 'kill

Re: [GENERAL] plperl/createlang issue

2003-11-11 Thread Larry Rosenman
is no libperl.so (from the perl build). Check your PERL build. $ perl -v This is perl, v5.8.0 built for i386-linux-thread-multi ... Any clues for the clueless? TIA. Ed ---(end of broadcast)--- TIP 8: explain analyze is your

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Larry Rosenman
--On Sunday, September 28, 2003 00:14:18 -0300 "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: On Sat, 27 Sep 2003, Larry Rosenman wrote: perl ships on UnixWare (5.005, but that will change in UP3). In what way? :) It won't ship anymore ... or upgraded? upgraded to 5.8.0

Re: Rewriting pg_upgrade (was Re: [GENERAL] State of Beta 2)

2003-09-27 Thread Larry Rosenman
maybe Unixware I know that Solaris now has it included by default ... ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail:

Re: [GENERAL] Using YY-MM-DD date input

2003-07-28 Thread Larry Rosenman
x27;, 'MDY', and 'YMD' input > datestyle options. > > Did we come to a conclusion on whether DMY and MDY ought to become > the preferred names for those input modes, rather than EURO and US? > I'm leaning towards doing it ... I'd vote for DMY/MDY for

[GENERAL] Re: [HACKERS] 2 gig file size limit

2001-07-06 Thread Larry Rosenman
;t have to worry about it. LER > -- > Naomi Walker > Chief Information Officer > Eldorado Computing, Inc. > 602-604-3100 ext 242 > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] records zapped to null

2001-03-26 Thread Larry Rosenman
177 1595 > Computing & Network solutions. Fax: 08-8177 0133 > > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster -- Larry Rosenman http://www.ler

Re: [GENERAL] sorting on inet type?

2001-03-20 Thread Larry Rosenman
I believe this is fixed in 7.1. LER >> Original Message << On 3/20/01, 11:16:42 AM, Daniel "J." Kressin <[EMAIL PROTECTED]> wrote regarding [GENERAL] sorting on inet type?: > I have a table with an inet column, which I entered in order initially, > so they c

[GENERAL] Re: Unixware 7.1.1 problem with psql

2001-02-22 Thread Larry Rosenman
d what I am doing wrong. Any help appreciated. There is a bug in the accept() function on UnixWare and OpenServer. There is a patch in the FAQ_SCO file, or grab the 7.1beta4 tarball. LER > >Joel > > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +

Re: [GENERAL] connecting in shell scripts ??

2001-01-04 Thread Larry Rosenman
nvironment. Larry > > When processing for output, you have to check for the prompt > "Password:", though. Maybe there's a better way... > > -- > Alvaro Herrera () -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Larry Rosenman
d use the database engine. Any help on this problem would > be greatly appreciated. In 7.1 (Beta now), it has LD_RUN_PATH (aka -R) set on those operating systems that support it. I was able to remove my LD_LIBRARY_PATH settings when I went to 7.1beta1 on my UnixWare box. Larry &

Re: [GENERAL] How To Log User Name + Database?

2000-12-06 Thread Larry Rosenman
ion: host=[local] user=ler database=regression in the syslog. So, I think it's there already. > > Comments anyone? > > regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [GENERAL] More SCO funnies

2000-12-01 Thread Larry Rosenman
* Dave Smith <[EMAIL PROTECTED]> [001201 13:05]: > Larry Rosenman wrote: > > > * Dave Smith <[EMAIL PROTECTED]> [001201 12:11]: > > > >> Ok so thanks to Larry I managed to get postgresql compiled and running > >> on SCO. Now I'm try

Re: [GENERAL] More SCO funnies

2000-12-01 Thread Larry Rosenman
_util.o > i386ld fatal: Symbol referencing errors. No output written to t_postgresql > put the -lpq -lm AFTER the .o file > Larry, can you work your magic again? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [GENERAL] Bug? 'psql -l' in pg_ctl?

2000-11-29 Thread Larry Rosenman
see a protocol extension or some such to maybe collect SNMP or other statistical data that could be used later for tuning. If we do a protocol change, let's make it extensible LER > > regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [GENERAL] sgmlspl?

2000-11-28 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001128 14:37]: > Duh. I knew that. Thanks. My week for stupids, I guess. > next hurdle, where do I find docbook2man? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL P

RE: [GENERAL] sgmlspl?

2000-11-28 Thread Larry Rosenman
Duh. I knew that. Thanks. My week for stupids, I guess. -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 28, 2000 2:33 PM To: Larry Rosenman Cc: [EMAIL PROTECTED] Subject: RE: [GENERAL] sgmlspl? Larry Rosenman writes: > Ok, I found t

RE: [GENERAL] sgmlspl?

2000-11-28 Thread Larry Rosenman
Makefile", line 22: Need an operator "Makefile", line 24: Need an operator "Makefile", line 26: Need an operator "Makefile", line 27: Need an operator "Makefile", line 29: Need an operator "Makefile", line 34: Need an operator "Makefile&qu

[GENERAL] sgmlspl?

2000-11-28 Thread Larry Rosenman
Greetings, I was trying to build a full 7.1devel documentation set and noticed that my FreeBSD box didn't have sgmlspl, and I can't find it in the FreeBSD ports collection. What tool is this? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 97

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Larry Rosenman
w anything over UNIX domain sockets and localhost. localall trust host all 127.0.0.1 255.255.255.255 trust host all 207.158.72.11 255.255.255.255 trust host all 207.158.72.45 255.255.255.255 t

Re: [GENERAL] Re: PL/Perl compilation error

2000-10-24 Thread Larry Rosenman
> > I thinks it's now fully compatible with all Perl versions, > > yes Tom I use PPPort :-) > > Excellent! I'll check it over and put it in the tree. Thank you. > > regards, tom lane -- Larry Rosenman http://www.lerctr.o

Re: [GENERAL] [HACKERS] pg_connect error

2000-10-18 Thread Larry Rosenman
> > > > (both the database and owner are valid and tested via psql) > > > > apache complains: > > /usr/libexec/ld.so: Undefined symbol "_PQconnectdb" called from >httpd:/usr/lib/apache/modules/libphp4.so at 0x4030a394 > > > > I h

Re: [GENERAL] FreeBSD Softupdates??

2000-10-04 Thread Larry Rosenman
<[EMAIL PROTECTED]> > > Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc > > Encrypted mail welcomed > > > > I am not interested in the past. I am interested in the future for > > that is where I intend to spend the rest of my life. > >

Re: [GENERAL] datestyle problems?

2000-09-06 Thread Larry Rosenman
ld be month day year; > > > > iso > > > >1999-12-31 > Right. > > > > german > > > >31.12.1999 > Right. > > > Cheers, > Geoff Russell > - - - - - - - - - -

Re: [GENERAL] Re: [HACKERS] PostgreSQL Mailing Lists ...

2000-03-09 Thread Larry Rosenman
gt; > from the docs, this should enable digests for you ... there is no longer a > seperate list for -digest vs non-digest ... in fact, your aliases file > contains 4 lines per mailing list, including archiving and digests > ... nice and clean/compact ... > > > > - What