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
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
-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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Hola , soy estudiante universitario y estoy interesado en
trabajar con PostgresSQL y me gustaría que me ayudaran mandándome información sobre
él
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
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
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
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
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
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
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
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
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,
28 matches
Mail list logo