Re: [GENERAL] Server installation problem using freebsd ports

On Tue, Sep 9, 2008 at 9:21 AM, Mohd Fahadullah <[EMAIL PROTECTED]> wrote: > Hi, > > This might be a very small problem but I am stuck. When I try to install > postgresql server 8.3.3 on freebsd using ports, I am getting - > "postgresql-server-8.3.3 cannot install: unknown PostgreSQL version: 83"

Re: [GENERAL] How to upload data to postgres

Markova, Nina wrote: Hi again, I need to load data from Ingres database to Postgres database. What's the easiest way? Thanks, Nina Easiest way would be to export to CSV and import using COPY. Slickest way would be to use something like dblink. -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] psql scripting tutorials

Artacus wrote: I'd like to learn a little more about writing psql scripts does anyone know of any resources outside of the manual? Ok then. Does anyone have any tips or best practices for scripting psql? I'll probably write some bash scripts to pull csv files over then script psql to do a

Re: [GENERAL] PostgreSQL process architecture question.

On Tue, Sep 9, 2008 at 11:17 PM, 小波 顾 <[EMAIL PROTECTED]> wrote: > That's it, we have 4 CPUs, each of which has 4 cores, that is we have 16 > cores in total, but we have only 4 to 8 concurrent users, who regularly run > complex queries. That is we can't use all our CPU resources in such a > situat

Re: [GENERAL] PostgreSQL process architecture question.

That's it, we have 4 CPUs, each of which has 4 cores, that is we have 16 cores in total, but we have only 4 to 8 concurrent users, who regularly run complex queries. That is we can't use all our CPU resources in such a situation to speed up response time. > To: pgsql-general@postgresql.org> Fr

Re: [GENERAL] remove indexes on a column?

Vance Maverick <[EMAIL PROTECTED]> writes: > Perfect! Looks like I can get the names of the existing indexes by > doing > SELECT dep.relname > FROM pg_attribute col, pg_class tab, pg_depend pd, pg_class dep > WHERE tab.relname = 'mytable' > AND col.attname = 'mycolumn' > AND col.attrelid

Re: [GENERAL] remove indexes on a column?

Perfect! Looks like I can get the names of the existing indexes by doing SELECT dep.relname FROM pg_attribute col, pg_class tab, pg_depend pd, pg_class dep WHERE tab.relname = 'mytable' AND col.attname = 'mycolumn' AND col.attrelid = tab.oid AND pd.refobjid = tab.oid AND pd.refobjsub

[GENERAL] PgUS Memberships and Board Nominations Now Open

Greetings! A couple of related announcements: - You can now use the following URL to become a member of the United States PostgreSQL Association (PgUS): https://www.postgresql.us/join Note the special combo rate for PgUS professional membership and PostgreSQL Conference West (October 10-12) re

Re: [GENERAL] remove indexes on a column?

"Vance Maverick" <[EMAIL PROTECTED]> writes: > I'd like to write a SQL script, possibly with some PL/pgSQL, that can > find all indexes on a column -- so I can remove them, and set up > exactly the indexes I want. Yeah, this seems a bit tricky if you have expression indexes involving the column.

[GENERAL] remove indexes on a column?

I'd like to write a SQL script, possibly with some PL/pgSQL, that can find all indexes on a column -- so I can remove them, and set up exactly the indexes I want. (I know what indexes are *supposed* to be there, but depending on the migration history of the specific instance, the names may vary

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

On Mon, September 8, 2008 9:38 am, Randal T. Rioux wrote: > On Mon, September 8, 2008 12:06 am, Tom Lane wrote: >> "Randal T. Rioux" <[EMAIL PROTECTED]> writes: >>> bash-3.00# ldd /usr/local/ssl/lib/libssl.so >> ... >>> libgcc_s.so.1 => (file not found) >> >> Smoke, meet gun ... >> >>> Now

Re: [GENERAL] FW: How to upload data to postgres

On Tuesday 09 September 2008 1:54:12 pm Markova, Nina wrote: > So far I tried; > > 1) I have copied data from Ingres in ASCII (using Ingres copydb > command). > 2) created a table in a Postgres database > 3) tried loading data into Potgres table - encounter problems. > > For 1) (the Ingres part

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

On Tue, September 9, 2008 5:25 am, Zdenek Kotala wrote: > Randal T. Rioux napsal(a): >> I've battled this for a while. I'm finally breaking down and asking for >> help. >> >> If you're answer to this is "why 64-bit" then don't answer. You wouldn't >> understand. Same if you say "why don't you use p

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 9, 2008 at 3:37 PM, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Wed, Sep 10, 2008 at 07:16:35AM +1200, Brent Wood wrote: >> Given the general increase in typical hardware specs these days, >> perhaps the default pg specs could be set for higher spec systems? > > Given the def

Re: [GENERAL] syntax error on: GET DIAGNOSTICS xcount = ROW_COUNT;

<[EMAIL PROTECTED]> writes: > I am getting an error on "GET DIAGNOSTICS " statement in a PL/SQL function > below. > CREATE OR REPLACE FUNCTION test(lid int, OUT nid int) AS $$ > DECLARE > road_row road%ROWTYPE; > BEGIN > SELECT * INTO road_row FROM road WHERE link_id=lid; > GET DIAGNOSTICS

[GENERAL] syntax error on: GET DIAGNOSTICS xcount = ROW_COUNT;

Hi All, I am getting an error on "GET DIAGNOSTICS " statement in a PL/SQL function below. CREATE OR REPLACE FUNCTION test(lid int, OUT nid int) AS $$ DECLARE road_row road%ROWTYPE; BEGIN SELECT * INTO road_row FROM road WHERE link_id=lid; GET DIAGNOSTICS xcount = ROW_COUNT; IF xcount = 0

[GENERAL] OSX build of PostgreSQL 8.3.3 with macports

For the record, I've found the following "kitchen sink options" will build and install on OS X 10.5 with macports. sudo -i port install gmake port install gawk port install flex port install bison +yacc port install openldap port install openssl port install libxml port install libxml2 port insta

Re: [GENERAL] Can interval take a value from a field?

On Tue, 2008-09-09 at 17:03 -0600, Jeff Ross wrote: > select > ts_date as "Transcript Date", > ts_expiration_date as "Current Expiration Date", > expiration_value as "Expiration Interval" > from transcript, training_expiration_value where > ts_training_i

Re: [GENERAL] Automated Backup On Windows

Please use subsections to separate both methods. How about adding the page to the Windows category? I just fixed both those. Justin, you might want to look at how I reformatted that to get an idea what the usual style is like. Also, people who write whole articles or large sections are som

[GENERAL] Can interval take a value from a field?

Sometimes I think the hurdle to learning more advanced sql is figuring out how to phrase the search question. Well, I'm not having any luck there so here I come again to the list, hat in hand :-) I have a table with an id key and an expiration value in years trgexpd_trg_id | expiration_valu

Re: [GENERAL] PostgreSQL TPC-H test result?

Greg Smith wrote: On Tue, 9 Sep 2008, Amber wrote: I read something from http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html saying that PostgreSQL can't give the correct result of the some TPC-H queries Jignesh Shah at Sun ran into that same problem. It's mentioned bri

Re: [GENERAL] Automated Backup On Windows

On Tue, 9 Sep 2008, Alvaro Herrera wrote: Please use subsections to separate both methods. How about adding the page to the Windows category? I just fixed both those. Justin, you might want to look at how I reformatted that to get an idea what the usual style is like. Also, people who writ

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, 9 Sep 2008, Amber wrote: I read something from http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html saying that PostgreSQL can't give the correct result of the some TPC-H queries Jignesh Shah at Sun ran into that same problem. It's mentioned briefly in his presentat

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 2:03 PM, Darren Weber <[EMAIL PROTECTED]> wrote: > On Tue, Sep 9, 2008 at 1:31 PM, Dave Page <[EMAIL PROTECTED]> wrote: >> On Tue, Sep 9, 2008 at 9:14 PM, Darren Weber >> <[EMAIL PROTECTED]> wrote: >> >>> Yeah, I also found that fink conflicts with macports. I do like the >>

Re: [GENERAL] LEFT JOIN issue

Just got an email saying that this has been fixed in 8.3.4, so I suppose I'll watch and wait for that. Thanks for looking, Alan (and anyone else who was watching this...) Dave On Tue, Sep 9, 2008 at 4:57 PM, Alan Hodgson <[EMAIL PROTECTED]> wrote: > On Tuesday 09 September 2008, "David Jaquay"

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 1:31 PM, Dave Page <[EMAIL PROTECTED]> wrote: > On Tue, Sep 9, 2008 at 9:14 PM, Darren Weber > <[EMAIL PROTECTED]> wrote: > >> Yeah, I also found that fink conflicts with macports. I do like the >> idea of using the Debian repository and package management system. >> For som

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 9, 2008 at 2:07 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > > . . . your figuring here is indeed simplistic. Every day I see > requests for help from people who have followed the rule of thumb "1/4 > of memory for shared_buffers", except that they're also running > apache+jakarta,

Re: [GENERAL] LEFT JOIN issue

On Tuesday 09 September 2008, "David Jaquay" <[EMAIL PROTECTED]> wrote: > I'm seeing a problem with a LEFT JOIN in 8.3.3, running on what I > believe to be an Ubuntu Heron server. The sql below demonstrates the > issue. explain doesn't execute the query. Show the output of the actual select - it

[GENERAL] FW: How to upload data to postgres

So far I tried; 1) I have copied data from Ingres in ASCII (using Ingres copydb command). 2) created a table in a Postgres database 3) tried loading data into Potgres table - encounter problems. For 1) (the Ingres part) = Ingres used the following copy commands: copy s

[GENERAL] Server installation problem using freebsd ports

Hi, This might be a very small problem but I am stuck. When I try to install postgresql server 8.3.3 on freebsd using ports, I am getting - "postgresql-server-8.3.3 cannot install: unknown PostgreSQL version: 83" There was no issue with client. This has something to do with pgsql_ver. What's wron

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 4:14 PM, Darren Weber <[EMAIL PROTECTED]> wrote: > Yeah, I also found that fink conflicts with macports. I do like the > idea of using the Debian repository and package management system. > For some reason, which escapes me now, I went with macports (maybe it > was just tha

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 3:48 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Uh, it's not apparent to me why dropping stuff into /Library is any > better than dropping it into /usr/lib? Because /Library is the Apple framework equivalent of /usr/local in unix-world. Whereas /usr/lib should not really be

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 9:14 PM, Darren Weber <[EMAIL PROTECTED]> wrote: > Yeah, I also found that fink conflicts with macports. I do like the > idea of using the Debian repository and package management system. > For some reason, which escapes me now, I went with macports (maybe it > was just tha

[GENERAL] LEFT JOIN issue

I'm seeing a problem with a LEFT JOIN in 8.3.3, running on what I believe to be an Ubuntu Heron server. The sql below demonstrates the issue. What I expect to see is no rows in the output, i.e. the LEFT JOIN should pair the two rows together, and the WHERE clause should decide that the joined row

Re: [GENERAL] PostgreSQL TPC-H test result?

Robert Treat <[EMAIL PROTECTED]> writes: > http://www.it.iitb.ac.in/~chetanv/personal/acads/db/report_html/node10.html. > It isn't terribly informative, but it doesindicate one thing, someone else > was able to run query #6 correctly, while the above site claims it returns an > error. Now when I

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 11:55 AM, Benjamin Reed <[EMAIL PROTECTED]> wrote: > On Tue, Sep 9, 2008 at 2:46 PM, Dave Page <[EMAIL PROTECTED]> wrote: > >>> For one thing, I've discovered that setting DYLD_LIBRARY_PATH is not a >>> great idea on OS X. For one, if you set it in your shell login >>> profi

Re: [GENERAL] PostgreSQL TPC-H test result?

On Wed, Sep 10, 2008 at 07:16:35AM +1200, Brent Wood wrote: > Pg does itself no favours by sticking with such pessimistic > defaults, and a novice user wanting to try it out will find tweaking > the pg configuration files for performance quite complicated. You do know that at install time, Pg does

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On Tue, Sep 9, 2008 at 8:50 AM, Frederik Ramm >> I hope you can help me with a problem I'm having - I'm stuck and don't >> know how to debug this further. > You definitely are suffering from db corruption, and given the number > and differing type of e

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

"Benjamin Reed" <[EMAIL PROTECTED]> writes: > On Tue, Sep 9, 2008 at 3:46 AM, Dave Page <[EMAIL PROTECTED]> wrote: >> I'll look at a solution for the installer - it'll probably have to be >> the symlink unless anyone else has a better idea... > Another option would be to create them as actual fram

Re: [GENERAL] PostgreSQL TPC-H test result?

On Wed, Sep 10, 2008 at 07:16:35AM +1200, Brent Wood wrote: > Given the general increase in typical hardware specs these days, > perhaps the default pg specs could be set for higher spec systems? Given the default shmem configuration on operating systems these days, upping the default will likely

Re: [GENERAL] PostgreSQL TPC-H test result?

My 02c, Pg does itself no favours by sticking with such pessimistic defaults, and a novice user wanting to try it out will find tweaking the pg configuration files for performance quite complicated. Given the general increase in typical hardware specs these days, perhaps the default pg specs c

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 2:46 PM, Dave Page <[EMAIL PROTECTED]> wrote: >> For one thing, I've discovered that setting DYLD_LIBRARY_PATH is not a >> great idea on OS X. For one, if you set it in your shell login >> profiles (.bashrc, .profile, .cshrc or whatever), most applications >> that are start

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

Then there would seem to be another problem with the checkinstall script and non-global zones (although this was tested). I'll look into it, but I need to reproduce it. Can you tell me exactly what you've done so far (commands that you used to create the non-global zone, commands you're using

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 6:35 PM, Darren Weber <[EMAIL PROTECTED]> wrote: > I guess the symlinks from /usr/lib to /Library/PostgreSQL/lib would > have to happen for many items (and sub-directories). No, just one link to libpq.5.dylib. There's nothing else in there you'd should need to link with, ex

[GENERAL] How to upload data to postgres

Hi again, I need to load data from Ingres database to Postgres database. What's the easiest way? Thanks, Nina

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

On Tue, Sep 09, 2008 at 04:50:53PM +0200, Frederik Ramm wrote: > I have a rather large nightly process that imports a lot of data from > the OpenStreetMap project into a PostGIS database, then proceeds doing > all sorts of things - creating spatial indexes, computing bounding > boxes, doing simp

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 12:46 AM, Dave Page <[EMAIL PROTECTED]> wrote: > On Tue, Sep 9, 2008 at 2:02 AM, Darren Weber > <[EMAIL PROTECTED]> wrote: >> I'm new to using PostgreSQL on mac OS X. I used a binary installer >> for PostgreSQL 8.3 on mac OS X 10.5, which installs into >> >> /Library/Postgre

Re: [GENERAL] PostgreSQL process architecture question.

On Tue, 09 Sep 2008 10:07:32 -0600, Scott Marlowe wrote: > On Tue, Sep 9, 2008 at 9:35 AM, Amber <[EMAIL PROTECTED]> wrote: >> We know PostgreSQL uses one dedicated server process to serve one client >> connection, what we want to know is whether PostgreSQL use multiple threads >> inside agents pr

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tuesday 09 September 2008 10:06:01 Amber wrote: > From: "Andrew Sullivan" <[EMAIL PROTECTED]> > Sent: Tuesday, September 09, 2008 8:39 PM > To: > Subject: Re: [GENERAL] PostgreSQL TPC-H test result? > > > On Tue, Sep 09, 2008 at 07:59:49PM +0800, Amber wrote: > >> I read something from > >> htt

Re: [GENERAL] Automated Backup On Windows

On Tue, Sep 9, 2008 at 2:12 PM, justin <[EMAIL PROTECTED]> wrote: > how does this page look to you guys/gals. I have never added anything to a > WIKI before so any comments?? I left the original author stuff untouched my > edit is appended to the top > Looks tidy enough to me :-). PgAdmin should

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

Also, I'd try running a large, long running pgbench test to see if you get any errors. If such a simple schema / operation in large scale gets errors it's almost certainly a hardware failure. Have you had power removed while the system was running? With a lot of direct attached SATA drives you c

Re: [GENERAL] PostgreSQL process architecture question.

On Tue, Sep 09, 2008 at 11:35:56PM +0800, Amber wrote: > We know PostgreSQL uses one dedicated server process to serve one client connection, what we want to know is whether PostgreSQL use multiple threads inside agents processes to take advantage of multiple CPUs. No. Note that "threading" is n

Re: [GENERAL] PostgreSQL process architecture question.

On Tue, Sep 9, 2008 at 9:35 AM, Amber <[EMAIL PROTECTED]> wrote: > We know PostgreSQL uses one dedicated server process to serve one client > connection, what we want to know is whether PostgreSQL use multiple threads > inside agents processes to take advantage of multiple CPUs. In our site we > ha

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

On Tue, Sep 9, 2008 at 8:50 AM, Frederik Ramm <[EMAIL PROTECTED]> wrote: > Dear PostgreSQL community, > > I hope you can help me with a problem I'm having - I'm stuck and don't > know how to debug this further. > > I have a rather large nightly process that imports a lot of data from the > OpenSt

Re: [GENERAL] 3 postgres processes

--- On Tue, 9/9/08, Markova, Nina <[EMAIL PROTECTED]> wrote: > From: Markova, Nina <[EMAIL PROTECTED]> > Subject: [GENERAL] 3 postgres processes > To: pgsql-general@postgresql.org > Date: Tuesday, September 9, 2008, 2:50 PM > Hi, > > After issuning initdb and starting the postgres server, I > che

Re: [GENERAL] Install Postgres on a SAN volume?

On Tuesday 09 September 2008 04:37:09 Magnus Hagander wrote: > Greg Smith wrote: > > On Tue, 9 Sep 2008, Magnus Hagander wrote: > >> As long as your SAN guarantees an atomic snapshot of all your data > >> (which every SAN I've ever heard of guarantees if you're on a single > >> volume - entry level

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 09, 2008 at 10:06:01PM +0800, Amber wrote: > Yes, we don't care about the performance results, but we do care about the > point that PostgreSQL can't give the correct results of TPC-H queries. > I have never heard a reputable source claim this. I have grave doubts about their claim:

[GENERAL] PostgreSQL process architecture question.

We know PostgreSQL uses one dedicated server process to serve one client connection, what we want to know is whether PostgreSQL use multiple threads inside agents processes to take advantage of multiple CPUs. In our site we have only a few concurrent connections, so what occurs inside agent proc

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 9, 2008 at 10:06 AM, Amber <[EMAIL PROTECTED]> wrote: > Yes, we don't care about the performance results, but we do care about the > point that PostgreSQL can't give the correct results of TPC-H queries. PostgreSQL, at least in terms of the open source databases, is probably your best

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 9, 2008 at 7:06 AM, Amber <[EMAIL PROTECTED]> wrote: > Yes, we don't care about the performance results, but we do care about the > point that PostgreSQL can't give the correct results of TPC-H queries. It would be nice to know about the data, queries, and the expected results of thei

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

Hi, Joshua D. Drake wrote: Hard drives. You said you replaced the machines and ran cpu burn etc... You didn't say you checked the hard drives (or replaced them). The new machine has new hard drives. On the old machine I had a hardware RAID5 array made up of 6x500 GB SATA with an Areca RAID co

Re: [GENERAL] Automated Backup On Windows

justin wrote: > how does this page look to you guys/gals. I have never added anything > to a WIKI before so any comments?? I left the original author stuff > untouched my edit is appended to the top Please use subsections to separate both methods. Also it'd be good to mention that PGPASSWORD

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

Frederik Ramm wrote: Dear PostgreSQL community, Every other night, the process aborts with some strange error message, and never at the same position: ERROR: invalid page header in block 166406 of relation "node_tags" ERROR: could not open segment 2 of relation 1663/24253056/24253895 (ta

[GENERAL] Various intermittent bugs/instability - how to debug?

Dear PostgreSQL community, I hope you can help me with a problem I'm having - I'm stuck and don't know how to debug this further. I have a rather large nightly process that imports a lot of data from the OpenStreetMap project into a PostGIS database, then proceeds doing all sorts of thing

[GENERAL] Question about indexes

Hi all. I usually create indexes accordingly to the queries used in my software. This means the more often than not I have composited indexes over more than one column. What'd be in PGSQL (v8.3+) the pros and cons of having instead only one-column indexes? Thanks in advance. RMP.

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

bug_id 6546052 is already fixed in the PostgreSQL 8.2 packages on the Solaris S10 update 4 DVD. The "Fixed in Build: s10u4_07" reference in the bug means that it was fixed in build 7 of S10u4, which is prior to general release. If the bug was fixed after release of S10u4 (and could therefore af

[GENERAL] 3 postgres processes

Hi, After issuning initdb and starting the postgres server, I checked for processes running, expecting to see just one: postgres 4926 4924 0 14:44:52 ? 0:00 /usr/postgres/8.2/bin/postgres postgres 4924 1 0 14:44:52 pts/1 0:00 /usr/postgres/8.2/bin/postgres postgres

[GENERAL] Problem starting PostgreSQL in Windows 2003

Hi, After successfully installing PostgreSQL 8.3.3-1 on Windows 2003, the service won't start. The error I see in the Windows Event Viewer is "could not open process token: error code 5". Any help is appreciated. Thanks, Moshe. The information contained in this message is proprie

Re: [GENERAL] PostgreSQL TPC-H test result?

Yes, we don't care about the performance results, but we do care about the point that PostgreSQL can't give the correct results of TPC-H queries. -- From: "Andrew Sullivan" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2008 8:39 PM To: Subject:

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

Thanks all. I have the /usr/lib/libkrb5.so.1 but somehow the checkinstall script can't find it (it is s10u4). As a result in the non-global zone these and are missing, they exist in the global zone though. Nina -Original Message- From: James Gates [mailto:[EMAIL PROTECTED] Sent: Sep

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 2:23 PM, Benjamin Reed <[EMAIL PROTECTED]> wrote: > On Tue, Sep 9, 2008 at 3:46 AM, Dave Page <[EMAIL PROTECTED]> wrote: > >> I'll look at a solution for the installer - it'll probably have to be >> the symlink unless anyone else has a better idea... > > Another option would

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 3:46 AM, Dave Page <[EMAIL PROTECTED]> wrote: > I'll look at a solution for the installer - it'll probably have to be > the symlink unless anyone else has a better idea... Another option would be to create them as actual frameworks; instead of libpq you'd have /Library/Fram

Re: [GENERAL] Automated Backup On Windows

sorry forgot the link http://wiki.postgresql.org/wiki/Automated_Backup_on_Windows justin wrote: how does this page look to you guys/gals. I have never added anything to a WIKI before so any comments?? I left the original author stuff untouched my edit is appended to the top -- Sent via

Re: [GENERAL] Automated Backup On Windows

how does this page look to you guys/gals. I have never added anything to a WIKI before so any comments?? I left the original author stuff untouched my edit is appended to the top -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:/

Re: [GENERAL] Automated Backup On Windows

Dave Page wrote: On Tue, Sep 9, 2008 at 1:32 PM, justin <[EMAIL PROTECTED]> wrote: Greg Smith wrote: On Mon, 8 Sep 2008, justin wrote: I would have added it to the postgresqldocs.org webstie but can't create an account for my self.Tried following theses instructions

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 09, 2008 at 07:59:49PM +0800, Amber wrote: > I read something from > http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html Given that the point of that "study" is to prove something about performance, one should be leery of any claims based on an "out of the box" compar

Re: [GENERAL] Automated Backup On Windows

On Tue, Sep 9, 2008 at 1:32 PM, justin <[EMAIL PROTECTED]> wrote: > > > Greg Smith wrote: >> >> On Mon, 8 Sep 2008, justin wrote: >> >>> I would have added it to the postgresqldocs.org webstie but can't create >>> an account for my self.Tried following theses instructions >>>

Re: [GENERAL] Automated Backup On Windows

Greg Smith wrote: On Mon, 8 Sep 2008, justin wrote: I would have added it to the postgresqldocs.org webstie but can't create an account for my self.Tried following theses instructions but never could get it to work That

[GENERAL] PostgreSQL TPC-H test result?

I read something from http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html saying that PostgreSQL can't give the correct result of the some TPC-H queries, I wonder is there any official statements about this, because it will affect our plane of using PostgreSQL as an alternative

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

Markova, Nina napsal(a): Hi, I am working on installing postgres ina zone - zoneadm install command finished with errors : Error: /usr/lib/libkrb5.so.1 not found. Please install the patch for 6381288 (we should expose the krb5 api). The patch needed is 125077-02 for SPARC and 125078-02 for x8

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

Randal T. Rioux napsal(a): I've battled this for a while. I'm finally breaking down and asking for help. If you're answer to this is "why 64-bit" then don't answer. You wouldn't understand. Same if you say "why don't you use packages." Here is my scenerio: - Sun 420R x450Mhz UltraSPARC-II / 4

Re: [GENERAL] Very weird problem of "order by" in postgresql

On Tue, Sep 09, 2008 at 09:04:02AM +0800, Peter Cai wrote: > Oh, you are right! Although the 'locale' command show that the 2 has the > same locale settings. > The sort result of the same file is different. > Ubuntu is right, centos is wrong?? Note that glibc uses the information in /usr/shar

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

Tom Lane napsal(a): I'm not a Solaris user I can sent you a installation media ;-), if you want. , but I'd be kinda surprised if Solaris' own libraries were built with gcc --- Sun has their own compiler no? Yes, sun studio. It is not installed by default, but it is possible to download i

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

On Sat, 6 Sep 2008, Randal T. Rioux wrote: On Sat, September 6, 2008 8:21 pm, Tom Lane wrote: I'm not a Solaris user, but I'd be kinda surprised if Solaris' own libraries were built with gcc --- Sun has their own compiler no? They released the instructions for how they were building their of

Re: [GENERAL] Postgres in a solaris zone - patch 125077-02 needed

On Mon, 8 Sep 2008, Markova, Nina wrote: I wasn't able to find 125077-02 patch for SPARC, and contacted SUN last week - they are very slow. It wasn't released; according to http://www.mail-archive.com/[EMAIL PROTECTED]/msg00199.html that fix made its way into 120011-09 instead. I'm not so

Re: [GENERAL] Install Postgres on a SAN volume?

Greg Smith wrote: > On Tue, 9 Sep 2008, Magnus Hagander wrote: > >> As long as your SAN guarantees an atomic snapshot of all your data >> (which every SAN I've ever heard of guarantees if you're on a single >> volume - entry level SANs often don't have the functionality to do >> multi-volume atomi

Re: [GENERAL] 8.3 on FreeBSD 6.3, sudden performance degradations

On Mon, 8 Sep 2008, Ivan Zolotukhin wrote: Yep, update_process_title = off if it is important. Have you considered turning it on so you can see what processes are most involved in the spike? Normally in your situation I'd try to capture what the output from top was during the problem period

Re: [GENERAL] Install Postgres on a SAN volume?

On Tue, 9 Sep 2008, Magnus Hagander wrote: As long as your SAN guarantees an atomic snapshot of all your data (which every SAN I've ever heard of guarantees if you're on a single volume - entry level SANs often don't have the functionality to do multi-volume atomic snapshots, though), you don'

Re: [GENERAL] Install Postgres on a SAN volume?

Greg Smith wrote: > On Mon, 8 Sep 2008, William Garrison wrote: > >> 2) We could install PostgreSQL onto the C: drive and then configure >> the data folder to be on the SAN volume (Z:) > > Do that. You really don't want to get into the situation where you > can't run anything related to the Post

Re: [GENERAL] 8.3 on FreeBSD 6.3, sudden performance degradations

On 2008-09-09 09:30, Tomasz Ostrowski wrote: > On 2008-09-08 11:46, Ivan Zolotukhin wrote: > >> vmstat 5 >> procs memory page disk faults cpu >> r b w avmfre flt re pi po fr sr am0 insycs us sy >> id >> 28 77 0 2328792 793424 3481

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

On Tue, Sep 9, 2008 at 2:02 AM, Darren Weber <[EMAIL PROTECTED]> wrote: > I'm new to using PostgreSQL on mac OS X. I used a binary installer > for PostgreSQL 8.3 on mac OS X 10.5, which installs into > > /Library/PostgreSQL/[version]/ > > I'm building a lot of software that links to libpq and

Re: [GENERAL] 8.3 on FreeBSD 6.3, sudden performance degradations

On 2008-09-08 11:46, Ivan Zolotukhin wrote: > vmstat 5 > procs memory page disk faults cpu > r b w avmfre flt re pi po fr sr am0 insycs us sy > id > 28 77 0 2328792 793424 34813 0 0 0 4351 0 41 1913 21230 20337 14 86 > 0

Re: [GENERAL] weird query runtime results...

On 2008-09-09 05:07, Kashmir wrote: > querying data from august 1st - august 25: > Total runtime: 26762.999 ms > > now querying data from august 1st - august 29: > Total runtime: 20123.584 ms > > Any idea why these analysises look so different? the only > query-difference is the 2nd timestamp