hi,
what is the maximum amount of data to be written in checkpoint?
i always assumed this to be shared_buffers.
but some last tests show it to be much more. what am i missing?
best regards,
depesz
--
quicksil1er: postgres is excellent, but like any DB it requires a
highly paid DBA. here's
Tom Hart wrote:
Originally I set up the database to use ASCII encoding. However we
have a large base of Spanish speaking members and services,
and we need utf-8 encoding to maintain and support the extended character
sets. In my naivety I thought it would be a relatively simple process
to
On Wed, 23 Jan 2008, Tom Hart wrote:
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
for encoding UTF8: 0xc52f
Try editing your dump-file and change the line which reads SET
client_encoding = 'SQL_ASCII'; to SET client_encoding = 'LATIN1';
I tried making the
On Thu, 2008-01-24 at 11:21 +0100, hubert depesz lubaczewski wrote:
what is the maximum amount of data to be written in checkpoint?
i always assumed this to be shared_buffers.
but some last tests show it to be much more. what am i missing?
Fsync will flush all outstanding writes, so you
On Jan 23, 2008 11:07 PM, Greg Smith [EMAIL PROTECTED] wrote:
On Wed, 23 Jan 2008, Roberto Scattini wrote:
the problem that im having is that i have A LOT of
archive files on pg_xlog dir, and thats because the archive_command
keeps failing (the standby server had filled his disk with
hi,
i am new to this postgre, i m running postgre under windows server 2003.
postgres stores the database/data in the directory C:\Program
Files\PostgreSQL\8.2\data by default. i want to change this directory to some
other drive. is it posible to do this without comand prompt. if it is not then
On 24/01/2008 13:02, User Map wrote:
i am new to this postgre, i m running postgre under windows server 2003.
postgres stores the database/data in the directory C:\Program
Files\PostgreSQL\8.2\data by default. i want to change this directory
to some other drive. is it posible to do this
As for the real problem (on the same hardware), when you rebuilt
Postgres on your new machine did you change any of the configure
options that MacPorts would have used from what would have been used
previously (I assume they can be overridden)?
There's not that much that can be overridden that
Hi list, I was looking for a bit of clarification on a check
constraint that I have on some tables.
I was following the example in the partitioning documentation
http://www.postgresql.org/docs/8.2/interactive/ddl-partitioning.html
And got it to work, but when I tried to apply the same idea to
I have a couple of servers running Postfix with amavisd-maia+SA+clamav
on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My
issue is the bayes database causing SA TIMED OUT in the logs and want to
make sure I am getting everything into memory. The disk activity is high
on the db
On Jan 24, 2008, at 6:09 AM, Roberto Scattini wrote:
On Jan 23, 2008 11:07 PM, Greg Smith [EMAIL PROTECTED] wrote:
On Wed, 23 Jan 2008, Roberto Scattini wrote:
the problem that im having is that i have A LOT of
archive files on pg_xlog dir, and thats because the archive_command
keeps
On doing the following in comand prompt
C:\program files\postgresql\8.2\bin initdb -D C:\confc
it says
the program postgres is neded by initdb but was not found in the
same directory as C:\program files\postgresql\8.2\bin/initdb. check
your installation.
if i use:
root# mkdir
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
I have a couple of servers running Postfix with amavisd-maia+SA+clamav
on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My
issue is the bayes database causing SA TIMED OUT in the logs and want to
make sure I am getting
Tim Rupp [EMAIL PROTECTED] writes:
... a bunch of inherited tables that have the following constraint
CHECK (start_time = '2008-01-01'::date AND end_time '2008-01-01'::date)
and when i do the same query (as in the documentation) on the table, I
get a bunch of sequential scans in the
Stefan Schwarzer [EMAIL PROTECTED] writes:
After running initdb the postmaster started smoothly. I stopped it,
copied my database files into the same location, started the
postmaster again, and then got this error message:
schwarzers-mac-mini:/usr/local/pgsql schwarzer$
hi,
i am new to this postgre, i m running postgre under windows server 2003.
postgres stores the database/data in the directory C:\Program
Files\PostgreSQL\8.2\data by default. i want to change this directory to some
other drive. is it posible to do this without comand prompt. if it is not then
On Jan 24, 2008, at 4:41 PM, Tom Lane wrote:
Stefan Schwarzer [EMAIL PROTECTED] writes:
After running initdb the postmaster started smoothly. I stopped it,
copied my database files into the same location, started the
postmaster again, and then got this error message:
Stefan Schwarzer [EMAIL PROTECTED] writes:
When I start the postmaster it seems ok. But there is no process
running.
Then it didn't really start successfully. (Unless you use the -w
option, pg_ctl start just launches the postmaster --- it doesn't
wait around to see what happens.) You need
Hi,
To constraint unique'ness of my visitors to a 24h periode I tried
created a index including the 'date' part of the created_on timestamp:
CREATE UNIQUE INDEX visit_idx ON visit_buffer USING btree (id_session,
id_story, created_on::date);
psql:visit_pkey.sql:5:
When I start the postmaster it seems ok. But there is no process
running.
Then it didn't really start successfully. (Unless you use the -w
option, pg_ctl start just launches the postmaster --- it doesn't
wait around to see what happens.) You need to look into the log
file to see what the
All:
Are there any frameworks / toolkits available, possibly as established
F/OSS projects, for web applications using PHP+PostgreSQL?
sf.net/google comes up short -- a few XML services and Perl+PgSQL hits.
By 'application server', as a marketing wank-word gleaned from
Oracle/IBM/BEA,
All:
Are there any frameworks / toolkits available, possibly as established
F/OSS projects, for web applications using PHP+PostgreSQL?
sf.net/google comes up short -- a few XML services and Perl+PgSQL hits.
By 'application server', as a marketing wank-word gleaned from
Oracle/IBM/BEA,
On Jan 24, 2008 9:47 AM, Tom Lane [EMAIL PROTECTED] wrote:
Tim Rupp [EMAIL PROTECTED] writes:
... a bunch of inherited tables that have the following constraint
CHECK (start_time = '2008-01-01'::date AND end_time '2008-01-01'::date)
and when i do the same query (as in the documentation)
I am trying to install PostgreSQL from 'postgresql-8.3-dev1.exe', but the
installation terminates with an error message saying that it could not
create a file,
Here is the last bit of 'postgresql-8.3-dev1.txt', it just might mean
something to you 'cos it does not mean anything to me.
On Thu, Jan 24, 2008 at 05:10:51PM +0100, Stefan Schwarzer wrote:
Oh, stupid me! Gush, I'll never learn it...
But nevertheless:
When I start the postmaster it seems ok. But there is no process
running. When I try to stop it it says:
pg_ctl: PID file
1) Verify your TMP and TEMP environment variables (values must
reference valid directory entries);
It was confirmed and no problem
2) Is there sufficient disk space for extract files from the
PostgreSQL package into TMP and TEMP path reference on the environment
vars?
Yes.
3) Also
On Thu, 24 Jan 2008, Erik Jones wrote:
To disable archiving, set archive_command=, commenting it out won't
change it...However, commenting a config is not necessarily equivalent
to disabling something.
This is actually a problem that is corrected in the upcoming 8.3 release.
From those
Seems like it would be a common question, but I'm having problems finding an
answer in the archives on this...
I have a large database (now about 2 billion records), and about once a year
I have been dropping and recreating the indexes. Recreating the foreign key
constraints takes as long or
Louis
what if you create one wrapper function immutable?
some thing like this.
CREATE OR REPLACE FUNCTION myextract(timestamp )
RETURNS date AS
$BODY$
BEGIN
return extract(date from $1) ;
END;
$BODY$
LANGUAGE 'plpgsql' IMMUTABLE
best regards
mdc
--- Louis-David Mitterrand
Sorry forgot to mention
later try
CREATE UNIQUE INDEX visit_idx ON visit_buffer(
id_session, id_story ,myextract(created_on));
best regards
Louis
what if you create one wrapper function
immutable?
some thing like this.
CREATE OR REPLACE FUNCTION myextract(timestamp )
RETURNS
On Jan 24, 2008, at 12:15 PM, Brian A. Seklecki wrote:
Are there any frameworks / toolkits available, possibly as established
F/OSS projects, for web applications using PHP+PostgreSQL?
sf.net/google comes up short -- a few XML services and Perl+PgSQL
hits.
By 'application server', as a
i agree and if your postgres data folder will be constant I would set PGDATA
environment variable to the folder location
M-
- Original Message -
From: Raymond O'Donnell [EMAIL PROTECTED]
To: User Map [EMAIL PROTECTED]
Cc: pgsql pgsql-general@postgresql.org
Sent: Thursday, January 24, 2008
On Jan 24, 2008 5:28 PM, Jamiil Abduqadir [EMAIL PROTECTED] wrote:
I am trying to install PostgreSQL from 'postgresql-8.3-dev1.exe', but the
installation terminates with an error message saying that it could not
create a file,
Here is the last bit of 'postgresql-8.3-dev1.txt ', it just might
Wes [EMAIL PROTECTED] writes:
I'm running 8.1.4. Assume I have exclusive access to the DB.
You really ought to update to 8.1.something-newer, but I digress.
1. Is there any advantage to doing the DROP/CREATE over just doing a REINDEX
DATABASE.
No, not if you don't mind exclusive locks.
Hello - Typically case of a software guy needing to spec hardware for a
new DB server. Further typified case of not knowing exact amount of data
and I/O patterns. So if you were to spec a disk system for a new general
purpose PostgreSQL server any suggestions of what to start with?
Details I
On Thu, 2008-01-24 at 10:46 -0500, Bill Moran wrote:
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
How can I tell if PgSQL is using memory or not and
how much?
Well, top is helpful. Also, consider installing the pg_buffercache addon
so you can see how much of your shared_buffers
I'm getting the following error, and I think it's because when i insert into
postgres from geoserver's WFS, i first delete then insert the track, and
geoserver does this in succession but very fast. If I personally test
inserting two tracks with the same guid in a row, then it works, but because
On Jan 24, 2008 10:41 AM, Stefan Schwarzer
[EMAIL PROTECTED] wrote:
When I start the postmaster it seems ok. But there is no process
running.
Then it didn't really start successfully. (Unless you use the -w
option, pg_ctl start just launches the postmaster --- it doesn't
wait around
On 1/24/08 12:48 PM, Tom Lane [EMAIL PROTECTED] wrote:
Wes [EMAIL PROTECTED] writes:
I'm running 8.1.4. Assume I have exclusive access to the DB.
You really ought to update to 8.1.something-newer, but I digress.
I was planning on upgrading to 8.x at the same time as this reindex - just
do
Robert Fitzpatrick wrote:
I have a couple of servers running Postfix with amavisd-maia+SA+clamav
on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My
issue is the bayes database causing SA TIMED OUT in the logs and want to
make sure I am getting everything into memory. The disk
On Thu, Jan 24, 2008 at 05:41:20PM +0100, Stefan Schwarzer wrote:
What would you recommend now in order to get the data back? I have
postgis data in the databases too, although this is not too important
for me...
pg_dump, pg_dumpall...
Have a nice day,
--
Martijn van Oosterhout [EMAIL
Brian A. Seklecki (Mobile) wrote:
*) A row-level / user-level ('view based') object security model
I haven't looked into it much but SE-PostgreSQL may be an option for
this step - if not you may find their explanations of how they implement
row level security to be inspiration.
is there a way to close the connection in postgres after i insert something?
On Jan 24, 2008, at 11:21 AM, Nathan Wilhelmi wrote:
Hello - Typically case of a software guy needing to spec hardware
for a new DB server. Further typified case of not knowing exact
amount of data and I/O patterns. So if you were to spec a disk
system for a new general purpose PostgreSQL
On Jan 24, 2008, at 12:36 PM, Dominique Bessette - Halsema wrote:
I'm getting the following error, and I think it's because when i
insert into postgres from geoserver's WFS, i first delete then
insert the track, and geoserver does this in succession but very
fast. If I personally test
On Jan 24, 2008 4:30 PM, Greg Smith [EMAIL PROTECTED] wrote:
On Thu, 24 Jan 2008, Erik Jones wrote:
To disable archiving, set archive_command=, commenting it out won't
change it...However, commenting a config is not necessarily equivalent
to disabling something.
This is actually a
On Thursday 24 January 2008, Nathan Wilhelmi [EMAIL PROTECTED] wrote:
Hello - Typically case of a software guy needing to spec hardware for a
new DB server. Further typified case of not knowing exact amount of data
and I/O patterns. So if you were to spec a disk system for a new general
On Jan 24, 2008 1:08 PM, Dominic Carlucci [EMAIL PROTECTED] wrote:
Hi,
We have a center in Europe who has just started to use PostgreSQL and
was asking me if there are any Symantec product or other products that
backup this type of database. We presently run VERITAS ver9.1 on
Dominique Bessette - Halsema [EMAIL PROTECTED] wrote:
is there a way to close the connection in postgres after i insert something?
The short answer is yes.
In order to provide a more detailed answer, I suspect you're going to have
to provide a little more context ... are you writing a C
We have a center in Europe who has just started to use PostgreSQL and was
asking me if there are any Symantec product or other products that backup
this type of database.
It doesn't appear to. I've just been through the whole rigmarole of
BackupExec for some Windows Servers, and I couldn't
I'm http posting postgres from my wfs. in otherwords i'm postgres is my
datastore and i'm posting xml to it. so do you know how to close it in xml?
On 1/24/08, Bill Moran [EMAIL PROTECTED] wrote:
Dominique Bessette - Halsema [EMAIL PROTECTED] wrote:
is there a way to close the connection
64 bit?
http://www.postgresql.org/docs/8.2/interactive/install-procedure.html
M-
- Original Message -
From: Nathan Wilhelmi [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, January 24, 2008 2:21 PM
Subject: [GENERAL] Disk configurations
Hello - Typically case of
On Jan 24, 2008, at 3:47 PM, Dominique Bessette - Halsema wrote:
is there a way to close the connection in postgres after i insert
something?
Of course. Exactly how will be dependent on what you're using to
access the db (language/framework-wise).
Erik Jones
DBA | Emma®
[EMAIL
- Original Message -
From: Nathan Wilhelmi [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, January 24, 2008 2:21 PM
Subject: [GENERAL] Disk configurations
Hello - Typically case of a software guy needing to spec hardware for a
new DB server. Further
I'm currently seeing more and more problems with vacuum as the DB size
gets bigger and bigger. (~220GB+)
Bear in mind that I'm working on a fairly big DB with unfairly sized
hardware (Celeron 1.7G, 2x500G Raid1 dbspace1, 1x500Gb dbspace2, 1x80G
system, 768MB Ram, 2G Swap on dspace2)
IO is main
The client for a web application I'm working on wants certain URLs to
contain the full names of members (SEO-friendly links). Scripts would
search on, say, a member directory entry based on the name of the
member, rather than the row ID. I can easily join first last names
with an underscore
Louis-David Mitterrand [EMAIL PROTECTED] writes:
CREATE UNIQUE INDEX visit_idx ON visit_buffer USING btree (id_session,
id_story, created_on::date);
psql:visit_pkey.sql:5: ERROR: syntax error at or near ::
The reason that didn't work is that you need parentheses around an
57 matches
Mail list logo
