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 arou
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
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 bo
> - Original Message -
> From: "Nathan Wilhelmi" <[EMAIL PROTECTED]>
> To:
> 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 typified 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 PROTECT
64 bit?
http://www.postgresql.org/docs/8.2/interactive/install-procedure.html
M-
- Original Message -
From: "Nathan Wilhelmi" <[EMAIL PROTECTED]>
To:
Sent: Thursday, January 24, 2008 2:21 PM
Subject: [GENERAL] Disk configurations
> Hello - Typically case of a software guy needing 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
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
> 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 f
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 actu
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
> p
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 ins
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
is there a way to close the connection in postgres after i insert something?
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.
http://code
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 <[EMA
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 ac
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
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
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
g
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 shar
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 h
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.
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
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"
Sent: Thursday, January 24, 2008 8:18 AM
Subject: R
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 mar
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 )
>
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
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 long
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 re
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) Als
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 "/usr/local/pgsql/data/postm
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.
Property(C
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
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, essentiall
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, essentiall
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 pro
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 n
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: ERROR:
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:
schwarzers-mac-mini:/
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 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$ /usr/lo
"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 th
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
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 /
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 faili
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 ser
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 my
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 w
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 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 the
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 w
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 .
>
> but some last tests show it to be much more. what am i missing?
Fsync will flush all outstanding writes, so you probably ha
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 trie
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
> t
hi,
what is the maximum amount of data to be written in checkpoint?
i always assumed this to be .
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 my CV!" :)
http
57 matches
Mail list logo
