[GENERAL] pg_resetxlog question

2005-07-24 Thread Andrew Rawnsley
oned above (idleness, clean shutdown, etc), would that be true in this case? ---- Andrew Rawnsley Chief Technology Officer Investor Analytics, LLC (740) 587-0114 http://www.investoranalytics.com ---(end of broadcast)--- TIP 1: if posti

Re: [GENERAL] Replication

2005-09-14 Thread Andrew Rawnsley
On 9/13/05 2:45 PM, "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > On Tue, 2005-09-13 at 10:45, Russ Brown wrote: >> Simon Riggs wrote: >>> Barry, >>> >>> You can use PITR to archive transaction logs to a second server that is >>> kept in standby mode. >>> >>> This will cope with any number of

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-11-01 Thread Andrew Rawnsley
If you read the FAQ, you will see: Oracle has announced an entry-level, small footprint starter database called Oracle Database 10g Express Edition (Oracle Database XE), which is: Free to download Free to develop & deploy Free to distribute (including ISVs) Oracle Database XE is free for runtim

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-11-02 Thread Andrew Rawnsley
> TIP 1: 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 -- Andrew Rawnsley Chief Technology Officer Investor Analytics, LLC (740

Re: [GENERAL] question about Postgresql and rsync

2005-11-03 Thread Andrew Rawnsley
You're better off doing a live backup with the PITR mechanism. That way its not a trick (assuming you're running 8.0+). If you are archiving logs, do select pg_start_backup(); (do rsync,tar,cp -r,whatever) select pg_stop_backup(); Do an archive recovery with any saved logs, add 2 eggs, stir, and

Re: [GENERAL] comp.database.postgresql.*

2004-11-11 Thread Andrew Rawnsley
: don't forget to increase your free space map settings Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: RES: [GENERAL] NewsForge Poll: Favorite open source database?

2004-12-21 Thread Andrew Rawnsley
charge for it. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com

Re: [GENERAL] Wisconsin Circuit Court Access (WCCA) on PostgreSQL

2006-03-14 Thread Andrew Rawnsley
One doesn't 'install' oracle. That implies you have control of the situation. One attempts to convince it to condescend to install itself onto your machine. Of course, this is like convincing my 3 year old to go to bed on time. Such powers of persuasion are not common. On 3/13/06 5:41 PM, "Sco

Re: [GENERAL] make error Mac OS X (ar: illegal option -- s)

2003-12-13 Thread Andrew Rawnsley
ive" avec vos amis ? Télécharger MSN Messenger http://www.ifrance.com/_reloc/m la 1ère messagerie instantanée de France ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Andrew R

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-30 Thread Andrew Rawnsley
..... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Hierarchical queries

2004-01-09 Thread Andrew Rawnsley
rov ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Fw: postgres DB duplication

2004-01-27 Thread Andrew Rawnsley
e the plunge ??   Cheers Colm     ~~~ My Website  :http://www.angelfire.com/ia/japan/ BoomBox :http://www.b00mb0x.org ~~~     ---- Andrew Rawnsley President The Ravensfield Digital Res

Re: [GENERAL] recursive query?

2004-02-02 Thread Andrew Rawnsley
ite building tool. Try it! http://webhosting.yahoo.com/ps/sb/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---- Andrew

Re: [GENERAL] PostgreSQL License

2004-02-15 Thread Andrew Rawnsley
Smekalin ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com

Re: [GENERAL] Replication options

2004-02-19 Thread Andrew Rawnsley
Mob: 07960 321599   -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support. ---- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740

Re: [GENERAL] faster SELECT

2004-03-08 Thread Andrew Rawnsley
aluation order after analyzing a and b. Bye, Chris. ---(end of broadcast)--- TIP 8: explain analyze is your friend -------- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114

Re: [GENERAL] PG vs MySQL

2004-03-29 Thread Andrew Rawnsley
a lawyer (particularly in the environmental space. The lawyers are the only ones who make any money...). ---- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)---

Re: [GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-16 Thread Andrew Rawnsley
TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---

Re: [GENERAL] postgresql idle

2004-04-29 Thread Andrew Rawnsley
on. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -------- Andrew Rawnsle

Re: [GENERAL] Dates

2004-06-03 Thread Andrew Rawnsley
__ Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora: http://br.yahoo.com/info/mail.html ---(end of broadcast)------- TIP 8: explain analyze is your friend Andrew Rawnsley

Re: [GENERAL] Replication options?

2004-08-11 Thread Andrew Rawnsley
aging of what's in CVS and that will be it, unless someone else wants to pick it up. Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 2: yo

Re: [GENERAL] Postgresql feature

2004-08-18 Thread Andrew Rawnsley
ts at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Queries across multiple databases  (was: SELECT from a table in another database).

2001-05-21 Thread Andrew Rawnsley
And maybe their pinheaded sales reps WOULD STOP CALLING ME EVERY WEEK. If I ever come up with said schema-dropping patch, and anyone else wants it, let me know. -- Regards, Andrew Rawnsley Ravensfield Geographic Resources, Ltd. (740) 587-0114 www.ravensfield.com --

Re: [GENERAL] State of Beta 2

2003-09-16 Thread Andrew Rawnsley
alyze is your friend -------- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [GENERAL] State of Beta 2

2003-09-16 Thread Andrew Rawnsley
through that it almost sounds like a ramble ... hopefully you understand what I'm asking ... I know when I was at the University, and they dealt with Oracle upgrades, the guys plan'd for a weekend ... -------(end of broadcast)--- TIP 4: Don'

Re: [GENERAL] State of Beta (2)

2003-09-18 Thread Andrew Rawnsley
? http://www.postgresql.org/docs/faqs/FAQ.html Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] State of Beta 2

2003-09-18 Thread Andrew Rawnsley
certain conditions. It doesn't solve it. I think if we can get Mr. Drake's initiative off the ground we may at least figure out if there is a solution. Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 w

Re: [GENERAL] Sequences

2003-09-18 Thread Andrew Rawnsley
Oh, its a sticky problem, to be sure. Have to get something working at some point, though... You're point about approximate solutions is well taken. On Friday, September 19, 2003, at 01:11 AM, Tom Lane wrote: Andrew Rawnsley <[EMAIL PROTECTED]> writes: On Friday, September 19, 200

Re: [GENERAL] Sequences

2003-09-18 Thread Andrew Rawnsley
On Friday, September 19, 2003, at 12:21 AM, Tom Lane wrote: Andrew Rawnsley <[EMAIL PROTECTED]> writes: Sequence information is stored in their individual 1-row tables, with an entry is pg_class of relkind 'S'. So you can't really get a list of sequences with last_value i

Re: [GENERAL] Can anyone recommend a good PostGres admin tool?

2003-10-01 Thread Andrew Rawnsley
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 ---- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587

Re: [GENERAL] [Erserver-general] alternate eRServer build

2003-10-22 Thread Andrew Rawnsley
On Wednesday, October 22, 2003, at 03:03 PM, Andrew Sullivan wrote: On Wed, Oct 22, 2003 at 02:43:54PM -0400, Andrew Rawnsley wrote: This is to announce an alternate fork/build of the eRServer 1.2 code base, provided to the community for testing purposes. If everything works out fine, and the

Re: [GENERAL] Setting up DSPACE for Postgres access

2003-10-24 Thread Andrew Rawnsley
-- TIP 6: Have you searched our list archives? http://archives.postgresql.org Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 9:

Re: [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Andrew Rawnsley
TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

2003-12-01 Thread Andrew Rawnsley
e may translate 'too hard' into 'I'm too lazy to learn something different and provide better service to my customers'. Or, in the interests of simplicity, 'I'm too dumb'. Andrew Rawnsley President The Ravensfiel

Re: [GENERAL] Storing passwords

2003-12-04 Thread Andrew Rawnsley
: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broa

[GENERAL] 'Exotic' Features

2001-03-11 Thread Andrew Rawnsley
'standard' commercial DBs is difficult without even being able to fake this (i.e. having the parser drop the schema name in a query at the least). I would drop Oracle like a skunked beer if I could get over this hurdle... -- Regards, Andrew Rawnsley Ravensfield Geographic Resources,