How do you handle statements that rely on current_timestamp, random(),
etc? What about if their reliance is via a function? Is that just an
understood limitation of the cache, that it'll cache even queries that
don't really make sense to cache?
Probably we should cache the result of a query
Hi,
2011/5/18 Tatsuo Ishii is...@postgresql.org:
How do you handle statements that rely on current_timestamp, random(),
etc? What about if their reliance is via a function? Is that just an
understood limitation of the cache, that it'll cache even queries that
don't really make sense to cache?
Hi Craig,All
when i try from the service control panel
I get an
1053 error : the service did not respond to restart or control request in a
timely fashion
Additionally no log is produced @
C:/Program Files/PostgreSQL/9.0/data/pg_log
I suspect a mesh with the postgres account. Can I
Hi,
We experienced similar problem : it was just the encoding of pg_hba.conf
that was accidentally changed when modifying it (UTF8/ansi)
Thierry
Le 18/05/2011 09:28, G. P. a écrit :
Hi Craig,All
when i try from the service control panel
I get an
*1053 error : the service did not respond
Hi Thierry,
The encoding is ansi. Should I save them as UTF8?
From: Thierry Hauchard gesteam_...@gesteam.fr
To: pgsql-general@postgresql.org
Sent: Wed, May 18, 2011 10:46:51 AM
Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data??
Hi,
We
On 05/18/2011 03:46 PM, Thierry Hauchard wrote:
Hi,
We experienced similar problem : it was just the encoding of pg_hba.conf
that was accidentally changed when modifying it (UTF8/ansi)
The encoding should not matter unless there are characters above byte
128, because UTF-8 and the ANSI
Hi,
I've got a question about quite a strange configuration.
I was asked if we can have one storage, with one data directory where one
postgresql instance writes data, and many other instances read those.
Is that possible without any replication and copying data?
regards
Szymon
Dear all,
I explain in the simple terms :
Our application stores data in a format that is not best fitted
to analyze.
_*Table news
*_category_id Record_id field_name field_value
can I download from somewhere clean pg_hba.conf / postgresql.conf with
default
values, just to ensure that the failure is caused by them ?
From: Craig Ringer cr...@postnewspapers.com.au
To: Thierry Hauchard gesteam_...@gesteam.fr
Cc:
Hi!
In Firebird the transaction can be parameterizable as:
SET TRANSACTION
...
[WAIT | NO WAIT]
[LOCK TIMEOUT seconds]
The NO WAIT is force transaction to return instantly with errormsg
when some deadlock situation happened, Timeout is define the seconds
for wait.
This can be set for
Hi!
Is there any function in PGSQL that returns an unique Session
identifier of the actual session?
For example a Bigint, or GUID, or etc?
Can I get the living Session identifiers from PG?
We have a little application that uses these infos which are basically
came from another database system,
Hello
2011/5/18 Durumdara durumd...@gmail.com:
Hi!
Is there any function in PGSQL that returns an unique Session
identifier of the actual session?
For example a Bigint, or GUID, or etc?
Can I get the living Session identifiers from PG?
try
postgres=# select pg_backend_pid();
On 05/18/11 4:31 AM, G. P. wrote:
can I download from somewhere clean pg_hba.conf / postgresql.conf
with default values, just to ensure that the failure is caused by them ?
those files are created by initdb
just run initdb on a scratch directory
--
Sent via pgsql-general mailing list
On Wed, May 18, 2011 at 3:01 AM, Durumdara durumd...@gmail.com wrote:
Hi!
In Firebird the transaction can be parameterizable as:
SET TRANSACTION
...
[WAIT | NO WAIT]
[LOCK TIMEOUT seconds]
The NO WAIT is force transaction to return instantly with errormsg
when some deadlock
Finally i re-installed PostgreSQL everything seems to be OK!
From: John R Pierce pie...@hogranch.com
To: pgsql-general@postgresql.org
Sent: Wed, May 18, 2011 5:34:05 PM
Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data??
On 05/18/11
On Wed, May 18, 2011 at 7:21 AM, Szymon Guz mabew...@gmail.com wrote:
I've got a question about quite a strange configuration.
I was asked if we can have one storage, with one data directory where one
postgresql instance writes data, and many other instances read those.
Is that possible
Hello,
A question about large object column type in postgresql8.3.
A pdf file=500KB.
If saving into large object column, will the table size be around 500KB?
If larger than 500KB, what could be the proximate size?
Thanks a lot!
Emi
--
Sent via pgsql-general mailing list
W dniu 2011-05-18 13:21, Szymon Guz pisze:
Hi,
I've got a question about quite a strange configuration.
I was asked if we can have one storage, with one data directory where one postgresql instance
writes data, and many other instances read those.
Is that possible without any replication and
On 18 May 2011 22:22, Ireneusz Pluta ipl...@wp.pl wrote:
W dniu 2011-05-18 13:21, Szymon Guz pisze:
Hi,
I've got a question about quite a strange configuration.
I was asked if we can have one storage, with one data directory where one
postgresql instance writes data, and many other
Is this list suited for coding questions?
I'm using VS2008, connecting to postgresql with libpq and
have some initial questions.
Regards
Bret Stern
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
The basic setup can do that.
Configure one Postgres user to have read/write access to all database tables
Configure another Postgres user to have read-only access to all database tables
Clients that need read-only access are given the read-only user credentials
while the writers are given the
I have no idea what type of storage that you are using, but we utilize
NetApp storage and use Flexclones to create multiple read-only copies of a
master database. The flexclone takes seconds to configure and essentially
only consume delta space. Works great so far.
Terry
On Wed, May 18, 2011 at
Note 1:
I have seen an array that was powered on continuously for about six
years, which killed half the disks when it was finally powered down,
left to cool for a few hours, then started up again.
Recently we rebooted about 6 machines that had uptimes of 950+ days.
Last time fsck had run
what is this talk about replicating your primary database to secondary nodes in
the cloud.. or is cloud computing still marketing hype?
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
On 19/05/11 10:50, mark wrote:
Note 1:
I have seen an array that was powered on continuously for about six
years, which killed half the disks when it was finally powered down,
left to cool for a few hours, then started up again.
Recently we rebooted about 6 machines that had uptimes of 950+
On 05/19/2011 04:39 AM, Bret Stern wrote:
Is this list suited for coding questions?
I'm using VS2008, connecting to postgresql with libpq and
have some initial questions.
Sure - though there are more UNIX/linux users than Windows users here. I
haven't noticed many Windows-based Pg users
On 05/19/2011 04:33 AM, Szymon Guz wrote:
On 18 May 2011 22:22, Ireneusz Pluta ipl...@wp.pl
mailto:ipl...@wp.pl wrote:
W dniu 2011-05-18 13:21, Szymon Guz pisze:
Hi,
I've got a question about quite a strange configuration.
I was asked if we can have one storage,
Hi list
We're writing a plugin for our website that loads single-table database
dumps created by untrusted users. My question is two-fold:
1. I'm assuming that the dump format can contain arbitrary sql commands, so
a pg_restore of this nature should be run under an untrusted account in its
own
On 05/19/2011 08:57 AM, Martin Gainty wrote:
what is this talk about replicating your primary database to secondary
nodes in the cloud...
slow.
You'd have to do async replication with unbounded slave lag.
It'd also be very easy to get to the point where the load on the master
meant that the
On 05/19/2011 10:10 AM, Craig de Stigter wrote:
1. I'm assuming that the dump format can contain arbitrary sql commands,
so a pg_restore of this nature should be run under an untrusted account
in its own restricted schema. Can someone confirm that this is the case?
Correct. You very
On 05/18/2011 07:31 PM, G. P. wrote:
can I download from somewhere clean pg_hba.conf / postgresql.conf with
default values, just to ensure that the failure is caused by them ?
AFAIK they're generated by the installer, as they contain paths specific
to your installation. So not really.
It
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each other. Trouble is, I have a
windows 7 64bit OS and
Hey guys,
If I get H1B visa as Postgresql DBA, then what may I expect to get as my
salary?
Does anyone have idea on this?
Thanks.
33 matches
Mail list logo