Re: [GENERAL] PostgreSQL for Firefox Bookmarks?

? Could a smaller db like sqlite be a better option? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz -- 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] PostgreSQL versus MySQL for GPS Data

like google maps comes in at? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz -- 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] Pet Peeves?

to build an access style front end that isn't fixed to one db structure. dim rs as recordset rs = db.sqlquery(select...) for x = 1 to rs.fieldcount if vartype(rs.idxfield(x).value) = kTypeDate then ... ... next you could also use rs.idxfield(x).stringvalue and parse it yourself -- Shane Ambler

Re: [GENERAL] Data comparison SQL in PG 8.2.9

in the select. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] Favorite Tom Lane quotes

just mythology. Of course the true believers will argue endlessly about the wonders of what can be done and how important it is, but they tend to have a low conversion rate among the listeners. ;-) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via

Re: [GENERAL] Install question on Mac Leopard Server 10.5

OS X Server Firewall has a hole for the port to be used. If you have missed this then you need to open port 5432 on your firewall. What am I missing? Any help would be greatly appreciated... -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql

Re: [GENERAL] Using Postgres to store high volume streams of sensor readings

It was a few versions ago so may be changed by now, but I reckon it was the temp_store setting - which is described as temp tables and indexes but is (or was) also used for large query and sorting needs. Setting this to memory did make a difference for some queries. -- Shane Ambler pgSQL

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

kern.ipc.semusz: 92 kern.ipc.semume: 10 kern.ipc.semopm: 100 kern.ipc.semmsl: 60 kern.ipc.semmnu: 30 kern.ipc.semmns: 60 kern.ipc.semmni: 10 kern.ipc.semmap: 256 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Foreign Key 'walker'?

. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] postgresql and Mac OS X

- This is an Apple GCC extension - I don't think it has made it into the general GCC release. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Opteron vs. Xeon performance differences

to on-board controllers) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] General data warehousing questions

use RAID-5 but it has some seriously negative performance implications for parallel load handling and write speed. You may also be interested in looking at BioPostgres http://phenomics.cs.ucla.edu/ -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql

Re: [GENERAL] postgres user account on OSX

the EDB installer would have left it as is. If you want a GUI to alter the home location of the existing user account run NetInfo Manager which is in /Applications/Utilities -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list

Re: [GENERAL] Restoring a database from a file system snapshot

and all of it's associated contents in your z drive folder - outside of the cluster's data folder where the logs, transaction logs and system wide data is located. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] WAL file questions - how to relocate on Windows, how to replay after total loss, etc

backup of the actual database files. John -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] WAL file questions - how to relocate on Windows, how to replay after total loss, etc

Alan Hodgson wrote: On Thursday 28 August 2008, Shane Ambler [EMAIL PROTECTED] wrote: If you have a filesystem backup from 6 hours ago, then the WAL files as they are now can be used to update the backup to match the db as it is now. This makes the filesystem backup have two points of interest

Re: [GENERAL] Help Me !!!

are correct? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] mac install question

Shane Ambler wrote: [EMAIL PROTECTED] wrote: Is the otool program on your system anywhere? Afaik, it should be on any Mac, but maybe it's part of xcode (i hope not- can anyone confirm?) I have a few installs here. now that I think about it - it may be a dev tools only thing. otool

Re: [GENERAL] A couple of newbie questions ...

(NULL,'y','z') -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] A couple of newbie questions ...

with INSERT INTO table (fld_x, fld_y,fld_z) VALUES (NULL, 'y','z') is DEFAULT a better option than using NULL? or is it just a preference to spell out the implied default entry? I've only used DEFAULT in CREATE TABLE(...) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http

Re: [GENERAL] mac install question

on also includes otool at /usr/bin A minimal 10.3 install has otool at /usr/bin A clean 10.5 install does not have otool -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] 10.5 OS X ppc64 problem

as a universal binary. The current makefiles don't support the option but a couple of people have come up with work arounds. I do believe that there are plans to add this to future releases. An informative post would be - http://archives.postgresql.org/pgsql-general/2008-02/msg00200.php -- Shane Ambler

Re: [GENERAL] Requirements For Postgresql Database

get some guesses about whether 2 or 4 GB will suit your situation. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Losing data

are things committed? After entry or at user logoff? Is there some user data updated on logout that gets an error and rolls back? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Database design: Storing app defaults

a column they depend on. To change the use of an existing column can have a similar affect. A little thought before you make changes to consider how the change will affect existing apps can prevent these issues. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent

Re: [GENERAL] Database design: Backwards-compatible field addition

to have changes can help you design now to make it easier later. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] Database design: Backwards-compatible field addition

to weigh up these changes to decide whether app v1.x will continue to be usable or must be upgraded for further use. Of course you can leave an old column there for old apps and have new apps ignore it eg. remove it from SELECT statements in the new app. -- Shane Ambler pgSQL (at) Sheeky

Re: [GENERAL] Database design: Storing app defaults

options. I would think that one table is sufficient for the scenario you describe. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Extracting data from deprecated MONEY fields

simpler. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] New MS patent: sounds like PG db rules

the same with different contributors. I am sure there was another but I can't seem to recall what it was. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Copying data from a table to another database

table. As the table on the new server grows exponentially (already nearing 1M records) I need to do this asap unless I want the entire thing to take forever... (sweat) Could someone please lend me a hand here? Already thankful for any insight, -- Shane Ambler pgSQL (at) Sheeky (dot) Biz

Re: [GENERAL] Optimzing Postgresql

. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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 modify a view

with a new query that generates the identical set of columns (i.e., same column names and data types). /manual quote -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Link tables from different databases

headaches (think endless loops). You may want to have one db with the table and use functions to access the data from the other db. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Need for help!

Semi Noob wrote: My CPU is 2CPU: Intel(R) Xeon(TM) CPU 3.20GHz. Disk: disk system is RAID-5; Early versions of postgresql had issues with P4 HT CPU's but I believe they have been resolved. I am quite certain that it only related to the early P4's not the Xeon. -- Shane Ambler pgSQL

Re: [GENERAL] changing the endianness of a database

all the non-transient data whenever the application is shut down (in anticipation of an upgrade)? As far as upgrades that could/should be handled in the installer script. Dump from the installed version then install the new one and restore. That is - using Apple's installer setup. -- Shane

Re: [GENERAL] Problems with memory

50300 registers, so if I try to do a cross select between tables it could be worse. You may hear from people on this list that have db's storing many TeraBytes of data. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list

Re: [GENERAL] Help! ERROR: could not open relation

as I know you have the same options. From a dos prompt (I would cd to c:\program files\postgresql\8.2\bin) enter postgres --single dbwithproblems -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] help with plpgsql

are connected to when you run psql? I would probably add the CREATE LANGUAGE command to the start of the perl script. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Not Geography

install how to get started using it? How to do it depends on the operating system you are using. Once you have it installed you may want to join the Postgis newsgroup for further help http://postgis.refractions.net/mailman/listinfo/postgis-users Hope that helps, Regina -- Shane Ambler pgSQL

Re: [GENERAL] include PostgreSQL utilities into 3rd party program package

restrictive license and each must be checked individually. See the following for full license which is also included in the source files - http://www.postgresql.org/about/licence -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list

Re: [GENERAL] Proper Installation of Postgres and Postgis on 10.5 Intel

? Is the shp file known to import ok on other installations? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] High Availability / Replication with Sequoia

? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] mac ports question

believe if it's getting far enough to actually try running PostgreSQL the logs would be being put somewhere like /opt/local/var/log/postgresql82 (or at least the 83 port seems to put it in a postgresql83 from there) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz

Re: [GENERAL] Using tables in other PostGreSQL database

cross db data sharing. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] GSoC Proposal: PL/Mono

of them might help you find someone with a copy of it. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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 use database?

command in pgAdmin (Tools menu). If it doesn't work, backup from pgadmin as a plain file and compare what it puts out to what you have done. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

named progs in place for a few versions though. Or have them as a config option. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

Greg Smith wrote: And if anybody suggests putting a _ in something I have to type all the time, I will stick my fingers in my ears and start yelling until they stop. Bad enough I have to type pg_ctl a few times every day now. +10 on hating _ -- Shane Ambler pgSQL (at) Sheeky (dot) Biz

Re: [GENERAL] Checking if Aggregate exists

and SELECT count(*) FROM If it ain't there you get 0 returned - no errors. In your function you can test 0 and return true else false or you can return the count and test numerically against the return. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via

Re: [GENERAL] PostgreSQL, clusters and load-balance

requests between these replicated servers. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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 use database?

the psql command \i myscript.sql to run the script. You may need to add full pathnames in these examples. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Make MS Access UPDATE PostGre SQL Table

- echo \copy mytable from mylocaldata.csv | psql I'm sure you could do a vb script to do that for you if you wanted to stay in Access. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Table size

-- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] PGSQL database size question

as how your client will access it, than on the limits of number of tables that can be created in one db. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Postgres development

on it) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] identify database process given client process

which is the info you are after - pgsql is the dbusername, postgres is the db they are connected to then the ip address and port they are connecting from. The idle at the end will be replaced with the query they are running. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http

Re: [GENERAL] How to cope with low disk space

erroneous recording. I am thinking that a cron job that will email/page/sms you when it hits 50% disk usage would be a better solution that would simply give you a heads up to find and fix the fault causing the excess usage. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz

Re: [GENERAL] Lets get the 8.3 Announcement on the front page of Digg

. After Berkeley dropped the Postgres project it was picked it up by a few developers and grew into PostgreSQL as you know it today. http://www.postgresql.org/docs/8.3/interactive/history.html http://en.wikipedia.org/wiki/Michael_Stonebraker -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get

Re: [GENERAL] [OT] advanced database design (long)

in the last 2) Maybe sub-times can be a second table. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [GENERAL] [OT] advanced database design (long)

it refers to. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] [OT] advanced database design (long)

pg_class and pg_attribute -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's

Re: [GENERAL] Very long execution time of select nextval('..');

some more info in the log log_line_prefix - %t will show the timestamp of the log entry log_statement - can record the queries to the log so you can see just what is being run as you go through the log. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz

Re: [GENERAL] PostgreSQL/PHP Application Server

://code.google.com/p/sepgsql/ -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] out of memory with INSERT INTO... SELECT...

-darwin8.10.0, compiled by GCC powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5367) (1 row) Mac OSX 10.4.11 G4 dual 1.25G 2GB RAM -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast

Re: [GENERAL] Importing PostgreSQL data from another database

/xfers are possible, but that requires copying the entire cluster directory. If all you want is a specific tablespace, then pg_dump is your friend. Lesson to take from this: NEVER delete the original without validating the backup. Erik Jones -- Shane Ambler pgSQL (at) Sheeky (dot) Biz

Re: [GENERAL] 8.3 Beta Incompatible Data Disaster

://projects.commandprompt.com/public/pgsql/repo beta1 Sincerely, Joshua D. Drake -- Mark Walker Was it beta2 that changed the structure or beta3? Anyway worst case I still have a beta1 source tarball here if you need it. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz

Re: [GENERAL] PhpBB 3.x query review

rows to phpbb_banlist, analyse then explain the query again and see if it goes to the index then. If you wanted to experiment enough you should be able to find a sweet spot of x rows where it will change between index and seq scans. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky

Re: [GENERAL] Hinting the planner

/interactive/maintenance.html can explain these tasks in more detail. If this is insufficient then you can also look at your config file. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 4

[TLM] Re: [GENERAL] Postgres from PHP in Leopard

/php/ has been a good source of pre-built php for osx which also provides a larger feature set compiled into php. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 3: Have you checked our

Re: [GENERAL] Postgres from PHP in Leopard

/php/ has been a good source of pre-built php for osx which also provides a larger feature set compiled into php. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 3: Have you checked our

Re: [GENERAL] thank you

that's a joy to work with. /Kevin (Although not the same Kevin as above) /me takes note of all the Kevins that are handing out hugs... :) Yup .. I'll dish out a dose o' them too.. ;-) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end

Re: [GENERAL] slony error --need help

conninfo for node 134701624 The same works fine between postgresql versions 8.1.10 and 8.2.5 . Why do I get this error when replicating between versions 7.4 and8.1. Does slony1 replicate between these 2 versions? If so is there any other settings that needs to be done? -- Shane Ambler pgSQL

Re: [GENERAL] PostgreSQL Beta4 released

. This should be: You must be a Jedi Master as well because I can't see the source. (at least not the tarballs) ;-) -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet

Re: [GENERAL] 1 cluster on several servers

), because: How would the query know on which server to put it's data? And i guess i would need some Kerberos-like implementation for my authentication and authorization... cheers, WBL On Nov 29, 2007 1:23 PM, Shane Ambler [EMAIL PROTECTED] wrote: Willy-Bas Loos wrote: Hi, Is it possible

Re: [GENERAL] Postgres High Availablity Solution needed for hot-standby and load balancing

. The project home is now at http://www.pgcluster.org (but they seem to use pgfoundry to store the release tarballs) Also Cybertec appears to have branched off from pgcluster http://www.postgresql.at/english/pr_cybercluster_e.html -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http

Re: [GENERAL] 60 Seconds to connected to Postgresql using ODBC or PGAdmin

problem? If there is no entry (or an incorrect one) in /etc/hosts for localhost - then yes - try to connect to 127.0.0.1 and see if that makes a difference. Also if it is set to do namelookup before referring to /etc/hosts it can have similar probs. -- Shane Ambler [EMAIL PROTECTED] Get

Re: [GENERAL] 1 cluster on several servers

to achieve. Some of the projects that add these features are mentioned. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] Need help with complicated SQL statement

that takes an id argument (and can usefully invoke it on any stock_id in the database), but the problem remains as to how to construct a record set by applying the procedure to each id in a set of ids returned, e.g., by SELECT stock_id FROM stocks; Ted -- Shane Ambler [EMAIL PROTECTED] Get Sheeky

Re: [GENERAL] Compressed Backup too big

can change the settings if you wish. This is most likely the reason for your lack of compression - the data in the toast tables is most likely already compressed data so will be close to a 1-1 export size. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz

Re: [GENERAL] Need help with complicated SQL statement

stock_price_history WHERE stock_id IN (SELECT stock_id FROM sometable WHERE ) Which gives you the range of stock_id's from a table that you asked about. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6

Re: [GENERAL] Need help with complicated SQL statement

Shane Ambler wrote: I INSERTed 500 stocks entries and 10,000 stockprices entries for each stock (that's 5,000,000 price rows), then from EXPLAIN ANALYSE SELECT * FROM stock_price_history WHERE stock_id = 20 I got - Total runtime: 981.618 ms EXPLAIN ANALYSE SELECT * FROM stock_price_history

Re: [GENERAL] Need help with complicated SQL statement

... -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] convert access sql to postgresql

from the member table then you will need to repeat the calculations instead of referring to the alias. And if this is the case how does the insert fit with the issue of the select? -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast

Re: [GENERAL] Populating large DB from Perl script

and functions that it uses. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Selecting tree data

the created_at in the sorting as the id will give the same effect by itself. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs

Re: [GENERAL] How to transfer from place to plase without backup/restore

even if it is sent straight from one to another. For more help specify what hardware, system and postgres version you have on each machine and what you wish to achieve in transferring. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end

Re: [GENERAL] Problem of installation on Mac

selects on mydb1. Within postgresql these user accounts are referred to as roles - see the manual on CREATE ROLE for more info. http://www.postgresql.org/docs/8.2/interactive/sql-createrole.html -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end

Re: [GENERAL] Problem of installation on Mac

to the data files then other users have trouble getting a copy of them. If you run ps aux (or activity monitor) you will see a few different user names listed for different services. Shane Ambler [EMAIL PROTECTED] 10/18/2007 01:27 PM To [EMAIL PROTECTED] cc pgsql-general@postgresql.org Subject

Re: [GENERAL] Problem of installation on Mac

or are you building from source? -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] One database vs. hundreds?

, and how much work it will be if you do change your mind. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

most of these terms. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] Blobs in Postgresql

for your needs. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] Modeling bill/ship addresses

the address as being correct at which stage it is immutable? -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Retrieve the record ID

_ Watch all 9 Live Earth concerts live on MSN. http://liveearth.uk.msn.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Shane Ambler

Re: [GENERAL] basic postgres questions...

---+-+-- postgres | pgadmin | UTF8 template0 | pgadmin | UTF8 template1 | pgadmin | UTF8 wiki | pgadmin | UTF8 (4 rows) Then DROP DATABASE dbname; to delete it data and all. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast

Re: [GENERAL] dollar-quoting trouble

then you probably want to make sure that your shell $PATH setting includes the path to the newer version of psql and then specify the full path to the older version of psql when you want to use the older version. Or just use the full path every time you run psql. -- Shane Ambler [EMAIL PROTECTED

Re: [GENERAL] oracle to postgresql conversion

datatypes do not match -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] which is more scalable for the database?

. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] security permissions for functions

then you revoke public access when you create it and allow access to the one or more roles you want to allow access. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: explain analyze is your friend

  1   2   >