Re: [GENERAL] Error while compiling on HP-UX ia64
Hi,
After a new install of HP-UX B.11.23 (ia64) and installing the latest patches
on it, I've tried to compile PostgreSQL 9.0.1 from source again.
But I've still got problems with compiling, the process is ending with the next
errors:
gmake[3]: Entering directory
`/anva/PostgreSQL/pgsqlsource/postgresql-9.0.1/src/backend/libpq'
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
-I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/include
-I/usr/local/include -c -o be-fsstubs.o be-fsstubs.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
-I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/include
-I/usr/local/include -c -o be-secure.o be-secure.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
-I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/include
-I/usr/local/include -c -o auth.o auth.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
-I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/include
-I/usr/local/include -c -o crypt.o crypt.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
-I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/include
-I/usr/local/include -c -o hba.o hba.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
-I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/include
-I/usr/local/include -c -o ip.o ip.c
ip.c: In function 'pg_foreach_ifaddr':
ip.c:654: error: storage size of 'lifc' isn't known
ip.c:725: error: 'struct lifreq' has no member named 'lifr_addr'
ip.c:735: error: 'struct lifreq' has no member named 'lifr_addr'
ip.c:654: warning: unused variable 'lifc'
gmake[3]: *** [ip.o] Error 1
gmake[3]: Leaving directory
`/anva/PostgreSQL/pgsqlsource/postgresql-9.0.1/src/backend/libpq'
gmake[2]: *** [libpq-recursive] Error 2
gmake[2]: Leaving directory
`/anva/PostgreSQL/pgsqlsource/postgresql-9.0.1/src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/anva/PostgreSQL/pgsqlsource/postgresql-9.0.1/src'
gmake: *** [all] Error 2
SIOCGLIFCONF is declared in /usr/include/sys/ioctl.h
#define SIOCGLIFCONF_IOWR('I',20, struct if_laddrconf) /*get l_addr
list */
Struct lifreq is declared in /usr/include/net/if.h
/* Logical interface request */
struct lifreq {
int lifr_flags;
char lifr_target[IFNAMSIZ];
char lifr_source[IFNAMSIZ];
};
Mkheaders from the gcc tools is used to solve incompatibilities between the
HP-UX system header files and the gcc library.
But it doesn't affect this problem.
Does anybody knows how to solve this problem?
Regards, Derk Jan Horstman
***DISCLAIMER***
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan
en gebruik door anderen is niet toegestaan. ANVA bv sluit iedere
aansprakelijkheid uit die voortvloeit uit electronische verzending.
This e-mail is intended exclusively for the addressee(s), and may not be passed
on to, or made available for use by any person other than the addressee(s).
ANVA bv rules out any and every liability resulting from any electronic
transmission.
**
--
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] column-level update privs + lock table
On Thu, Oct 7, 2010 at 7:43 PM, Josh Kupershmidt schmi...@gmail.com wrote: I noticed that granting a user column-level update privileges doesn't allow that user to issue LOCK TABLE with any mode other than Access Share. Anyone think this could be added as a TODO? Josh -- 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] Error while compiling on HP-UX ia64
Derk Jan Horstman dj.horst...@anva.nl writes: After a new install of HP-UX B.11.23 (ia64) and installing the latest patches on it, I've tried to compile PostgreSQL 9.0.1 from source again. But I've still got problems with compiling, the process is ending with the next errors: ip.c: In function 'pg_foreach_ifaddr': ip.c:654: error: storage size of 'lifc' isn't known ip.c:725: error: 'struct lifreq' has no member named 'lifr_addr' ip.c:735: error: 'struct lifreq' has no member named 'lifr_addr' Hm. A bit of googling suggests that HPUX is randomly incompatible with the rest of the world concerning the output format of SIOCGLIFCONF (which is no great surprise). Unfortunately, it seems they've shut down www.testdrive.hp.com, which means there's no longer any easy access to HP systems on which one could test a fix. If you want this fixed, you're going to have to do it yourself, or find some other HPUX user who will fix it, or provide access to an HPUX system to somebody who wants to fix it. regards, tom lane -- 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] Error while compiling on HP-UX ia64
Derk Jan Horstman dj.horst...@anva.nl writes: After a new install of HP-UX B.11.23 (ia64) and installing the latest patches on it, I've tried to compile PostgreSQL 9.0.1 from source again. But I've still got problems with compiling, the process is ending with the next errors: ip.c: In function 'pg_foreach_ifaddr': ip.c:654: error: storage size of 'lifc' isn't known ip.c:725: error: 'struct lifreq' has no member named 'lifr_addr' ip.c:735: error: 'struct lifreq' has no member named 'lifr_addr' Hm. A bit of googling suggests that HPUX is randomly incompatible with the rest of the world concerning the output format of SIOCGLIFCONF (which is no great surprise). Unfortunately, it seems they've shut down www.testdrive.hp.com, which means there's no longer any easy access to HP systems on which one could test a fix. If you want this fixed, you're going to have to do it yourself, or find some other HPUX user who will fix it, or provide access to an HPUX system to somebody who wants to fix it. regards, tom lane Hi Guys, You can usually get pre-built versions of Postgres for HP-UX here: http://hpux.connect.org.uk/hppd/cgi-bin/search?package=ondescription=onterm=postgresSearch=Search Only 9.0 there at the moment, but they are usually not far behind the release date. Regards, Joe -- 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] LOG: unexpected EOF on client connection
On Fri, 8 Oct 2010 09:57:31 -0400, akp geek akpg...@gmail.com wrote: LOG: unexpected EOF on client connection Npgsql is a very potent EOF-Generator if the client app doesn't properly close (or dispose explicitly) connections. see http://fxjr.blogspot.com/2010/04/npgsql-connection-pool-explained.html Regards, Brar -- 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] Postgres won't start after setting ssl=on
On Sun, Oct 10, 2010 at 12:08:13AM -0700, Mike Christensen wrote: While I do appreciate the vote of confidence, rest assured you will never see a post from me that starts with So I've been hacking the pg code and... Actually, we get *plenty* of those. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- 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] What was new in 8.4 8.3?
On Thu, Oct 07, 2010 at 10:14:26AM -0400, Greg Smith wrote: Scott Ribe wrote: The what's new in 9.0 document on the wiki is great. Is there anything similar for 8.4 8.3 so on? I keep my list of links to interesting articles on the features in each version here: http://wiki.postgresql.org/wiki/Version_History Haven't updated that yet to include anything but the one big 9.0 article you were referring to so far. Should we have a 9.1 one? There's already been at least one large, new feature, namely INSTEAD OF triggers. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- 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] Regarding initdb pg_ctl
On windows 2003 make the postgres user Member of Power Users group and NOT Administrators. This should solve the above problem and the problem of installing postgreSQL on Windows 2003. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Regarding-initdb-pg-ctl-tp1924375p3208199.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] NoSQL -vs- SQL
Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. -Carlos -- 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] NoSQL -vs- SQL
On 10/11/2010 5:46 PM, Carlos Mennens wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. http://www.xtranormal.com/watch/6995033/ (warning: may not be sfw). -- 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] NoSQL -vs- SQL
On Mon, 11 Oct 2010, Carlos Mennens wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. Carlos, I stopped reading LJ several years ago, but that's a very interesting article ... for the first couple of pages. IMNSHO, there is no conflict between SQL/RDBMS and the various flavors of NoSQL. It's a case of horses for courses or vehicles for uses. You would probably not want to use a semi-tractor to run errands around town, yet it's ideal for hauling three large semi-trailers across the country on the Interstate Highway System. Similarly, you would not use a spreadsheet to store and retrieve massive amounts of data (well, most of us wouldn't) when a database is called for. And, despite what we see all too frequently when biological data (of the bugs and bunnies variety) are analyzed is the use of parametric statistics when the data are not parametrically distributed, but most folks do not know non-parametric equivalents and their Excel(R) spreadsheets don't have those formulae built in. It appears from the article that NoSQL in its various incarnations is well suited for some Web-based applications. For those applications it's better by measures considered important by the application owners than the SQL rdbms that have been used. It's not a case of one-size-solution-fits-all, but of developing a better tool for a specific application or class of applications. And that's my $2.00 worth. Rich -- 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] NoSQL -vs- SQL
Carlos Mennens wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. NoSQL is a brand name and the things it applies to are better called distributed databases. These things are complementary to ACID databases and focused on different tasks; one isn't a replacement for the other. Use an ACID database when you care more about absolute correctness in your data and will accept greater scalability challenges in exchange when one machine isn't enough for your workload. Use NoSQL when scalability is more important than correctness and your scalability need is greater than one machine can handle. Some people would say that NoSQL is a contrast with relational databases but I would say that in fact these things are orthogonal. You can in fact use the relational model of data over both an ACID database as over a NoSQL database, just as you can use a key-value store over both as well. Speaking for myself, my Muldis D object-relational database language is designed to work over both kinds of DBMSs, although it emphasizes the ACID model. -- Darren Duncan -- 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] NoSQL -vs- SQL
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Carlos Mennens Sent: Monday, October 11, 2010 4:47 PM To: pgsql-general@postgresql.org Subject: [GENERAL] NoSQL -vs- SQL Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. NoSQL is ideal for situations where we have a single table with no children. Consider something like FACEBOOK or the like, where there is a unique id for a single table, and there are jillions of records. We just want to find, insert, update or delete this entry and it has no parents or children. A simple key/store database is all that is needed. That is where the NoSQL model shines. -- 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] NoSQL -vs- SQL
On Mon, Oct 11, 2010 at 5:46 PM, Carlos Mennens carlos.menn...@gmail.com wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. Here's my opinion. Key-value store is NOT NEW. Calling it a new name (NoSQL) is kind of counter intuitive for me. I've used key-value stores since I wrote my first program in 1985. For things like session management they are great. The label NoSQL covers way to much to mean any one thing. It's new speak for management. If a key value store works use it. If a particular db /storage engine that happens to not rely on sql does something well, then reference THAT db / storage engine. SQL database engine can be arbitrary enough that no one just says we use SQL, at least not in an engineering department. memcached is a type of NoSQL db, and so are mongo, but they're optimized for fundamentally different behavior and usage patterns. When I talk about a particular SQL database, I name it. Seldom do I ever talk about the aggregate group that is SQL Databases. It's a large and poorly defined set. -- To understand recursion, one must first understand recursion. -- 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] NoSQL -vs- SQL
On 2010-10-11 05:57:37PM -0600, David Boreham wrote: On 10/11/2010 5:46 PM, Carlos Mennens wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. http://www.xtranormal.com/watch/6995033/ (warning: may not be sfw). Someone should (or probalby has) made one that sounds exactly the same, except for replacign the Mongo guy with MySQL and the MySQL guy with PostgreSQL. That might be more apopros all around ;) -- === Peter C. Lai | Bard College at Simon's Rock Systems Administrator| 84 Alford Rd. Information Technology Svcs. | Gt. Barrington, MA 01230 USA peter AT simons-rock.edu | (413) 528-7428 === -- 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] NoSQL -vs- SQL
On 10/11/2010 8:50 PM, Scott Marlowe wrote: On Mon, Oct 11, 2010 at 5:46 PM, Carlos Mennens carlos.menn...@gmail.com wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. Here's my opinion. Key-value store is NOT NEW. Calling it a new name (NoSQL) is kind of counter intuitive for me. I've used key-value stores since I wrote my first program in 1985. Yep! +1 I used nosql back in the dos days, using btrieve running on a novell server. Was pretty wicked fast... but... we had to store things with horrible keys, because all the children needed the parent key + child key + index. sucked. I hated writing reports, alot! There was no sum or group by or joins.. ick. I never want to go back. Moving from key/value to relational db was like moving from a tricycle to a 10-speed bike. -Andy -- 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] What was new in 8.4 8.3?
On Oct 11, 2010, at 4:35 PM, David Fetter wrote: Should we have a 9.1 one? There's already been at least one large, new feature, namely INSTEAD OF triggers. I think so. From my point of view, not needed until the release, or at least the feature set is frozen for sure. For people with a high enough level of interest to track things earlier, there are already sources. I'm thinking of a page to support those who do not follow dev, and periodically decide they now have time to start using new features... -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
