Maybe it was moved for PostGres v7 (I'm still using 6.5.3 because it works
and I'm too lazy to upgrade. :-) but in older versions the PG_VERSION file
was in the data directory (ie, /usr/local/pgsql/data/ ) Try checking what
you are using for a data dir ("locate pg_database" should tell you
A couple of questions and concerns about Blobs.
I'm wondering what kind of performance hits do BLOBS have on a database
large database.
Currently working on implementing a database with images. I guess i'm
looking for some numbers showing the performence. Note that it would be
for web
Well, I've tracked down the problem to its
mininal form, I think:
Here it goes:
[postgres@bert postgres]$ createdb test5
CREATE DATABASE
[postgres@bert postgres]$ psql test5
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with
Marko Kreen writes:
But now I am only curious: Will PostgreSQL support binary
arithmetics on ordinary integers someday or is the 'bit-string'
only way to go?
AFAIK, there's no one working on the former. Feel free to contribute. :-)
--
Peter Eisentraut [EMAIL PROTECTED]
Danny writes:
mydb=# INSERT INTO Customer
(Customer_ID,Customer_Name,Customer_Address,Customer_Email)
mydb-# VALUES ('1','Danny Ho','99 Second Ave, Kingswood','[EMAIL PROTECTED]'),
mydb-# ('2','Randal Handel','54 Oxford Road, Cambridge','[EMAIL PROTECTED]')
mydb-# ;
-and I get the
On Tue, 19 Sep 2000, Tomas B. Winkler wrote:
I would like to allow any user which has an unix account in our system to
be able to connect a DB. Can be postgres configured that an unix user
become automatically also a postgres user ? I can figure out some ways
to do it yet I'm looking for
Hello Tom,
Tuesday, September 19, 2000, 8:24:01 PM, you wrote:
TL There is also supposed to be a PG_VERSION file in each database
TL subdirectory.
TL If you accidentally deleted one of these per-database PG_VERSION files
TL then future connects to that database would fail with the above
TL
[EMAIL PROTECTED] writes:
Timezone is set to America/Buenos Aires
Changing this seems to elliminate the bug.
What did you change it *to*, exactly? And what dates did you test
after changing?
I would expect the bug to follow the DST transition date, which varies
in different timezones.
for what it's worth, when i run these two tests, i
get the correct results
i'm using RedHat 6.2 also.
here are more details:
[ebridges@sleeepy]$ uname -a
Linux sleeepy 2.2.16 #2 SMP Mon Jul 31 14:51:33 EDT 2000 i686 unknown
[ebridges@sleeepy]$ psql -V
psql (PostgreSQL) 7.0.2
Portions Copyright
Question:
Must transaction logging be ON while importing large data sets? Can
transaction logging be disabled when making batch updates to a large
database?
Background:
We have been testing with MS SQL server for some time with some large
databases (greater 30 million records per db).
I have been using:
*RedHat Linux 6.1 [2.2.12-20] on Intel
*PostgreSQL 6.5.3-3 [your RPMs]
*Perl 5.00503
*Apache 1.3.9
*mod_perl 1.21
*DBI 1.13
*DBD-Pg-0.93
on 2 Intel systems without any problems for several months now, the production website
is an SMP box the development box is a old, single
Tom Lane wrote:
Timezone is set to America/Buenos Aires
Changing this seems to elliminate the bug.
What did you change it *to*, exactly? And what dates did you test
after changing?
I changed to "Etc/GMT+4" and tested the same just the same dates
Edward Q. Bridges wrote:
i
to replace the one currently in $PGSRC/src/pl/plperl
it encompasses the information in that document while adding more structure
and more specific details about what is needed. it also addresses
a couple of issues that came up when i had personally installed it.
since there is no email
[EMAIL PROTECTED] writes:
Tom Lane wrote:
I'll bet there is some bit of internal state somewhere that affects
the results. It could be inside libc, or it could be in Postgres.
postgres, I would tend to think...
For one thing I've just found out: the 'histeresis' effect occurs
only WITHIN
Hi guys,
Where can I get a compiled version of the latest JDBC driver? The one I have
(downloaded from FTP a few days ago) gives errors when using
DatabaseMetaData - which seem to be fixed in CVS ages ago.
Ideas?
Mike
I've looked there but the site seems seriously out of date. Hasn't been
updated since June 1999? There are CVS commits that date from June 20 this
year!
Any other ideas?
Mike
-Original Message-
From: Jackson Ching [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 2:14 AM
Many others have posted on this but I have not seen an authoratative answer:
execution of Initdb on NT results in syntax errors - these seem to be
induced by whitespace only on some control command lines (for, case, ???).
I've been correcting them, one-by-one, by adding spaces on the ends of the
Actually, MySQL itself does not support transactions, and, from what I can
tell, it never will. Berkeley DB, though, does support transactions ...
what MySQL has done is provided an SQL interface over top of Berkeley DB
files to give the *appearance* of transactions ...
Basically, MySQL
/usr/bin/postmaster: CleanupProc: pid 888 exited with status 139
Okay, we have a postgres process going down with a SEGV. Do you
have a core file? I don't quite remember where they end up, but my
guess would be either the directory with postgres or somewhere in
the data directory (probably
19 matches
Mail list logo
