Would this be installing from source code or using a cygwin package? I
use 7.4.3 under cygwin package on XP Pro 24x7.
On Wed, 2004-06-30 at 16:17, Chuck Bernardes wrote:
> Anyone successful in installing PostgreSQL 7.4.3 on a windows XP Pro
> environment? I've read various README's but seem daun
Bruno Wolff III wrote:
On Wed, Jun 30, 2004 at 18:23:08 -0500,
[EMAIL PROTECTED] wrote:
What do other sites with mondo databases do?
There have been comments from people using storage systems that they
can freeze the storage system and get a consistant snap shot of the
file system. This can be u
Tom Lane wrote:
Dennis Gearon <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
The indexes on the shared system tables (eg, pg_database) are the only
issue here. One possible solution is to require that no locale-aware
datatypes ever be used in these indexes. I think right now this is true
because "na
Dennis Gearon <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The indexes on the shared system tables (eg, pg_database) are the only
>> issue here. One possible solution is to require that no locale-aware
>> datatypes ever be used in these indexes. I think right now this is true
>> because "name
On Wed, 2004-06-30 at 18:57, Christopher Cashell wrote:
> Yesterday, while attempting to access a database, I received errors
> saying that the database was innaccessible. After investigating a
> little, I found the following in the PostgreSQL log files:
>
> 2004-06-30 08:30:19 [24119] LOG: chec
On Wed, Jun 30, 2004 at 20:35:04 -0700,
Dennis Gearon <[EMAIL PROTECTED]> wrote:
> >
> Just shutting it down doesn't work?
If you can shut the database down then that works fine. Some people can't
do that and can't afford the long recovery time either.
---(end of broadca
This subject has been discussed literally a thousand times before. If
currval didn't work properly with parallel transactions I'm pretty sure
someone would have noticed and fixed it by now.
http://www.postgresql.org/docs/7.4/static/functions-sequence.html
explains all about sequences.
On Fri, 2
Tom Lane wrote:
<[EMAIL PROTECTED]> writes:
I feel lock_timeout it will be a nice feature . Lemme know what would be
the solution of the above problem from existing set of features.
AFAICS statement_timeout would work just fine for that; or you could
use NOWAIT.
ok, you mean we should p
Christopher Cashell <[EMAIL PROTECTED]> writes:
> 28424 postgres 18 0 16804 3044 15m D 0.0 1.6 0:06.72 postmaster
> Note that it does have a process status of 'D', or uninterruptible
> sleep. That would explain the unkillable part, though I'm curious how
> it ended up there.
Perhaps I'm
Sounds like a permissions problem with cron. Was the cron job created
under the non-root users account?
On Thu, 2004-06-24 at 15:47, Kristopher Spencer-Yates wrote:
> Hi
>
> I have a PHP script running as a non-root user. The non-root user will
> exec PHP script via cron once per day.
>
> War
lec <[EMAIL PROTECTED]> wrote:
> I always have to dump & restore to make a database (which is in use for
> a few months) efficient again. I have scheduled nightly vacuum analyze,
> but only dump & restore can make the database efficient again. Has
> anyone experience this?
You might benefit
On Wed, Jun 30, 2004 at 18:23:08 -0500,
[EMAIL PROTECTED] wrote:
>
> What do other sites with mondo databases do?
There have been comments from people using storage systems that they
can freeze the storage system and get a consistant snap shot of the
file system. This can be used to do a restor
Tom Lane wrote:
Chris Gamache <[EMAIL PROTECTED]> writes:
~>=~
~<=~
~<>~
~<~
~=~
~>~
They aren't familiar to me, but I can tell that they are text comparison
operators. The details of what and how they compare is a mystery to me!
Those are the non-locale-aware operators that Peter added to suppo
At Wed, 30 Jun 04, Unidentified Flying Banana Tom Lane, said:
> Christopher Cashell <[EMAIL PROTECTED]> writes:
> > Eventually I attempted to shut it down and restart it, however that
> > failed too. When I attempted to shut it down, I discovered a hung
> > 'startup subprocess' that can't be kille
--- Forwarded message follows ---
Date sent: 25 Jun 2004 11:41:22 +0200
From: Ago <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Send reply to: Ago <[EMAIL PROTECTED]>
Subject:[GENERAL]
I have a PHP script that runs
Hello!
I have a small database (10MB gz dump). When I do a pg_dump -l -s (to
list the schema) of the original database it takes below 1 second. But
when I do dump of a copy of the database (using a full restore into a
new DB) it takes like 10-15 seconds to do the schema list (pg_dump -l
-s). I ne
But if someone else runs the same transaction in the same time what value does
"currval('sequence')" return? That one of the first transaction or that one of the
other transaction? Moreover, field id is a unique primary key, it does not accept
duplicates.
On 25/06/2004 11.58, Michal Táborský <[
I always have to dump & restore to make a database (which is in use for
a few months) efficient again. I have scheduled nightly vacuum analyze,
but only dump & restore can make the database efficient again. Has
anyone experience this?
-lec
---(end of broadcast)
Richard Huxton wrote:
(B> alltest1 wrote:
(B>
(B>>Hi,
(B>>
(B>>I am wondering if it is thread-safe to use both JDBC and libpq
(B>>simultaneously.
(B>>
(B>>On a Linux, JDBC is used by Tomcat and libpq is used by a client
(B>>software written in C language. So JDBC and libpq are used by two
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I've built PostgreSQL 7.4.3 RPMS on RHEL3. Needed to change the spec file
a bit for tcl and kerberos. They heve been tested and are working fine.
RPMS, SRPMS and SPEC file is located at:
http://www.gunduz.org/postgresql/packages-7.4.3/rhel3/
Hi,
I am new to Unix systems.
I am getting the following error when trying to access the database
through psql:
$ psaql mydatabase
$ psql: can't load library 'libpq.so.3.0'
The psql was working fine until restarted the postmaster after setting
the configurations for tcp/ip to true in the postgreS
Hi
I have a PHP script running as a non-root user. The non-root user will
exec PHP script via cron once per day.
Warning: pg_exec(): Query failed: ERROR: checkout: Permission denied.
. in /usr/home/nonrootuser/script.php on line 23
Line 23 is, of course, the $result = pg_exec($db_connect, $call
Christopher Cashell <[EMAIL PROTECTED]> writes:
> Eventually I attempted to shut it down and restart it, however that
> failed too. When I attempted to shut it down, I discovered a hung
> 'startup subprocess' that can't be killed.
This is interesting because it seems just about exactly like this
Title: Questions concerning concurrency control in PostgreSQL
I have a few questions concerning concurrency control in PostgreSQL. I shall thank whoever can help me.
Question #1
=
Assume the following (concurrent) schedule, in which both transactions run in a serializable isolation le
Title: Questions concerning concurrency control in PostgreSQL
I have a few questions concerning concurrency control in PostgreSQL. I shall thank whoever can help me.
Question #1
=
Assume the following (concurrent) schedule, in which both transactions run in a serializable isolation l
Chris Gamache <[EMAIL PROTECTED]> writes:
> ~>=~
> ~<=~
> ~<>~
> ~<~
> ~=~
> ~>~
> They aren't familiar to me, but I can tell that they are text comparison
> operators. The details of what and how they compare is a mystery to me!
Those are the non-locale-aware operators that Peter added to suppo
<[EMAIL PROTECTED]> writes:
> I feel lock_timeout it will be a nice feature . Lemme know what would be
> the solution of the above problem from existing set of features.
AFAICS statement_timeout would work just fine for that; or you could
use NOWAIT.
regards, tom lane
--
Thomas LeBlanc wrote:
How to I run PostgreSQL on an Intel machine with Windows?
Hi Thomas,
This is probably the page you want:
http://techdocs.postgresql.org/guides/Windows
:-)
Regards and best wishes,
Justin Clift
---(end of broadcast)---
TIP 1: subs
Dennis Gearon <[EMAIL PROTECTED]> writes:
> Is there anyway for a single statement to access more than one database?
> Could a query, regexes, etc be facing indexes in different
> encodings/sorting collations if different databases in a cluster had
> different encodings/collations?
The indexes o
"Joe Maldonado" <[EMAIL PROTECTED]> writes:
> Where can I find a version of pg_filedump compatible with 7.4?
http://sources.redhat.com/rhdb/
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet
Soeren Gerlach <[EMAIL PROTECTED]> writes:
> * pg_dump takes 2/3 of the [single] CPU, postmaster the other 1/3 for both
>dumps
Really!? Hmm, that seems fairly backwards ... thinks ...
In the -Fc case this makes some amount of sense because pg_dump runs
gzip-style compression on the data (wh
Yesterday, while attempting to access a database, I received errors
saying that the database was innaccessible. After investigating a
little, I found the following in the PostgreSQL log files:
2004-06-30 08:30:19 [24119] LOG: checkpoint process (PID 28423) was
terminated by signal 11
2004-06-30
How to I run PostgreSQL on an Intel machine with Windows?
Thanks,
Thomas
_
MSN Movies - Trailers, showtimes, DVD's, and the latest news from Hollywood!
http://movies.msn.click-url.com/go/onm00200509ave/direct/01/
Hello,
I would like to know if I'm able to do the following with postgreSQL:
In a process A:
Creating a transaction, and so getting a new PGconn*
Beginning a transaction on this connection, with "BEGIN"
In a process B (in another memory space than the process A):
*** TAKE the transaction, con
"Bob Parkinson" <[EMAIL PROTECTED]> writes:
> Is it possible to share some TCL proc's between a set of functions?
Sure. IIRC all pltcl functions run in a backend share one interpreter
(and pltclu functions share a second one). You might look at the
"pltcl_modules" code as a convenient way of get
Soeren Gerlach <[EMAIL PROTECTED]> writes:
> So...the dump in the above format needs some 14 minutes, the restore 10
> minutes. This seems to be very slow as it means something like 100K/sec for
> dumping and restoring. The drive is cappable of 40 Meg/seconds, so thats
> not the bottleneck ,-) A
elein <[EMAIL PROTECTED]> writes:
> When creating a new data type, what are
> the operators absolutely necessary for that
> type to particpate in a btree index?
You must supply all the operators described in the standard strategy
set:
http://www.postgresql.org/docs/7.4/static/xindex.html#XINDEX-ST
hi,
Does anybody know offhand what is the correct way to use substr to extract the domain
name from a client_referer column as logged by mod_pgsqllog (httpd module), by
correcting the following:
the file 'hostname.sql' is pl/pgsql
main=> \e hostname.sql
ERROR: syntax error at or near "http"
> I have dump my databases qith mysqldump and put the
> result in a file ( named basisdata ).
>
> In order to make it be possible to be reloaded with
> psql, I want to convert the file with
> "mysql2pgsql.perl" tool.
>
> But I don't know the syntax.
>
> I tried this :
> "
> mysql2pgsql.perl basi
On Wed, Jun 30, 2004 at 15:02:33 +0100,
Adam Witney <[EMAIL PROTECTED]> wrote:
>
> Out of interest, what are the issues?
You should be able to find a more accurate description in the archives, but
my memory is that when you run a security definer function in a view
(this shouldn't apply if it i
On 30/6/04 2:52 pm, "Bruno Wolff III" <[EMAIL PROTECTED]> wrote:
> On Wed, Jun 30, 2004 at 13:21:00 +0100,
> [EMAIL PROTECTED] wrote:
>>
>> If I revoke insert,update,delete privileges on a table, would
>> the user still be able to affect data manipulation through a
>> function? Is that another w
On Wed, Jun 30, 2004 at 13:21:00 +0100,
[EMAIL PROTECTED] wrote:
>
> If I revoke insert,update,delete privileges on a table, would
> the user still be able to affect data manipulation through a
> function? Is that another way of getting around this?
If you use a security definer function whe
[EMAIL PROTECTED] wrote:
Hi all;
Is it possible to write a trigger or the ilk that would disallow
direct inserts, updates, or deletes to a table unless it was
being executed through a function? How can I identify that the
DML being issued is being done via a function?
http://www.postgresql.org/
Hello,
As a MySQL and PostgreSQL developer, I had been using
SQLyog for long for my MySQL work. Now they have
released it for PostgreSQL also. Check their post at:
http://www.webyog.com/forums/index.php?s=3d509372b5d4a724c38ab8704da7a708&act=ST&f=2&t=472&st=0entry3219
Hope it helps to all the
Dear my friends...
I am trying to nigrate my database from mysql to
postgres.
I have dump my databases qith mysqldump and put the
result in a file ( named basisdata ).
In order to make it be possible to be reloaded with
psql, I want to convert the file with
"mysql2pgsql.perl" tool.
But I don't
Hi all;
Is it possible to write a trigger or the ilk that would disallow
direct inserts, updates, or deletes to a table unless it was
being executed through a function? How can I identify that the
DML being issued is being done via a function?
We are writing an API of sorts and for various bu
Hi!
How can I interpret a variable in psql, when the variable has to be quoted?
for example:
\set myVar myValue
\echo :myVar
The Result ist then "myValue" ==> ok
But: in my case the variable-values have to be in quotes:
\set db_username myUsername
\set db_password myPassword
CREATE USER :db_u
Hi,
Is it possible to share some TCL proc's between a set of functions? Something like
proc mything {
}
proc otherthing {
}
create function wantsthings (text) returns text as
'
return [mything [otherthing fubar]]
' language 'pltcl';
Cheers,
Bob
This message has been scanned
Soeren Gerlach wrote:
Dumping needs to be done at least once a day (for copying as well as
archiving it), while restoring to two other databases will be done twice a
day. The dump is currently only 80 MB which I consider as very small (the
expected growth of the database will be 20-30 MB a day l
49 matches
Mail list logo