Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Wed, Dec 5, 2007 at 8:25 AM, in message
<[EMAIL PROTECTED]>,
Paul Lambert <[EMAIL P
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Wed, Dec 5, 2007 at 8:25 AM, in message
<[EMAIL PROTECTED]>,
Paul Lambert <[EMAIL P
On Monday 03 December 2007 20:22, Erik Jones wrote:
> On Dec 3, 2007, at 6:10 PM, Tom Lane wrote:
> > Erik Jones <[EMAIL PROTECTED]> writes:
> >> 8.2.5 on Solaris 10. Before we upgraded to 8.2.4 it was doing about
> >> 65 Mbs/sec. Interestingly, a while back we were running with the
> >> data dir
On Monday 03 December 2007 18:24, Matthew Dennis wrote:
> The release notes seem to be in two places, with slightly different
> information.
>
> The page Google sends back for most 8.3 queries
> http://www.postgresql.org/docs/8.3/static/release-8-3.html
>
This is the docs distributed with the late
Christian Rengstl wrote:
The archive_command is 'copy %p C:\\Archive\\DBArchive\\%f',
nevertheless I changed it to your version, but without success.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
And wha
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Wed, Dec 5, 2007 at 2:47 AM, in message
<[EMAIL PROTECTED]>,
Paul Lambert <[EMAIL P
> We're developing .NET application (closed-source) and would like to include
> pg_dump to allow users to perform "quick database backup" within main
> application.
>
> Two questions:
>
> 1. Do we need to include any dependent files besides pg_dump.exe ?
IIRC, you need libpq and it's dependencie
On Wednesday 05 December 2007 01:45, rihad wrote:
> In postgresql.conf generated by initdb shared_buffers is set to 32MB
> even though there was more available (see below; also ipcs shows
> postgres is (and will be) the only shared memory user). Is this enough
> or maybe it's less than ok?
Chances
In postgresql.conf generated by initdb shared_buffers is set to 32MB
even though there was more available (see below; also ipcs shows
postgres is (and will be) the only shared memory user). Is this enough
or maybe it's less than ok? I don't know. What I do know is that MySQL
4.0.x uses 500-550
We¹re running PostgreSQL 8.1.4 on RHEL. I¹m running a vacuum analyze on the
mxl_fs_size table to see if that shows anything.
-Keaton
On 12/4/07 10:50 PM, "Keaton Adams" <[EMAIL PROTECTED]> wrote:
>
> We have two servers configured the same way running the same type of processes
> that write/
We have two servers configured the same way running the same type of
processes that write/read to the database. Server 2 filled up pg_xlog and
crashed. When it came back we began to experience slow query performance.
I ran an ANALYZE against the tables involved in the query, but for some
reason
On Mon, 3 Dec 2007, Ed Burgstaler wrote:
Would anyone be able to direct me as to whether or not there is a pgadmin
for windows utility available that will work for a PostgreSQL v7.0.3
database?
From reading the rest of your message, I think you're under the impression
that you need pgadmin in
Paul Boddie <[EMAIL PROTECTED]> writes:
> I have one process querying a table P with partitions P0, P1, P2, ...
> Pn joined with table R as follows:
> select * from R inner join P on R.id = P.id and P.section = 5
> ...
> I have another process performing updates to individual partitions of
> P - sp
Here is the log output when I try different passwords:
When I enter an incorrect password I get the following:
[unknown] [unknown] 2007-12-05 13:55:29 CST LOG: connection
received: host=111.111.111.111 port=1791
user test_db 111.111.111.111 2007-12-05 13:55:29 CST DEBUG: received
password pack
[EMAIL PROTECTED] writes:
> suppose a table has a UNIQUE constraint on a column, and two
> concurrent transactions attempt to INSERT a row with the same value
> for that column:
Whichever one manages to get to the index page first will go through.
The second one will block waiting to see if the fi
Daniel Schuchardt <[EMAIL PROTECTED]> writes:
> LOLL2=# SELECT to_char('2007-12-31'::DATE, 'IW');
> to_char
> -
> 200701
> (1 row)
> 2007-12-31 should be week 2008-01
No, it shouldn't. is defined to deliver calendar year.
For ISO year use IYYY.
regard
Christian Rengstl wrote:
show config_file points to the right one. I restarted the server after
every change. After including the quotation marks as in the docs, the
quotation marks also appeared in the command, so at least it shows that
the config file was read.
How about show archive_command
On Tue, 2007-12-04 at 14:21 -0500, Gauthier, Dave wrote:
> Is there something like a freeware windows client app that does DBA
> stuff for a remote server? Sort of like TOAD for Oracle?
pgadmin3?
and please don't hijack threads
---(end of broadcast)--
On Dec 4, 2007 6:04 PM, Peck, Brian <[EMAIL PROTECTED]> wrote:
> SELECT source_id as vertex INTO result FROM $3 ORDER BY
> Distance(the_geom,PointFromText(POINT( $1 $2 ))) LIMIT 1;
I think you're missing a comma, e.g. POINT( $1 , $2 ).
---(end of broadcast)---
On Dec 4, 2007 8:02 PM, Bill Moran <[EMAIL PROTECTED]> wrote:
> "Andrus" <[EMAIL PROTECTED]> wrote:
> > Using string concatenation in where clause causes huge perfomance loss:
> >
> > explain analyze select
> >rid.toode
> >FROM dok JOIN rid USING (dokumnr)
> >JOIN toode USING (toode
"Andrus" <[EMAIL PROTECTED]> wrote:
>
> Using string concatenation in where clause causes huge perfomance loss:
>
> explain analyze select
>rid.toode
>FROM dok JOIN rid USING (dokumnr)
>JOIN toode USING (toode)
>LEFT JOIN artliik using(grupp,liik)
>WHERE rid.toode='NAH S'
>
does psql have write access to the folder?
M-
- Original Message -
From: Wim Chalmet
To: pgsql-general@postgresql.org
Sent: Tuesday, December 04, 2007 10:27 AM
Subject: [GENERAL] Vacuum output redirect
Hi,
Sorry for my basic question here, but I can't figure things out.
Joshua D. Drake wrote:
On Tue, 4 Dec 2007 13:59:13 -0800
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
Thanks to all the testing, feedback and bug reports the community has
performed with the current betas, we now have our fourth beta
of 8.4.
Pardon. I am living 12 months in the future. This s
On Tue, Dec 04, 2007 at 02:21:43PM -0500, Gauthier, Dave wrote:
> Is there something like a freeware windows client app that does DBA
> stuff for a remote server? Sort of like TOAD for Oracle?
TOAD either does or used to work for Postgres.
A
---(end of broadcast)---
On Mon, Dec 03, 2007 at 03:20:45PM -0600, Ed Burgstaler wrote:
> Would anyone be able to direct me as to whether or not there is a pgadmin
> for windows utility available that will work for a PostgreSQL v7.0.3
> database?
Not to my knowledge. But I wouldn't spend any time on it -- you need to ge
On Tue, 4 Dec 2007 13:59:13 -0800
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
>
> Thanks to all the testing, feedback and bug reports the community has
> performed with the current betas, we now have our fourth beta
> of 8.4.
Pardon. I am living 12 months in the future. This should be:
we now
On 04/12/2007 15:27, Wim Chalmet wrote:
Sorry for my basic question here, but I can't figure things out. I am
running postgres in a windows environment. I would like to redirect the
output from a "vacuum full analyze verbose;" to a text file. How do I do
this?
You could use the standalone pr
Hey all,
I'm trying to create functions for the calls I'm making to limit the
number of DB pings I have to make (i.e. after they are all calls make
one call that calls them in succession) and I'm getting an error.
The function is
CREATE OR REPLACE FUNCTION nearestVertex(x1 double preci
Hi,
Sorry for my basic question here, but I can't figure things out. I am
running postgres in a windows environment. I would like to redirect the
output from a "vacuum full analyze verbose;" to a text file. How do I do
this?
I have tried this (the file "run_vacuum.sql" just contains this one line
Thanks Tom. I don't know what change I've made that the server seems to
like, but it ran all weekend with no problems. But I've definitely got some
new things to consider if/when it starts having this problem again. Thanks.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sen
Hello,
We're developing .NET application (closed-source) and would like to include
pg_dump to allow users to perform "quick database backup" within main
application.
Two questions:
1. Do we need to include any dependent files besides pg_dump.exe ?
2. Are we in violation of PostgreSQL license if
On 3 dec., 01:18, [EMAIL PROTECTED] (Ron Johnson) wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 12/02/07 14:58, Usama Dar wrote:
>
>
>
> > On Dec 2, 2007 6:35 PM, rokj <[EMAIL PROTECTED]> wrote:
>
> >> Hi.
>
> >> For an example let me say that I have a big (over 1 million) user
>
Hi all,
I met a problem that it's slow to update all rows in a table. My
procedures are:
ALTER TABLE user ADD COLUMN foo smallint;
UPDATE user SET foo = 2;
ALTER TABLE user ALTER COLUMN foo SET NOT NULL;
ALTER TABLE user ALTER COLUMN foo SET DEFAULT 2;
The 2nd step took me 2600s. It's a simple
Using string concatenation in where clause causes huge perfomance loss:
explain analyze select
rid.toode
FROM dok JOIN rid USING (dokumnr)
JOIN toode USING (toode)
LEFT JOIN artliik using(grupp,liik)
WHERE rid.toode='NAH S'
AND dok.kuupaev BETWEEN '2007-11-01' AND '2007-12-04'
a
Would anyone be able to direct me as to whether or not there is a pgadmin
for windows utility available that will work for a PostgreSQL v7.0.3
database? I had installed the latest Pgadmin version 1.8 but it needs a
minimum of PostgreSQL v7.3 to work so I don't know what to do now. Would one
of the
Hi All,
Not sure if this is a slony issue or a postgres issue...I'm posting on
both.
I'm running slony on a one master/two subscriber system. One of the
subscribers seems to get stuck on a group of queries, and I can't seem
to figure out why. If I do a select on pg_stat_activity, I get the
foll
Hello,
I would like to ask you how to configure Pg to display messages in
italian instead of english.
I'm using PostgreSQL versione 8.1.8
For example, my pg display data as:
\d cani
Table "public.cani"
Column |Type
Hi every body
it is possible to force to postgresql to use a certain index? I know that
in mysql exits Force index (index_name) option for select queries
SELECT * FROM precalc FORCE INDEX (hladrb50101) ;
any of you have used this?
thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia C
Hi:
I'd like to know how PostgreSQL's transaction isolation mechanisms
interact with (e.g., UNIQUE) constraints. Section 12.2 of the manual
mentions that UPDATE, DELETE, SELECT FOR UPDATE, and SELECT FOR SHARE
commands may block when a concurrent transaction updates a target row
(for both isolati
initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data
gives this error
initdb: "en_CA.utf-8" is not a valid server encoding name
Thanks
josh
On Dec 3, 2007 1:01 PM, brian <[EMAIL PROTECTED]> wrote:
> Josh Harrison wrote:
> > Hi
> > Im tying to initialize the cluster using init
I recently encountered an interesting situation with regard to
partitioned tables, concurrent updates and deadlocks which probably
has an obvious explanation, although I can't seem to find one in the
manual. Below, I explain the situation and provide some of my own
naive reasoning about what seems
Hi,
I need help with designing a set of queries I am running with psql -f
reports.sql
I have a tb_master with report headers, tb_records table with it's own
serial field and foreign key referencing an "id" of tb_master. The third
tb_details table has two foreign keys referencing the "id"'s of
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
>
> Thanks to all the testing, feedback and bug reports the community has
> performed with the current betas, we now have our fourth beta
> of 8.4.
I assume you meant 8.3.
--
Bill Moran
http://www.potentialtech.com
-
Thanks to all the testing, feedback and bug reports the community has
performed with the current betas, we now have our fourth beta
of 8.4.
Due to continued testing by our community we have found performance
improvements, fixed bugs in PLperl and XML handling. We have also made
many documentation
On 3-Dec-07, at 3:51 PM, A.M. wrote:
On Dec 3, 2007, at 4:16 PM, Brian Wipf wrote:
We have a dual 3.0 GHz Intel Dual-core Xserve, running Mac OS X
10.5.1 Leopard Server and PostgreSQL 8.2.5. When we disconnect
several clients at a time (30+) in production, the CPU goes through
the roof and
On Tue, Dec 04, 2007 at 03:05:53PM -0500, John Wells wrote:
> So, given a database table file that still has records in it, and
> given the fact that these records could be parsed and displayed if the
> proper utilty knew how to read the various data structures used to
> denote field and record len
As a side note, there is actually a book on design patterns in SQL,
although I personally haven't read it. From the reviews I recall reading
about it, I think its mostly based on Oracle Features. Still might be a
good read as far as PostgreSQL is concerned except for the sections on
Graphs and r
On 12/4/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> Ah sorry, I though you meant de table was dropped or the database was
> deleted. If you actually ran a DELETE FROM on the table, then yes
> they'll all be marked deleted.
So, given a database table file that still has records in it,
On Tue, Dec 04, 2007 at 02:26:21PM -0500, John Wells wrote:
> Wow...interesting idea...but to clarify, I copied the table file
> *after* the delete was run on the table. Although the data appears to
> still be there, wouldn't they be marked as deleted in some way and not
> appear in the new table e
> This basically archives the data in the primary server
itself...right!!!
> But how can I set up continuous archiving from primary to a directory
> (WAL archive directory) on the stand-by server ?
The closest thing to a worked out example of how to do this I'm aware
of
is at http://archive
On 12/4/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> On Tue, Dec 04, 2007 at 03:38:16PM -0300, Alvaro Herrera wrote:
> > > So is it simply field width? Can one count the number of bytes based
> > > on native datatype length and determine field start/end?
> >
> > Yes. For variable length
John Wells wrote:
> On 12/4/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > John Wells wrote:
> > > On 12/4/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > > > There are no field separators. Perhaps you could extract some useful
> > > > info with pg_filedump, which you can grab at
> > > > http
Is there something like a freeware windows client app that does DBA
stuff for a remote server? Sort of like TOAD for Oracle?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erik Jones
Sent: Tuesday, December 04, 2007 1:34 PM
To: Konrad Neuwirth
Cc: Postgr
BTW:
Windows 2003 Server.
LOLL2=# SELECT version();
version
PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
(1 row)
Regards :)
Dan
LOLL2=# SELECT to_char('2007-12-31'::DATE, 'IW');
to_char
-
200701
(1 row)
2007-12-31 should be week 2008-01
regards,
Daniel.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, Dec 04, 2007 at 03:38:16PM -0300, Alvaro Herrera wrote:
> > So is it simply field width? Can one count the number of bytes based
> > on native datatype length and determine field start/end?
>
> Yes. For variable length types, there is a 4-byte length word at the
> start of the field (unle
On Tue, 4 Dec 2007, SHARMILA JOTHIRAJAH wrote:
This basically archives the data in the primary server itself...right!!!
But how can I set up continuous archiving from primary to a directory
(WAL archive directory) on the stand-by server ?
The closest thing to a worked out example of how to do
John Wells wrote:
> On 12/4/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > There are no field separators. Perhaps you could extract some useful
> > info with pg_filedump, which you can grab at
> > http://sources.redhat.com/rhdb
>
> So is it simply field width? Can one count the number of bytes
On Dec 4, 2007, at 11:17 AM, Konrad Neuwirth wrote:
Hello,
I have a hopefully simple question. I've found documentation about
the meanings of the various variables in postgres.conf -- if it comes
to memory consumption and buffer size. I've also found hints as to
making them too large decrease
On Dec 4, 2007 7:45 AM, Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to "x asasaxax" <[EMAIL PROTECTED]>:
>
> > Its just use a constraint then? there´s no problem id two sessions decrease
> > the number, and this number goes to less then or equals as zero?
> > I´m programming with php.
>
> B
On 12/4/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> There are no field separators. Perhaps you could extract some useful
> info with pg_filedump, which you can grab at
> http://sources.redhat.com/rhdb
So is it simply field width? Can one count the number of bytes based
on native datatype leng
John Wells wrote:
> I've been looking through the records with a hex editor, but the
> unfortunate thing is that I either don't see consistency with field
> separators or I'm overlooking them.
There are no field separators. Perhaps you could extract some useful
info with pg_filedump, which you c
Guys,
We had a bit of a misfortunate communication breakdown here at work,
which led to a particular database not being backed up. Before we
recognized this problem, and entire database table was deleted.
I immediately copied the pgdata directory and have been able to find
the file that represent
Hello,
I have a hopefully simple question. I've found documentation about
the meanings of the various variables in postgres.conf -- if it comes
to memory consumption and buffer size. I've also found hints as to
making them too large decreases performance. But -- how can I measure
how well the c
SHARMILA JOTHIRAJAH wrote:
Im trying to play a bit with log shipping between 2 servers primary
and standby. These servers are running versions 8.3betat3. I had set up
continuous archiving at the primary server. The manuals' example of
archive_command is
archive_command = 'cp -i %p /mnt/serve
> Im trying to play a bit with log shipping between 2 servers primary
and standby. These servers are running versions 8.3betat3. I had set up
continuous archiving at the primary server. The manuals' example of
archive_command is
> archive_command = 'cp -i %p /mnt/server/archivedir/%f
> This b
On Tue, Dec 04, 2007 at 10:11:04AM -0600, Glen W. Mabey wrote:
> Searching for DatumGetTextP from the search text box at the top of
> www.postgresql.org yields no hits, and a google search on DatumGetTextP
> does not seem to turnip [sic] any direct documentation on this function.
>
> Is there som
Pau Marc Munoz Torres wrote:
Hi every body
it is possible to force to postgresql to use a certain index? I know
that in mysql exits Force index (index_name) option for select queries
SELECT * FROM precalc FORCE INDEX (hladrb50101) ;
any of you have used this?
No. PostgreSQL will not allow
Hi every body
it is possible to force to postgresql to use a certain index? I know that
in mysql exits Force index (index_name) option for select queries
SELECT * FROM precalc FORCE INDEX (hladrb50101) ;
any of you have used this?
thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia
"Glen W. Mabey" <[EMAIL PROTECTED]> writes:
> On Tue, Dec 04, 2007 at 09:53:37AM -0600, Tom Lane wrote:
>> 3. You're not checking for a null, and the error check you do have
>> is wrong/redundant.
> The field is constrained to be NOT NULL, so I wasn't worried about
> checking that, but I don't see
On Tue, 04 Dec 2007 13:54:15 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Always go for the cleaner design. If it turns out that isn't fast
> enough, *then* start worrying about having a bad but faster design.
mmm yeah right. I did express myself badly.
What I mean I've first to know what a
On Tue, Dec 04, 2007 at 09:53:37AM -0600, Tom Lane wrote:
> "Glen W. Mabey" <[EMAIL PROTECTED]> writes:
> > Is there somewhere that I am not adequately checking for an error?
>
> 1. You're passing SPI_getbinval an uninitialized bool pointer.
Doh!
> 2. You're discarding its result, which you ne
SHARMILA JOTHIRAJAH wrote:
Hi,
Im trying to play a bit with log shipping between 2 servers primary and
standby. These servers are running versions 8.3betat3. I had set up continuous
archiving at the primary server. The manuals' example of archive_command is
archive_command = 'cp -i %p /mnt/serv
On Tue, Dec 04, 2007 at 09:26:46AM -0600, Glen W. Mabey wrote:
> On Tue, Dec 04, 2007 at 09:10:21AM -0600, Pavel Stehule wrote:
> > use macro DatumGetPointer(datum)
>
> When I do that, I get the following compiler warning:
>
> warning: assignment from incompatible pointer type
Well yes, you'
"Glen W. Mabey" <[EMAIL PROTECTED]> writes:
> Is there somewhere that I am not adequately checking for an error?
1. You're passing SPI_getbinval an uninitialized bool pointer.
2. You're discarding its result, which you need.
3. You're not checking for a null, and the error check you do have
i
Glen W. Mabey escribió:
> TriggerData *trigdata;
> Datum relative_filename_datum;
> text *relative_filename_t;
> int file_name_colnumber, ret;
> bool *isnull;
This is wrong. Try
bool isnull;
and later:
SPI_getbinval( trigdata->tg_trigtuple, trigdata->tg_rel
On Tue, Dec 04, 2007 at 09:10:21AM -0600, Pavel Stehule wrote:
> use macro DatumGetPointer(datum)
When I do that, I get the following compiler warning:
warning: assignment from incompatible pointer type
which is what originally motivated me to look for another means, which
led me to use PG_D
On 04/12/2007, Glen W. Mabey <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have been trying to write a trigger in C operating on each row
> that would (as a first step) copy a field of type TEXT into a text*
> variable.
>
> I think that I've got the SPI_connect, SPI_fnumber, and SPI_getbinval
> calls c
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > On Tue, 04 Dec 2007 08:14:56 +
> > Richard Huxton <[EMAIL PROTECTED]> wrote:
> >
> >> Unless it's an obvious decision (millions of
> small identical
> >> queries vs. occasional large complex ones) then
> you'll ha
Hi,
Im trying to play a bit with log shipping between 2 servers primary and
standby. These servers are running versions 8.3betat3. I had set up continuous
archiving at the primary server. The manuals' example of archive_command is
archive_command = 'cp -i %p /mnt/server/archivedir/%f http://tools
Hello,
I have been trying to write a trigger in C operating on each row
that would (as a first step) copy a field of type TEXT into a text*
variable.
I think that I've got the SPI_connect, SPI_fnumber, and SPI_getbinval
calls correct, but this gives me a Datum.
How do I convert a Datum to a tex
On 02/12/2007 13:02, Michelle Konzack wrote:
with 42 PostgreSQL servers of each 1,8 TByte.
Wow! Who ever said size wasn't everything :-)
Would you be willing to tell us a little about your hardware and
software set-up?
Also, are the servers running separate databases? - or is it one
w
Ivan Sergio Borgonovo wrote:
On Tue, 04 Dec 2007 08:14:56 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
Unless it's an obvious decision (millions of small identical
queries vs. occasional large complex ones) then you'll have to
test. That's going to be true of any decision like this on any
sy
In response to "x asasaxax" <[EMAIL PROTECTED]>:
> Its just use a constraint then? there´s no problem id two sessions decrease
> the number, and this number goes to less then or equals as zero?
> I´m programming with php.
BEGIN;
SELECT quantity FROM products WHERE productid=[productid] FOR UPDATE
Am 2007-11-29 12:50:58, schrieb Willy-Bas Loos:
> Hi,
>
> Is it possible to run one PostgreSQL cluster on more than one (hardware)
> server?
Yes of course... I run at a customer "Monster"
with 42 PostgreSQL servers of each 1,8 TByte.
Thanks, Greetings and nice Day
Michelle Konzack
Tamay
Efraín López wrote:
> I am using Windows, and pg 8.2.5
>
> When making a connection with libpq, if it fails I would like
> to get the errors messages in spanish (PQerrorMessage )
>
> Is this possible? How can this be done?
Set the program's locale prior to calling libpq functions.
I did not
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Tue, Dec 4, 2007 at 12:21 PM, in message
<[EMAIL PROTECTED]>, "A. Kretschmer"
<[EMAI
am Tue, dem 04.12.2007, um 12:05:41 +0100 mailte Christian Rengstl folgendes:
> >> a have a problem using the following archiving command on windows:
> >> 'copy %p C:\\Archive\\DBArchive\\%f'
> >
> > According the doc, the command should be:
> >
> > archive_command = 'copy "%p" /mnt/server/archi
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Tue, Dec 4, 2007 at 12:03 PM, in message
<[EMAIL PROTECTED]>, "A. Kretschmer"
<[EMAI
am Mon, dem 03.12.2007, um 12:29:39 +0100 mailte Christian Rengstl folgendes:
> Hi list,
>
> a have a problem using the following archiving command on windows:
> 'copy %p C:\\Archive\\DBArchive\\%f'
According the doc, the command should be:
archive_command = 'copy "%p" /mnt/server/archivedir/"%
Il Tuesday 04 December 2007 11:50:21 Peter Eisentraut ha scritto:
> Am Dienstag, 4. Dezember 2007 schrieb Reg Me Please:
> > Is there a way to "suspend" the index updates and the constraint checks
> > before the inserts in order to later re-enable them and do a reindex?
>
> You can disable foreign-
Its just use a constraint then? there´s no problem id two sessions decrease
the number, and this number goes to less then or equals as zero?
I´m programming with php.
Thanks
2007/12/3, Cesar Alvarez <[EMAIL PROTECTED]>:
>
> What are you programing with?.
> are you using npgsql?
>
> Regards Cesa
On Tue, Dec 04, 2007 at 10:09:06AM +0100, Reg Me Please wrote:
> Is there a way to "suspend" the index updates and the constraint checks
> before the inserts in order to later re-enable them and do a reindex?
You can defer foreign key checks and possibly constraints, but unique
index checks can't
Am Dienstag, 4. Dezember 2007 schrieb Reg Me Please:
> Is there a way to "suspend" the index updates and the constraint checks
> before the inserts in order to later re-enable them and do a reindex?
You can disable foreign-key constraints (see ALTER TABLE ... DISABLE TRIGGER;
not quite obvious, b
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Tue, Dec 4, 2007 at 11:44 AM, in message
<[EMAIL PROTECTED]>, "A. Kretschmer"
<[EMAI
Am Dienstag, 4. Dezember 2007 schrieb Louis-David Mitterrand:
> While upgrading from 8.3-beta3 to beta4, postgres complained that the
> database format was not supported. I had to restore from backup.
>
> Was that intended?
Yes
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
--
am Tue, dem 04.12.2007, um 11:31:41 +0100 mailte Christian Rengstl folgendes:
> When I login as user postgres, I can copy the files without any
> problem.
> Here is the error message (translated as it appears in German in my log
> files):
> >>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< faile
On Tue, 04 Dec 2007 08:14:56 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Unless it's an obvious decision (millions of small identical
> queries vs. occasional large complex ones) then you'll have to
> test. That's going to be true of any decision like this on any
> system.
:(
I'm trying to
When I login as user postgres, I can copy the files without any
problem.
Here is the error message (translated as it appears in German in my log
files):
>>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
1
>>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
1
Josh,
However, the two extra cores (even if slower), will greatly help if you
> have any kind of concurrency.
>
as much as I understand with running Postgres in the default configuration,
there *will* be concurrency, without an "if" ?
I am thinking of the background writer, the autovacuum proces
1 - 100 of 104 matches
Mail list logo