how to unsubscribe of this list??
Simon Riggs escreveu:
On Mon, 2009-03-23 at 21:51 -0700, Aimon Bustardo wrote:
Hi, I ran into a recovery problem where I have a single missing WAL
file in a long sequence. I need a way to recover past that missing WAL
archive. I am desperately ho
asdfasdfasdfasdfasdfasdfasdfasdfasdfasd
asdfasdff
asdfasdfasdfasdfasdfasdfasdfasdfasdfasd
asdfasdff
asdfasdfasdfasdfasdfasdfasdfasdfasdfasd
asdfasdff
asdfasdfasdf
asdsss
sss
sss
sss
Erik Jones writes:
> These are all client databases at the web hosting company I work at.
> I can't go putting triggers on all of their tables. I think I'll just
> start taking snapshots of pertinent data from pg_stat_activity and
> after I've been collecting data for a while run a report
On Mar 23, 2009, at 5:00 PM, Craig Ringer wrote:
Erik Jones wrote:
Am I missing something obvious here? If not, has anyone come up
with a reliable way to do this?
Triggers on all your tables that append to a logging table?
Have the client do it?
Note that you do *NOT* want to have trigg
Hi Peter,
If you want to use Postgres to store/manage/query spatial data, I strongly
recommend you look at PostGIS, & not the native Postgres geometry types.
Brent Wood
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Peter Willis 03/24/09 10:35 AM >>>
Hello,
I would like to us
On 24/03/2009 20:25, Berdam wrote:
> aer
>
?
--
Raymond O'Donnell, Director of Music, Galway Ca
On 24/03/2009 20:38, Will Rutherdale (rutherw) wrote:
> Pardon my newness to Postgres.
We've all been there at some point! - except of course for Tom Lane.
:-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Irelan
On Mon, Mar 23, 2009 at 4:46 AM, Sam Mason wrote:
> On Fri, Mar 20, 2009 at 05:37:33PM -0700, Randall Lucas wrote:
> > I added a functional index.
> >
> > create table example (id serial primary key, stuff text, parent_id
> int);
> > create index example_root_idx on example (get_root_id(id));
Yes, that worked, thanks.
After also doing this:
alter database "mickey" rename to "Mickey";
it solved the problem.
Pardon my newness to Postgres.
-Will
-Original Message-
From: John R Pierce [mailto:pie...@hogranch.com]
Sent: 24 March 2009 16:21
To: Will Rutherdale (rutherw)
Cc: pg
aer
ggg
g
Will Rutherdale (rutherw) wrote:
When I try going into psql as user postgres to change the user name, I
get this problem:
postgres=# alter user mickey rename to Mickey;
ERROR: role “mickey” already exists
you might try...
alter user "mickey" rename to "Mickey";
--
Sent via pgsql-genera
Hi.
I have a little problem with user names and Postgres commands.
Due to quirks in corporate account management using ADS, some user names
come out as, say, Mickey when you log into Linux instead of mickey.
This unfortunate user tries to run Postgres commands and gets for
instance:
$ p
asss
asd
fas
dfasdffddsssa
asdf
asdf
asdasdfasdfasdfasdfasd
Thank you guys for your replies!
It is definitely something wrong with my code, here is the thread which does
the listening:
http://mitek.id.au/flex/DBListener.cpp
The rest of application is fairly big and does not relate to the database.
For libpq calls I am using the SPTK (http://sptk.net) libr
Hello,
i have a problem with understanding fulltext search in PG 8.3.
Example:
CREATE TABLE tfulltext (body text, fulltext tsvector);
INSERT INTO tfulltext VALUES ('title und description sind wichtige
grundlagen', to_tsvector('pg_catalog.german', 'title und description
sind wichtige grundlag
[..]
I've just noticed, that i forgot to change the subject. While writing i
figured out, that the question is not the one, i want to ask.
I am sorry for confusions.
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen abstrahi
Torsten Zühlsdorff schrieb:
Hello,
i have a problem with understanding fulltext search in PG 8.3.
[..]
I solved it. I have to specify the language in to_tsquery(). -.-
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen abstr
I went to upgrade an installation and was stopped with (approximately)
the following message after clicking Next on the step where I told it
to use the same data directory:
"The existing data directory (date time: floating-point numbers) is
not compatible with this server (date time: 64-bit intege
=?UTF-8?B?0KDQvtC80LDQvSDQnNCw0YjQuNGA0L7Qsg==?= writes:
> Seems I've missed something important about time zones. On my server
> i've got local timezone 'W-SU' (Moscow time):
> => show timezone;
> TimeZone
> --
> W-SU
> => select now();
> now
>
On Tue, Mar 24, 2009 at 1:42 PM, josep porres wrote:
> i've just upgraded the server to 8.3.7 holding the same data directory
>
> select * from pldbg_get_proxy_info();
> "serverversionstr","serverversionnum","proxyapiver","serverprocessid"
> "PostgreSQL 8.3devel on i686-pc-mingw32, compiled by GCC
by the way, after upgrading, i get the same behaviour
even executing the function in a query window created after setting the
breakpoint.
2009/3/24 josep porres
> i've just upgraded the server to 8.3.7 holding the same data directory
>
> select * from pldbg_get_proxy_info();
> "serverversionstr"
i've just upgraded the server to 8.3.7 holding the same data directory
select * from pldbg_get_proxy_info();
"serverversionstr","serverversionnum","proxyapiver","serverprocessid"
"PostgreSQL 8.3devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)",80300,3,2948
is it ok fo
On Tue, Mar 24, 2009 at 7:50 AM, josep porres wrote:
> Ooops, I haven't realized the second schema, I've found the function.
> Here you are your test log.
OK, I think we've tracked down the problem. Can I send you some
updated DLLs to try offlist?
--
Dave Page
EnterpriseDB UK: http://www.e
Tom Lane schrieb:
Marinos Yannikos writes:
"i_a" btree (a)
"i_ab" btree (a, b)
I suspect that these indexes are exactly the same size --- look at
pg_class.relpages or use the pg_relation_size() function to verify.
For some reason, the first one is actually about twice the size of the
secon
RebeccaJ wrote:
Thanks, everyone, for your contribution to this thread. I'm
approaching the database design of my web application differently,
now. Before, I was planning to have CHECK constraints in all of my
text or char fields, to keep out all semicolons, single quotes, and
anything e
Seems I've missed something important about time zones. On my server
i've got local timezone 'W-SU' (Moscow time):
=> show timezone;
TimeZone
--
W-SU
=> select now();
now
---
2009-03-24 13:23:39.655057+03
Till now all seems ok. Tha
Albe Laurenz, 24.03.2009 10:34:
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both systems are
On 2009-03-18, cifroes wrote:
> This is a multi-part message in MIME format.
>
> --_=_NextPart_001_01C9A7E6.B32BBA87
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi,
>
> I have a DB in utf-8 and postgres 8.3.x.=20
>
> How can I do a
Hello,
I'm having a problem with a warm standy-by / continuous archiving setup.
The archive of WAL segments on the "slave" server sometimes (and only
sometimes) grows _huge_.
I'm using a warm standy-by / continuous archiving setup with two
servers. The "slave" servers, in stand-by mode, is p
Aimon Bustardo wrote:
> Hi, I ran into a recovery problem where I have a single missing WAL
> file in a long sequence. I need a way to recover past that missing WAL
> archive. I am desperately hoping there is a way to do this. Any help
> that can be given will be extremely appreciated!
I am
Thomas Kellerer wrote:
> I'm getting a new notebook and want to confirm that my idea
> on how to move my Postgres installation will work This is a
> development/test installation and not a production system, so
> it doesn't need to be 100% fail safe.
>
> Both systems are Windows XP 32bit.
>
>
> how to access large objects from the database when using
> PGAdmin like client applications? When a normal select is
> executed on lo type columns it gives only the number which
> refers to large objects stored in 'pg_largeobjects' table.
> When records from pg_largeobjects are fetched using
On Mon, 2009-03-23 at 21:51 -0700, Aimon Bustardo wrote:
> Hi, I ran into a recovery problem where I have a single missing WAL
> file in a long sequence. I need a way to recover past that missing WAL
> archive. I am desperately hoping there is a way to do this. Any help
> that can be given
good morning,
I have a demo database, but it's empty.
if you tell me where is the creation script, I will try it
2009/3/23 Dave Page
> On Mon, Mar 23, 2009 at 1:56 PM, josep porres wrote:
> > well, now a log with only trying to debug setting a breakpoint
>
> Hmmm - do you still have the demo s
Hi,
Are there any tools available for converting XML files for which a dtd
is available into a PostgreSQL table without any programming on my
part?
The files are basically XML formatted table dumps, with some elements
having attributes.
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukken
36 matches
Mail list logo
