On Wed, 2007-09-19 at 19:31 +0800, Ow Mun Heng wrote:
> On Wed, 2007-09-19 at 11:05 +0100, Filip Rembiałkowski wrote:
> > 2007/9/19, Ow Mun Heng <[EMAIL PROTECTED]>:
> >
> > (...)
> >
> > > simulate a delete
> > > => delete from parent where id in (select id from child);
> > > DELETE 6
> > >
> >
am Thu, dem 20.09.2007, um 14:13:40 +1000 mailte Chester folgendes:
> Hi
>
> I have a question regarding foreign keys, I just cannot get it to create
> them for meI must be doing something wrong but I have no idea what
> that might be :)
>
> I have a table "clients"
>
> clientID (primary)
Michael Glaesemann wrote:
On Sep 19, 2007, at 23:13 , C wrote:
ERROR: insert or update on table "clients" violates foreign key
constraint "the_title"
DETAIL: Key (ticode)=( ) is not present in table "titles".
Sorry, I have no idea where I am going wrong...Any help would be great
You've
On Sep 19, 2007, at 23:13 , Chester wrote:
ERROR: insert or update on table "clients" violates foreign key
constraint "the_title"
DETAIL: Key (ticode)=( ) is not present in table "titles".
Sorry, I have no idea where I am going wrong...Any help would be
great
You've shown us the error
Hi
I have a question regarding foreign keys, I just cannot get it to create
them for meI must be doing something wrong but I have no idea what
that might be :)
I have a table "clients"
clientID (primary)
ticode
Firstname
SecondName
I have a second table "titles"
ticode (primary)
Title
I'm using 8.1 RPMs for CentOS and so far, it's been great.
Now, I'm going to enable SSL. I had no trouble with the instructions on the
documentation for server-only certificates, and verified that psql (Linux)
acknowledges the SSL connection.
But I am stumped as to how to create a client cert
Hi,
Can anyone please advise on the steps that can be followed to start a
Postgresql based database firm? I expect guidelines on the use of Postgresql
resources and on ways to maintain relationship with the Postgresql
community.
Thanks,
Gokul.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Martin Gainty
> Sent: Tuesday, September 19, 2000 5:58 PM
> To: johnf; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Building Windows fat clients
>
>
> Hello Guys
>
> Using C# means .NET fr
Hi.
pgAdminIII uses pg_restore by restoration. Then, pg_restore does not recognize a PlainText
format.
Please use psql from a command line...
Regards,
Hiroshi Saito
- Original Message -
From: [EMAIL PROTECTED]
I have a backup file from Postgresql 8.1.4. When I try to use 8.2.5 pg_
Hello - Several people kindly responded directly to me with some
specific suggestions for this, however the message was mistakenly
deleted and not in the archives. If you remember who you are and
wouldn't mind resending that would be fantastic!
Thanks!
-Nate
Hello - Just installed 8.2.4 on a
I have a backup file from Postgresql 8.1.4. When I try to use 8.2.5
pg_restore the restore doesn't recognize the archive format. The archive
file was made with the command below. Is there a way to get 8.2.5 to
recognize the file, or a way to run the file as a script from a different
program lik
On 19/09/2007, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote:
> here you are, all posts from this thread are below.
>
> BTW, what happened to the archives?
sorry nothing happened... I mixed it up :|
Nathan, your post is there...
http://archives.postgresql.org/pgsql-general/2007-08/msg00534.php
-
2007/9/19, Nathan Wilhelmi <[EMAIL PROTECTED]>:
> Hello - Several people kindly responded directly to me with some
> specific suggestions for this, however the message was mistakenly
> deleted and not in the archives. If you remember who you are and
> wouldn't mind resending that would be fantastic
[EMAIL PROTECTED] ("Bima Djaloeis") writes:
> Hi there,
> I am new to PostgreSQL, is it possible to create something so that
> 1) If I insert / update / delete an item from my DB...
> 2) ... an awk / shell / external program is executed in my UNIX System?
> If yes, how do I do this and if no, thank
Hello Guys
Using C# means .NET framework will need to be installed and your webapp will
only work with Microsoft OS
Be aware scripting languages such as PHP and Python will necessitate that
you acquire all of the libraries for your web app..
As long as you stay mainstream you should be ok
But
On Wednesday 19 September 2007 10:19, Scott Ribe wrote:
> I'm asking this group because we tend to think alike wrt to data modeling
> and separation of concerns ;-)
>
> Any recommendations on ORM libraries for new Windows development? The last
> time I started anything from scratch was over 10 year
Ok, thx for the advice :)
BTJ
On Wed, 19 Sep 2007 10:51:57 -0700
Jeff Davis <[EMAIL PROTECTED]> wrote:
> On Wed, 2007-09-19 at 15:32 +0200, Bjørn T Johansen wrote:
> > > > Well, it isn't really the largest database or the database that
> > > > need the most performance... At the moment, the
> This suggsts your init script is broken. You ought to be able to
> test whether postgres will run properly by setting PGDATA correctly,
> and then running /path/to/pg8.x/bin/pg_ctl start. Whether postgres
> will run is not exactly the same question as whether your init script
> is correct.
The
On Wed, 2007-09-19 at 15:32 +0200, Bjørn T Johansen wrote:
> > > Well, it isn't really the largest database or the database that
> > > need the most performance... At the moment, the database isn't
> > > larger than 15MB and is growing slowly... It is a webapp that is
> >
> > That'll fit in shared
I'm asking this group because we tend to think alike wrt to data modeling
and separation of concerns ;-)
Any recommendations on ORM libraries for new Windows development? The last
time I started anything from scratch was over 10 years ago, and the "state
of the art" seemed to be to smash everythin
On Wed, Sep 19, 2007 at 08:52:29AM -0700, [EMAIL PROTECTED] wrote:
>
> When the system boots there is a FAILED error when the server tries to
> load postgresql8.
>
> If I manually run
> /etc/rc.d/init.d/postgresql8 start
> the message is
> standard in must be tty
>
On Sep 19, 2007, at 11:00 AM, Richard Broersma Jr wrote:
--- Erik Jones <[EMAIL PROTECTED]> wrote:
Also, note that once we have HOT...
I am not sure what the acronym "HOT" stands for. Does it have
something to do with MVCC?
Heap Only Tuple. Here's a link to the (latest?) readme for i
[EMAIL PROTECTED] wrote:
I want to know about the size of my database. For example, I want to know
how many Mb of data for current myDatabase database in a postgres server.
SELECT pg_size_pretty(pg_database_size(current_database()));
-- Dante
---(end of broadcast)-
prueba1=# select to_tsvector('espanol','melón perro mordelón');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
Hmm, can y
Another way is to remember that NULL is a distinguished thing that is
absence of a value, not any value of any type, and this applies to all
types:
- the integer 0 is a value, not null
- the date 1/1/1900 (or 1904 or ) is a value, not null
- the time 00:00:00 is a value, not null
- and the str
--- Erik Jones <[EMAIL PROTECTED]> wrote:
> Also, note that once we have HOT...
I am not sure what the acronym "HOT" stands for. Does it have something to do
with MVCC?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget
>>On Tue, Sep 18, 2007 at 03:06:32PM -0700, [EMAIL PROTECTED]
wrote:
>> account and the system's knowledge of the posgresql 8.1.4 software.
The
>> system will no longer run 8.1.4 even when I go to the /bin/ to run the
>> commands. The data is still present and so is the 8.1.4 software. I
rema
On Sep 19, 2007, at 10:30 AM, Richard Broersma Jr wrote:
Not quite. Once a page has reached it's fill factor percentage full,
no more inserts will happen on that page, only updates. Also, I
think you have large/small backwards wrt fill factor. If you have a
fill factor of, say, 40% then onc
Bjørn T Johansen <[EMAIL PROTECTED]> writes:
> It's a Dell server with the following spec:
>
> PE2950 Quad-Core Xeon E5335 2.0GHz, dual
> 4GB 667MHz memory
> 3 x 73GB SAS 15000 rpm disk
> PERC 5/I Integrated controller card (8 ports, 256MB cache, battery backup) x
> 6 backplane
>
> Is this ok to
On Sep 19, 2007, at 5:36 AM, [EMAIL PROTECTED] wrote:
I want to know about the size of my database. For example, I want
to know
how many Mb of data for current myDatabase database in a postgres
server.
If you don't need an exact size, this query will be a lot faster than
the size functions
Well, it isn't really the largest database or the database that need the most
performance... At the moment, the
database isn't larger than 15MB and is growing slowly... It is a webapp that is
using the database and at the most
(at the moment) there is about 12-14 concurrent users and not much dat
--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> 2. Is this fill factor enough to have on the table, or should I also
> do a fill factor for specific indexes? Or both the table and the
> index? (I have four btree indexes on the table)
I don't think that fill factor can be applied to the table. The
On Sep 19, 2007, at 6:30 AM, Bjørn T Johansen wrote:
It's a Dell server with the following spec:
PE2950 Quad-Core Xeon E5335 2.0GHz, dual
4GB 667MHz memory
3 x 73GB SAS 15000 rpm disk
PERC 5/I Integrated controller card (8 ports, 256MB cache, battery
backup) x 6 backplane
RAID5 is not a reci
> Not quite. Once a page has reached it's fill factor percentage full,
> no more inserts will happen on that page, only updates. Also, I
> think you have large/small backwards wrt fill factor. If you have a
> fill factor of, say, 40% then once a page has reached 40% full no
> more inser
Hi, you have forgot to note some very important information - what load do you
expect and what is the size of the database? Is this an upgrade (is the
database already running somewhere - this would give you some performance
requirements) or is it a completely new database? Hom nay users / transact
On Sep 19, 2007, at 9:29 AM, Richard Broersma Jr wrote:
--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
Then I am confused again about how the fill factor stuff works. Let's
say I have a table with four BTREE indexes. Should all of them have a
fill factor of about 60 (lower than the default 90, t
Phoenix Kiula wrote:
> Then I am confused again about how the fill factor stuff works. Let's
> say I have a table with four BTREE indexes. Should all of them have a
> fill factor of about 60 (lower than the default 90, that is) to be
> effective? Or will it help if I lower the fill factor on only a
On 9/18/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> On Tue, 2007-09-18 at 09:55 -0500, Scott Marlowe wrote:
> > On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >
> > > Just wondering how everyone is doing aggregration of production data.
> >
> > Where I work, we aggregate by the minute in the
On 9/19/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> On 09/19/07 08:32, Bjørn T Johansen wrote:
> > On Wed, 19 Sep 2007 07:59:36 -0500
> >>
> >> Am I so old that (even accepting Tomcat and Java) that seems
> >> "excessive"?
> >
> > Yes, I think that it's a bit excessive but the company can afford i
On Wed, Sep 19, 2007 at 09:10:43AM -0500, Walter Roeland wrote:
> Dave,
>
> For the reasons you mention for using pg_ctl -w, it seemed to me the wisest
> option to recreate the postgres database. After the normal startup messages,
> the following error appears once in the log:
>
> 127.0.0.1 pos
--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> Then I am confused again about how the fill factor stuff works. Let's
> say I have a table with four BTREE indexes. Should all of them have a
> fill factor of about 60 (lower than the default 90, that is) to be
> effective? Or will it help if I lower
On Wed, Sep 19, 2007 at 03:02:26PM +0200, Patricia Rodriguez Tome wrote:
> Hello
> I have installed without problem 8.2.4, but I must have missed something
> in my pg_hba.conf file.
> I want all users, from anywhere even the local host, to connect using a
> password.
Did you reload the postmaste
Dave,
For the reasons you mention for using pg_ctl -w, it seemed to me the wisest
option to recreate the postgres database. After the normal startup messages,
the following error appears once in the log:
127.0.0.1 postgres postgres FATAL: the database system is starting up
I assume that this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/07 08:32, Bjørn T Johansen wrote:
> On Wed, 19 Sep 2007 07:59:36 -0500
> Ron Johnson <[EMAIL PROTECTED]> wrote:
>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 09/19/07 07:33, Bjørn T Johansen wrote:
>>> Well, it isn't really t
Hello
I have installed without problem 8.2.4, but I must have missed something
in my pg_hba.conf file.
I want all users, from anywhere even the local host, to connect using a
password.
So I did:
# my pg_hba file
local all all md5
# IPv4 local connections:
On Wed, 19 Sep 2007 07:59:36 -0500
Ron Johnson <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 09/19/07 07:33, Bjørn T Johansen wrote:
> > Well, it isn't really the largest database or the database that
> > need the most performance... At the moment, the databa
Sorry, forget my previous question.
holidays have slowed my brain ... I have a .pgpass file under that user
...
oups ;)
p.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Bjørn T Johansen wrote:
It's a Dell server with the following spec:
PE2950 Quad-Core Xeon E5335 2.0GHz, dual
4GB 667MHz memory
3 x 73GB SAS 15000 rpm disk
PERC 5/I Integrated controller card (8 ports, 256MB cache, battery backup) x 6
backplane
Is this ok to run PostgreSQL 8.2.x and Tomcat o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/07 06:30, Bjørn T Johansen wrote:
> It's a Dell server with the following spec:
>
> PE2950 Quad-Core Xeon E5335 2.0GHz, dual
> 4GB 667MHz memory
> 3 x 73GB SAS 15000 rpm disk
> PERC 5/I Integrated controller card (8 ports, 256MB cache, batte
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/07 07:33, Bjørn T Johansen wrote:
> Well, it isn't really the largest database or the database that
> need the most performance... At the moment, the database isn't
> larger than 15MB and is growing slowly... It is a webapp that is
That'll fi
On 19/09/2007, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> --- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
>
> > 2. Is this fill factor enough to have on the table, or should I also
> > do a fill factor for specific indexes? Or both the table and the
> > index? (I have four btree indexes on the t
>>I want to know about the size of my database. For example, I want to know
>>how many Mb of data for current myDatabase database in a postgres server.
>>How I can do that?
Try the following query:
select pg_size_pretty(pg_database_size(''));
--Farhan
- Original Message
From: "[EMA
am Wed, dem 19.09.2007, um 22:36:02 +1200 mailte [EMAIL PROTECTED] folgendes:
> Hello
>
> I want to know about the size of my database. For example, I want to know
> how many Mb of data for current myDatabase database in a postgres server.
http://www.postgresql.org/docs/8.1/interactive/functions
On Wed, 2007-09-19 at 11:05 +0100, Filip Rembiałkowski wrote:
> 2007/9/19, Ow Mun Heng <[EMAIL PROTECTED]>:
>
> (...)
>
> > simulate a delete
> > => delete from parent where id in (select id from child);
> > DELETE 6
> >
> > => select * from parent;
> > id | data1
> > +-
> > 2 | p
It's a Dell server with the following spec:
PE2950 Quad-Core Xeon E5335 2.0GHz, dual
4GB 667MHz memory
3 x 73GB SAS 15000 rpm disk
PERC 5/I Integrated controller card (8 ports, 256MB cache, battery backup) x 6
backplane
Is this ok to run PostgreSQL 8.2.x and Tomcat on? And does anyone know if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/07 04:13, Stefan Schwarzer wrote:
> Hi,
>
> I have global national statistics (GDP, Fish Catch etc.), which I would
> like to aggregate to and calculate per Capita data for given regions
> (Africa, Europe...) and subregions (Western Africa, .
Hello
I want to know about the size of my database. For example, I want to know
how many Mb of data for current myDatabase database in a postgres server.
How I can do that?
Thanks
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
2007/9/19, Ow Mun Heng <[EMAIL PROTECTED]>:
(...)
> simulate a delete
> => delete from parent where id in (select id from child);
> DELETE 6
>
> => select * from parent;
> id | data1
> +-
> 2 | parent2
> 3 | parent3
> 4 | parent4
>
> => select * from child;
> id | data1
> ---
On Tue, 2007-09-18 at 08:37 -0400, [EMAIL PROTECTED] wrote:
> Ow Mun Heng wrote:
> > Hi,
> >
> > create table foo (a int, b int, c int)
> > create table foo_loading_source1 (a int, b int, c int)
> > create table foo_loading_source2 (a int, b int, c int)
> >
> > Is there a way which can be made easi
On Tue, 2007-09-18 at 09:56 +0100, Filip Rembiałkowski wrote:
> 2007/9/18, Ow Mun Heng <[EMAIL PROTECTED]>:
> > Hi,
> >
> > I have 3 tables
> >
> > foo
> > foo_loading_source1
> > foo_loading_source2
> >
> > which is something like
> >
> > create table foo (a int, b int, c int)
> > create table foo
Hi,
I have global national statistics (GDP, Fish Catch etc.), which I
would like to aggregate to and calculate per Capita data for given
regions (Africa, Europe...) and subregions (Western Africa, ) on-
the-fly.
From a statistical point of view it seems best to use something like
thi
On Wed, 2007-09-19 at 07:57 +0200, A. Kretschmer wrote:
> am Mon, dem 17.09.2007, um 9:21:22 +0800 mailte Ow Mun Heng folgendes:
> > CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate
> > timestamp, code text)
> > RETURNS SETOF foo AS
> > $BODY$
> > SELECT
> > TRH.ID,
> >
Hey all.
When running pgstatindex(some_index) I'm getting the usual result:
Version, tree_level, index_size, root_block_no, internal_pages, leaf_pages,
empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation
with a bunch of numbers.
Now, my question are
What each one represent (
Hey all.
When running pgstatindex(some_index) I'm getting the usual result:
Version, tree_level, index_size, root_block_no, internal_pages, leaf_pages,
empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation
with a bunch of numbers.
Now, my question are
What each one represent (
On Tue, 2007-09-18 at 14:58 -0500, Walter Roeland wrote:
> 2007-09-18 14:28:36 127.0.0.1 postgres postgres FATAL: database
> "postgres" does not exist
>
> And I have to abort the startup.
>
> Maybe the next is a hint:
> When I had blocked the access to localhost with SSL=ON (using hostnossl
> pg
On 19/09/2007, Gregory Williamson <[EMAIL PROTECTED]> wrote:
...
> Can't speak directly to PostgreSQL but in Informix the fill factor is
> useful for tweaking indexes. A very high fill factor is useful for tables
> that are static -- any inserts or changes to the index trigger a *lot* of
> movin
66 matches
Mail list logo