Hello,
while on Ubuntu kernel 2.6.28-14-generic Postgres 8.3.7-1 works fine, it
doesn't start on Ubuntu 9.04, kernel 2.6.28-15-generic. Following is the log
output of 'sudo /etc/init.d/postgresql-8.3 start':
Begin of log ==>
2009-09-08 08:17:52 CAT LOG: could not load root certificate file
"root
hi jerry,
try killing mDNSResponder before restarting postgres:
sudo killall mDNSResponder
hopefully apple fixes this dns-problems in 10.6.1.
regards, jan otto
The rascal gets respawned immediately ;(
Of course it will be respawned, but all the cache is disposed (the
broken entries too
On 2009-09-07, Alvaro Herrera wrote:
> Jasen Betts wrote:
>> On 2009-09-03, S Arvind wrote:
>> > --001636ed7465170dcf0472ab404d
>> > Content-Type: text/plain; charset=ISO-8859-1
>> >
>> > I have 2 doubts related to Filsesytem and Postgres data folder
>> >
>> > 1.Currently in CentOS, our postgres
On 2009-09-08, Jia Chen wrote:
> Hi there,
>
> As a beginner of PostgreSQL, I installed PostgreSQL 8.3.7 on Ubuntu 9.04
> by using sudo apt-get install.
>
> Now, I want to store PostgreSQL data on an external drive because I work
> both on my office machine and on my home machine a lot. This w
Markus Pscheidt wrote:
> Hello,
>
> while on Ubuntu kernel 2.6.28-14-generic Postgres 8.3.7-1 works fine, it
> doesn't start on Ubuntu 9.04, kernel 2.6.28-15-generic. Following is the log
> output of 'sudo /etc/init.d/postgresql-8.3 start':
> 2009-09-08 08:17:52 CAT FATAL: could not create share
2009/9/8 Markus Pscheidt
>
> Hello,
>
> while on Ubuntu kernel 2.6.28-14-generic Postgres 8.3.7-1 works fine, it
> doesn't start on Ubuntu 9.04, kernel 2.6.28-15-generic. Following is the log
> output of 'sudo /etc/init.d/postgresql-8.3 start':
>
> Begin of log ==>
> 2009-09-08 08:17:52 CAT LOG:
On Tue, Sep 08, 2009 at 08:52:23AM +, Jasen Betts wrote:
> On 2009-09-08, Jia Chen wrote:
> > Now, I want to store PostgreSQL data on an external drive because I work
> > both on my office machine and on my home machine a lot. This way, I can
> > always bring my external drive to either loc
-- Forwarded message --
From: Markus Pscheidt
Date: 2009/9/8
Subject: Re: [GENERAL] Fail to start Postgres on Ubuntu kernel
2.6.28-15-generic
To: Filip Rembiałkowski
>
> quite a common problem... see
> http://www.postgresql.org/docs/8.3/static/kernel-resources.html
>
> obvious
Hello!
I'm having some trouble with the inet data type and its
operators. Right now I'm relying on operations such as
kll=# SELECT '10.0.0.0/24'::inet + (2^(32-24))::integer;
?column?
-
10.0.1.0/24
(1 row)
to get the "next" available /24. This works all fine and dandy
for IPv
I have a question about ordering by date. I have a table with two fields and
some date
Name(character varying) | Event_Date(timestamp with timezone)
A |2009-09-10 5:30:00
B |2009-09-10- 00:00:00
C
In response to BlackMage :
>
> I have a question about ordering by date. I have a table with two fields and
> some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B |2009-
In response to BlackMage :
>
> I have a question about ordering by date. I have a table with two fields and
> some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B |2009-0
On Tuesday 08 September 2009 6:29:28 am BlackMage wrote:
> I have a question about ordering by date. I have a table with two fields
> and some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B
On Tue, Sep 08, 2009 at 06:29:28AM -0700, BlackMage wrote:
> I want to order by date and then by name, so I want the result A,B,C,D. The
> problem is when I do a 'SELECT * FROM table_name ORDER BY Event_Date, DESC',
> it includes the actual time (HH:MM:SS) so the order comes out B,A,D,C.
>
> So wh
Kristian
assuming the max size of 8 byte integer is
http://www.postgresql.org/docs/8.1/static/datatype.html
bigint8 byteslarge-range integer-9223372036854775808 to 9223372036854775807
i dont know if a IPV6 address
99 99 99 99would fit into
9,223,372,
Kristian Larsson wrote:
> And poking in pg_operator / pg_type seems to confirm this:
>
> nils=# SELECT (SELECT typname FROM pg_type WHERE typelem=oprleft), oprname,
> (SELECT typname FROM pg_type WHERE typelem=oprright) FROM pg_operator WHERE
> oprleft=(SELECT typelem FROM pg_type WHERE typname
[ please CC the mailing list and not the list owner, they answer
mailing list questions not PG questions ]
On Tue, Sep 08, 2009 at 10:31:50AM -0400, Jia Chen wrote:
> Sam Mason wrote:
> >I don't think you need to go that far. I'd just do an "initdb"
> >somewhere on the removable disk and then
Alvaro Herrera writes:
> I'd say this is just a missing feature.
I think the whole thing is a bit of a crock; adding integers to inet
addresses doesn't make a lot of sense logically. Perhaps what is
really wanted is functions on CIDR net identifiers, for instance
first_address('10/8') =
On Tue, Sep 08, 2009 at 06:29:28AM -0700, BlackMage wrote:
>
> I have a question about ordering by date. I have a table with two fields and
> some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B
On Tue, Sep 08, 2009 at 11:06:36AM -0400, Alvaro Herrera wrote:
> Kristian Larsson wrote:
>
> > And poking in pg_operator / pg_type seems to confirm this:
> >
> > nils=# SELECT (SELECT typname FROM pg_type WHERE typelem=oprleft), oprname,
> > (SELECT typname FROM pg_type WHERE typelem=oprright)
On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
> Alvaro Herrera writes:
> > I'd say this is just a missing feature.
>
> I think the whole thing is a bit of a crock; adding integers to inet
> addresses doesn't make a lot of sense logically. Perhaps what is
> really wanted is functions
On Tue, Sep 08, 2009 at 05:58:01PM +0200, Kristian Larsson wrote:
> On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
> > I think the whole thing is a bit of a crock; adding integers to inet
> > addresses doesn't make a lot of sense logically. Perhaps what is
> > really wanted is functions
In some servers 8.4 pg_dump exits without any message if running from Task
Scheduler.
To explore this, I created scheduler task containing line
cmd
After that I can type manually commands:
C:\MyApp\pg_dump>dir /w
..
[.] [..] comerr32.dll
gssapi32.dll k5sprt32.dll
On Tue, Sep 08, 2009 at 05:58:00PM +0200, Kristian Larsson wrote:
> On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
> > Alvaro Herrera writes:
> > > I'd say this is just a missing feature.
> >
> > I think the whole thing is a bit of a crock; adding integers to inet
> > addresses doesn't
On Tue, Sep 08, 2009 at 10:30:21AM -0700, David Fetter wrote:
> Folks,
>
> For those of you who can't attend in person, we'll be streaming audio
> and video and having a chat for tonight's SFPUG meeting on how the
> planner uses statistics.
>
> Video:
>
> http://media.postgresql.org/sfpug/stream
Folks,
For those of you who can't attend in person, we'll be streaming audio
and video and having a chat for tonight's SFPUG meeting on how the
planner uses statistics.
Video:
http://media.postgresql.org/sfpug/streaming
Chat:
irc://irc.freenode.net/sfpug
Cheers,
David.
--
David Fetter http:
Hello,
Is it possible to perform a select in the where clause of a statement?
I have a situation where I've got one arm tied behind my back: I can
only have a single table in the select and from clauses, but the where
clause appears to be freed from that restriction.
Given a statement as
Scott Frankel wrote:
> Is it possible to perform a select in the where clause of a statement?
> I have a situation where I've got one arm tied behind my
> back: I can only have a single table in the select and from
> clauses, but the where clause appears to be freed from that
> restriction.
>
On Tue, Sep 08, 2009 at 10:32:53AM -0700, David Fetter wrote:
> On Tue, Sep 08, 2009 at 10:30:21AM -0700, David Fetter wrote:
> > Folks,
> >
> > For those of you who can't attend in person, we'll be streaming audio
> > and video and having a chat for tonight's SFPUG meeting on how the
> > planner
try without the ccache? perhaps it is pulling in some stuff you don't expect.
On Mon, Sep 7, 2009 at 12:35 PM, Robert Creager wrote:
> Upgraded to Snow Leopard Saturday, and am having problems building now.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
OK, looks like the time window is exactly when we run vacuum. That
has been running now for a couple of months no problem, but the last 2
weekends we've been doing massive data loads which could be
complicating things.
Is vacuum a good candidate for what could be locking up the tables?
Here is
Hi -
I have a database and used symbolic links in the tablespace definitions.
I just wanted to validate that I can move the database objects to a
different physical volume by the following:
1) issuing `pg_ctl stop`
2) hard copying the tablespace files from one drive to another
Alan McKay escribió:
> OK, looks like the time window is exactly when we run vacuum. That
> has been running now for a couple of months no problem, but the last 2
> weekends we've been doing massive data loads which could be
> complicating things.
>
> Is vacuum a good candidate for what could be
Hello,
Is it possible to join tables in the where clause of a statement?
I ask because I have a situation where I only have access to the where
clause of a select statement on a single table, yet I want to perform
a join on multiple tables. eg:
Given a statement as follows:
SELECT foo
Scott Frankel-3 wrote:
>
> Is it possible to join tables in the where clause of a statement
>
> I've explored the "where exists" clause, but that's not supported by
> the application toolkit I'm using. AFAIK, I've only got access to
> where ...
>
> Thanks in advance!
> Scott
>
Not entire
For those experienced using natural primary key designs, what update
strategies do you use when updating related tuples within a
transaction when the primary key is also subject to changes?
For example consider a table is vertically partitioned into two or
more segments (all related on the natura
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
>Is it possible to join tables in the where clause of a statement?
[snip]
>Given a statement as follows:
>
> SELECT foo.foo_id, foo.name
> FROM foo, bar
> WHERE foo.bar_id = bar.bar_id
>
Richard Broersma wrote:
>
> For those experienced using natural primary key designs, what update
> strategies do you use when updating related tuples within a
> transaction when the primary key is also subject to changes?
>
> For example consider a table is vertically partitioned into two or
Andrus wrote:
In some servers 8.4 pg_dump exits without any message if running from
Task Scheduler.
To explore this, I created scheduler task containing line
cmd
After that I can type manually commands:
C:\MyApp\pg_dump>dir /w
..
[.] [..] comerr32.dll
gssapi32.dll
纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format
matters? Can I save JPG/PNG?How?
you can save images as BYTEA data, and the format is totally up to your
application, as postgres just treats it as a block of bytes.however,
I generally find it easier to store m
PG DBAs:
We've been discussing getting rid of VACUUM FULL as a utility on the
hackers list. Please read about it, and comment if you can see any
issues with your use of PostgreSQL if 8.5 doesn't have VACUUM FULL.
http://it.toolbox.com/blogs/database-soup/getting-rid-of-vacuum-full-feedback-neede
On Sep 8, 2009, at 4:02 PM, David W Noon wrote:
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
Is it possible to join tables in the where clause of a statement?
[snip]
Given a statement as follows:
SELECT foo.foo_id, foo.name
FRO
Can I save images in the postgres? How to define? Does the format matters?
Can I save JPG/PNG?How?
miller_2555 wrote:
>
> Hi -
> I have a database and used symbolic links in the tablespace
> definitions. I just wanted to validate that I can move the database
> objects to a different physical volume by the following:
> 1) issuing `pg_ctl stop`
> 2) hard copying the tablespace fi
Yaroslav Tykhiy wrote:
By the way, folks, do you think there may be performance gain or loss
from rewriting this with an explicit JOIN? E.g.:
SELECT DISTINCT foo.foo_id, foo.name FROM foo JOIN bar ON foo.bar_id =
bar.bar_id WHERE bar.name='martini';
I would expect that to be more efficient
On 09/09/2009, at 9:02 AM, David W Noon wrote:
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
Is it possible to join tables in the where clause of a statement?
[snip]
Given a statement as follows:
SELECT foo.foo_id, foo.name
FROM
On 09/09/2009, at 10:43 AM, John R Pierce wrote:
纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format
matters? Can I save JPG/PNG?How?
you can save images as BYTEA data, and the format is totally up to
your application, as postgres just treats it as a block of bytes
Thank you very much. It seems it is better to save it on file system.
2009/9/9 Yaroslav Tykhiy
> On 09/09/2009, at 10:43 AM, John R Pierce wrote:
>
> 纪晓曦 wrote:
>>
>>> Can I save images in the postgres? How to define? Does the format
>>> matters? Can I save JPG/PNG?How?
>>>
>>
>> you can save i
miller_2555 writes:
> So this does not work well apparently.
The only obvious thing wrong with your example is failing to preserve
ownership/permissions of the moved files. I think the upper directories
are probably not readable by Postgres so it's choking.
BTW, Postgres *already* refers to tab
Tom Lane-2 wrote:
>
> miller_2555 writes:
>> So this does not work well apparently.
>
> The only obvious thing wrong with your example is failing to preserve
> ownership/permissions of the moved files. I think the upper directories
> are probably not readable by Postgres so it's choking.
>
50 matches
Mail list logo
