Re: [GENERAL] pgbench
pgbench comes with PostgreSQL source code distribution and must be compiled under PostgreSQL source tree. I'm not familiar with MacOS but I guess there may be pre-compiled package. Anyone can help him? -- Tatsuo Ishii SRA OSS, Inc. Japan I have just received my new MacBook (1.83Gz. Duo) and wanted to do some benchmark testing of Postgres using your Pgbench, however I ma getting errors while compiling. I could probably fix some of these (define TRUE RAND_MAX) I am not sure what RAND_MAX is on other systems and as far as the exit(1)? again not sure why. Any help would be appreciated. here is the output: macbook:~/Desktop/pgbench-1.1 jeffruss$ make gcc -O2 -I/usr/local/pgsql/include -c -o pgbench.o pgbench.c pgbench.c:24:22: error: postgres.h: No such file or directory pgbench.c: In function 'getrand': pgbench.c:94: error: 'RAND_MAX' undeclared (first use in this function) pgbench.c:94: error: (Each undeclared identifier is reported only once pgbench.c:94: error: for each function it appears in.) pgbench.c: In function 'doOne': pgbench.c:131: error: 'TRUE' undeclared (first use in this function) pgbench.c:216: warning: incompatible implicit declaration of built-in function 'strcpy' pgbench.c: In function 'doSelectOnly': pgbench.c:267: error: 'TRUE' undeclared (first use in this function) pgbench.c: In function 'init': pgbench.c:355: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:362: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:370: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:378: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:389: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:397: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:407: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:415: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:420: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:426: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:434: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c: In function 'main': pgbench.c:523: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:532: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:537: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:545: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:552: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:557: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:565: warning: assignment makes pointer from integer without a cast pgbench.c:573: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:588: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:595: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:600: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:609: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:616: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:626: error: 'uint' undeclared (first use in this function) pgbench.c:626: error: parse error before 'tv1' pgbench.c:637: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:659: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:671: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:688: warning: incompatible implicit declaration of built-in function 'exit' pgbench.c:695: warning: incompatible implicit declaration of built-in function 'exit' make: *** [pgbench.o] Error 1 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3
the lsp-fix did the trick. As you supposed it was a personal firewall (however a great product, called armor2net personal), which unfortunately was broken with the winsock lib. Obviously not a gread product, I'd say, if it breaks the winsock stack. Which the hole purpose of a firewall is to protect, really... Strange problem with it however, that it hasn't got any problems with the earlier version of Postgres (last i had to use was: 8.0.4 on win32) Yes, that's very interesting indeed. I don't think we made any major changes with that one. This is on the same machine? Perhaps some other piece of software was also installed, that triggered the problem? I reconnected my windows-integrated firewall, which caused some problems, but i managed it to work (System Properties/Advanced/Performance - Settings/ Data Execution Prevention/Turn on DEP for all programs and services except those I select: Add- psql, pgadmin, postmaster) That's not relaly the firewall. Nonetheless, it's very interesting. Did you really need it for all those programs? I don't recall having ever had to set that, but it could be that it's not supported by the CPU on any of my test machines :-) But it specifically surprises me that it was necessary for psql and pgadmin. //Magnus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3
-Original Message- From: [EMAIL PROTECTED] on behalf of Magnus Hagander Sent: Sat 3/4/2006 9:46 AM To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Subject: Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3 But it specifically surprises me that it was necessary for psql and pgadmin. Both should run fine with DEP on; I do so all the time. /D ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] record OID to table
On Fri, Mar 03, 2006 at 09:01:53PM -0700, Michael Fuhr wrote: Could you explain what you're trying to do without reference to how you're trying to do it? It sounds like the goal is to take an arbitrary string and find out what rows in what tables contain that string. Is that right? If so them I'm not sure how to best solve that problem; maybe somebody else will have some ideas. If it happens to be one text field per table it can be solved with inheritance. Inherit the text field from a parent table and search through that eventually deducing the appropriate child table with tableoid where needed. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Quick psqlODBC driver setting
Bart Golda [EMAIL PROTECTED] wrote in
news:[EMAIL PROTECTED]:
I would like to have an installation program, which creates psqlODBC
connection, so there will be no need of typing and clicking on two
hundred workstations... There is the driver's msi file which can be
installed very nicely, but what is the best way of creating the
connection itself without much pain? My current idea is like this:
1. Exporting the entry
CONNECTION_NAME REG_SZ PostgreSQL ANSI from
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
2. Exporting HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\CONNECTION_NAME
3. Running the reg file(s) on the target machine
Well, it works - more or less - but is this a *right way*? How do *you*
do it?
As i see it this is the right way if you want to use DSN connections.
With DSN less connections it depends on the application you use.
(Newlines should be removed when examples is used)
--- Example for connect string in Microsoft Access ---
ODBC;DRIVER={PostgreSQL};SERVER=servername;READONLY=
0;DATABASE=databasename;UID=username;PWD=password
--- End example for connect string in Microsoft Access ---
--- ( _ indicates continuation of string on next line ) ---
--- Example for National Instruments TestStand v1.0.3 ---
--- and natiobnal Instruments SQL Toolkit for LabVIEW ---
Provider=MSDASQL.1;Extended Properties=DRIVER=
{PostgreSQL};SERVER=servername;UID=username;PWD=password;READONLY=
0;MaxLongVarcharSize=3;DATABASE=databasename;
--- End example for National Instruments TestStand v1.0.3 ---
--- (I am using PostgrSQL ODBC driver v 07.01.0010 when using Teststand)
--
Rolf Østvik
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] How do I prevent binding to TCP/IP port outside of localhost?
On 2/23/06, Karl Wright [EMAIL PROTECTED] wrote: I have a situation where I need postgres to LISTEN and allow BINDs to its TCP/IP port (5432) only to connections that originate from localhost. I need it to not accept *socket* connections if requests with new postgresql's (i dont know which version you are using) you can specify ip address to bind to. so you have to bind to 127.0.0.1 depesz ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Using same database from XP and Linux in notebook
I have notebook which can be booted into Windows XP/NTFS and into Linux. Notebook is not connected to any network. There are separate IDE partitions for both OS. I want same Postgres 8.1 database to be available in both modes. I think I must put Postgres database cluster into a NTFS partition which can be written from Postgres running on Linux or into Linux partition which can be written from Postgres running in XP. Any idea how to implement dual OS database ? Is there a ready to install Linux distro which supports this ? Andrus. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Using same database from XP and Linux in notebook
Here is an example I always used as a start point in this type of project. http://campbellcentral.org/rick/code/setup.html Generally, I would store the datafiles on an NTFS partition - it seems easier to reach NTFS from Linux then vice-versa. I have seen this done successfully with virtually all Linux distributions. Bill Penberthy Scarpa Technology, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrus Moor Sent: Saturday, March 04, 2006 8:52 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Using same database from XP and Linux in notebook I have notebook which can be booted into Windows XP/NTFS and into Linux. Notebook is not connected to any network. There are separate IDE partitions for both OS. I want same Postgres 8.1 database to be available in both modes. I think I must put Postgres database cluster into a NTFS partition which can be written from Postgres running on Linux or into Linux partition which can be written from Postgres running in XP. Any idea how to implement dual OS database ? Is there a ready to install Linux distro which supports this ? Andrus. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- 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
[GENERAL] xml and utf-8
Any pointers/tricks/gotchas on storing XML into postgresql? Is it any more complicated than storing the XML into a bytea field? Do I have to worry about character encoding? All my XML is in utf-8. tia, arturo ---(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] Default Access Exclusive Lock on Update?
For anyone that is interested, my problem was solved on another list. Turns out the TRUNCATE command that I run at the beginning of the SP creates and holds an access exclusive lock on the table for the entire duration of the SP. I changed it to DELETE FROM and my problem was fixed. Full discussion here - http://tinyurl.com/rp9jx ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] Quick psqlODBC driver setting
I would like to have an installation program, which creates psqlODBC connection, so there will be no need of typing and clicking on two hundred workstations... There is the driver's msi file which can be installed very nicely, but what is the best way of creating the connection itself without much pain? My current idea is like this: 1. Exporting the entry CONNECTION_NAME REG_SZ PostgreSQL ANSI from HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources 2. Exporting HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\CONNECTION_NAME 3. Running the reg file(s) on the target machine Well, it works - more or less - but is this a *right way*? How do *you* do it? Regards, Bart Golda ---(end of broadcast)--- 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
Re: [GENERAL] ERROR: column datpath does not exist
Thanks Scott, now I got it! ;) I found older copies of pg_dump in /usr/bin while the newer were in /usr/local/pgsql/bin/. Beginner's mistake... 8-) Sascha ---(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
[GENERAL] PgsqlODBC connection parameters in the registry
Is there any way to crypt ODBC settings (user, password)? It seems to be stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI in plain text. I can use bogus data there and cover it with proper login and password on application side, but... er... MSSQL does not store password in this way... It is probably possible to prevent user from reading the values in the registry, but it is a sort of a whole-system-not-application setting. It seems that this way of storing information can be unsafe in certain circumstances and so on... Thanks in advance, Bart Golda ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] tsearch2 match substrings in words
Hi, Is it possible using tsearch2 to match a substring of an element of a ts_vec column? For example: I have a table with a ts_vec, and I have a field with text, and if there is a value in the field I would like to match the beginning of the words - and the ts_vec has 'like':3 'match':5 'begin':7 ...etc then it would be cool to create a query, which give me a headline for begin if I just use the beg (or beg* ) search expression. Is there a way to solve this? Thanks in advance. Abbath ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3
Hi, the lsp-fix did the trick. As you supposed it was a personal firewall (however a great product, called armor2net personal), which unfortunately was broken with the winsock lib. Strange problem with it however, that it hasn't got any problems with the earlier version of Postgres (last i had to use was: 8.0.4 on win32) I reconnected my windows-integrated firewall, which caused some problems, but i managed it to work (System Properties/Advanced/Performance - Settings/ Data Execution Prevention/Turn on DEP for all programs and services except those I select: Add- psql, pgadmin, postmaster) Thanks for the help, Istvan - Original Message - From: Magnus Hagander [EMAIL PROTECTED] To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Sent: Tuesday, February 28, 2006 9:24 PM Subject: RE: problem with windows xp sp2 and postgres-8.1.3 first of all, great effort from you this tool. Problem exists with following config: - Windows XP Pro, SP2 (English). - PostgreSQL-8.1.3 - lot of development programs, and IDE-s (for the clients i am working unfortunately they are windoz-based :-(...). Same problem occurs as described here and here http://archives.postgresql.org/pgsql-ports/2005-10/msg1.php . = could not create inherited socket: error code 10022. = This sounds a lot like broken firewall, broken antivirus, broken antispyware or such software. Take a look with http://www.cexx.org/lspfix.htm to see what you have there - most likely at least one broken LSP. As i tried again manually(postmaster...), had the same problem. I turned off my firewall services, windows security center firewall and antivirus check (automatic updates are on), but i got the same error. Turn off is often not enough, you need to uninstall. Can it have anything related to windows-socket bind problems with Windows-XP-SP2 integrated firewalls however it is disabled? No, the intergrated firewall should work fine, as long as it's not blocking the connections (meaning if it's disabled, it shouldn't be a problem). It's known not to have the LSP bug. //Magnus ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Questions about privileges
Hello, For an exercise at university, I have several SQL queries to find to manage privileges on a database. I didn't found all the queries. So, this is my problem : I have got one table named books with several columns. * The first question is : - All users can find titles, codes and prices of books (which are columns of the table books) For the moment, I did this : grant select on table books to public; But with this solution, all users can find information about all the attributes of the table books and not only about titles, codes and prices. So, I would like if a solution existed for that (to allow all users to access only at the columns titles, codes and prices). * My second question is : - Mister X can create an index on the table books For the moment, I did this : grant create on tablespace books to X; Is that good ? * My third question is : - Mister X can update the structure of the table books For that, I don't know how I can do. Someone would have an idea to do that ? * My last question is : - Mister X can update the column quantity of the table books where the column codes is equal to 2 but He can't access at others datas of the table books. For the moment, I found how to limit the update at the column quantity of the table books with the following query : grant update(quantity) on books to X; But, I don't know how to limit the update of the column quantity only where column codes is equal to 2. Someone would have an idea to do that ? Thanks to help me. Sylvain. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] What query on system tables retrieves table or queries definitoin
What is the query for retrieving a tables and a views definition from the system tables (in 7.4). I am trying to find my way in the system tables and I am finding very confusing, especially way in the way the tables are linked. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] A pg_hba.conf problem - again...
So there is Fedora Core 3 with PostgreSQL 8.1.3 installed from rpms. The server listens on all interfaces. For testing, I used this pg_hba.conf (default with added line) and it worked: local all all trust host all all 127.0.0.1/32 trust host all all ::1/128 trust host all all 10.144.3.0/24 trust Very happy, I changed trust in the last line to MD5. The application (pgAdmin) stopped connecting (yes, sql user and its password was correct). No error, just unable to connect or something like this - I have localised version - in the status line. Is there something wrong with above file or maybe there are some missing libraries, of which I (and rpms) am not aware of? :( Thanks for any suggestions, Bart Golda ---(end of broadcast)--- 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
[GENERAL]
Hola , soy estudiante universitario y estoy interesado en trabajar con PostgresSQL y me gustaría que me ayudaran mandándome información sobre él
Re: [GENERAL] What query on system tables retrieves table or queries definitoin
On Sat, Mar 04, 2006 at 03:13:18AM +, [EMAIL PROTECTED] wrote: What is the query for retrieving a tables and a views definition from the system tables (in 7.4). I am trying to find my way in the system tables and I am finding very confusing, especially way in the way the tables are linked. If you start psql with the -E switch or use \set ECHO_HIDDEN = 'on' then the \d command print the queries used to generate the output. This should give you a good start. Alternativly, use the information_schema. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a tool for doing 5% of the work and then sitting around waiting for someone else to do the other 95% so you can sue them. signature.asc Description: Digital signature
Re: [GENERAL] Questions about privileges
On Sat, Mar 04, 2006 at 05:08:27AM -0800, [EMAIL PROTECTED] wrote: I have got one table named books with several columns. * The first question is : - All users can find titles, codes and prices of books (which are columns of the table books) So, I would like if a solution existed for that (to allow all users to access only at the columns titles, codes and prices). Create a view and only grant access to that. The next two questions I can't help with * My last question is : - Mister X can update the column quantity of the table books where the column codes is equal to 2 but He can't access at others datas of the table books. But, I don't know how to limit the update of the column quantity only where column codes is equal to 2. Someone would have an idea to do that ? Same thing. Create a view with what he can see and make it updatable with some rules. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a tool for doing 5% of the work and then sitting around waiting for someone else to do the other 95% so you can sue them. signature.asc Description: Digital signature
Re: [GENERAL] Insert fails when it shouldn't
Adding -general back to the distribution list. Please do a reply-all. Even if you tell psql what encoding to use, if the database is created with the wrong encoding it might not be able to differentiate between the two strings. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sat 3/4/2006 9:46 AM To: Jim Nasby Cc: Subject:Re: [GENERAL] Insert fails when it shouldn't To execute the insert statements I use psql. From the command line the command \encoding writes:ISO_8859_7 which is the right one since characters are greek strings. -- Three words describe our society:homo homini lupus ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] PostgreSQL on Intel Core Duo Macs?
I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? Thanks, Andrew Gould ---(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] PostgreSQL on Intel Core Duo Macs?
On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote: I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? It's run fine on the intel developer macs for quite a while. I've not actually built it on the shiny new macs, but OSX/x86 is OSX/x86. Cheers, Steve ---(end of broadcast)--- 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
Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?
On Sat, 4 Mar 2006 19:34:49 -0800 Steve Atkins [EMAIL PROTECTED] wrote: On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote: I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? It's run fine on the intel developer macs for quite a while. I've not actually built it on the shiny new macs, but OSX/x86 is OSX/x86. Cheers, Steve Thanks! Andrew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] xml and utf-8
If your DB encoding is UTF-8, I don't see why you can't use a TEXT data type. Regards, Gavin On Mar 2, 2006, at 7:07 PM, Perez wrote: Any pointers/tricks/gotchas on storing XML into postgresql? Is it any more complicated than storing the XML into a bytea field? Do I have to worry about character encoding? All my XML is in utf-8. tia, arturo ---(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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] User tables
Suppose there 3 users red, green, blue. How can the user green know what tables he has created?! From psql command line \dt lists every table in the DB!!! Thanks in advance. Hrishi If you mean that the owner of the table(s) is the user green, then try select * from pg_tables where tableowner='green'; or from inside psql: \z ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?
Hi, We're running PostgreSQL 8.1.3 on an Intel iMac at work and I also have it running just fine on my new MacBook Pro. No problems. Compiled as is out of the box using the instructions at http:// keyvaluecoding.com Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Mar 4, 2006, at 8:46 PM, Andrew L. Gould wrote: On Sat, 4 Mar 2006 19:34:49 -0800 Steve Atkins [EMAIL PROTECTED] wrote: On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote: I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? It's run fine on the intel developer macs for quite a while. I've not actually built it on the shiny new macs, but OSX/x86 is OSX/x86. Cheers, Steve Thanks! Andrew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings smime.p7s Description: S/MIME cryptographic signature
