>
> That is exactly what I want, and now I finally see how to do it (I
> think!). However, it is a considerable amount of work to set this up
> manually, plus, it has been a headache realizing how to get there at
> all. I'm hoping that one or more of the developers think it would be a
> good idea
Probably wishful thinking, but who knows - maybe
there's something in contrib! I have a bunch of csv
data with the field names specified on the first line
of the various files. Is there any such utility that
will create a table schema using the field names AND
look through the data and determine wh
> I currently have a postgresql 8 system which I want to replicate
> (ideally in realtime) with a spare host in order to introduce some
> redundancy - eg. if the master server dies then I've got a ready-to-go
> backup. Switchover does not have to be automated.
>
> I've looked into commandprompt.c
I'm trying to build postgres on Suze with --with-pam, and it tells me:
/usr/lib/gcc-lib/i586-suse-linux/3.3.5/../../../../i586-suse-linux/bin/ld:
cannot find -lpam
I know it is actually installed, and disecting the configure script and
hand-compiling the test program works if I say "/lib/libp
Hello,
I've send this message also on 29-1-2004 and have since no solution for
this problem .. >:o .
I have a little test program (see at the end of the message).
The program crashes when PQTrace is called (instruction referenced
memory at "0x0010", the
memory could not be written" (o
Thank you, John!
I misunderstood you the first time, but I now see we have the same thing
in mind.
So you'd have most of your data in a main table:
create table observations (
obsIDintegerprimary key,-- Maybe a BIGINT
temperaturefloat,
etc.
);
and some
Janning Vygen <[EMAIL PROTECTED]> writes:
> Am Samstag, 10. September 2005 18:05 schrieb Tom Lane:
>> If there's no pg_depend entry then DROP TYPE should work. Otherwise
>> you might have to resort to manually DELETEing the pg_type row.
> Thanks for your detailed answer. I don't want to do anythi
On Sun, Sep 11, 2005 at 06:36:26PM +0100, mike dixon wrote:
> Tried a couple other places and aren't getting anywhere.
>
> A windows xp program I use uses pgsql; I'd like to create a backup of the db
> but from within linux without xp running (I run xp in vmware; and the xp db
> backup will be w
Barry,
You can use PITR to archive transaction logs to a second server that is
kept in standby mode.
This will cope with any number of tables and cope with dynamic changes
to tables.
This is fairly straightforward and very low overhead.
Set archive_command to a program that transfers xlog files
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> http://archives.postgresql.org/pgsql-committers/2005-06/msg00156.php
> Did that patch actually implement "skip scanning"?
No, it just removed the planner's arbitrary assumption that the index
methods wouldn't cope.
Teodor Sigaev <[EMAIL PROTECTED]> writes:
> GiST may work with any subset of index columns too. Even in existing code I
> don't see any problem except NULL in a first column. GiST doesn't store
> tuples
> with leading NULL value (gist.c lines 174, 326), so index doesn't contained
> them.
Well,
Am Samstag, 10. September 2005 18:05 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > i guess the table was dropped but not the corresponding type.
> > How can things like this happen?
>
> Corrupted pg_depend table maybe? You might try REINDEXing pg_depend
> to be on the safe side
Tom Lane <[EMAIL PROTECTED]> writes:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>
> > Yes, if it is selective enough. (It _can_ use the index, which does not
> > mean that it _will_ use it.) Note that if your example query used the
> > columns (lname, dob), the answer would be "no."
>
> Actua
Greg Stark suggests here:
http://archives.postgresql.org/pgsql-hackers/2005-05/msg00966.php
that GiST could also be fixed to work with any subset of the index
columns, but it hasn't been done yet, unless Teodor and Oleg snuck
something in during that last round of GiST work.
GiST may work with a
[EMAIL PROTECTED] wrote:
I've looked into commandprompt.com's mammoth system, but it only
supports up to 1000 tables (the documentation doesn't mention this!) -
the database in question has more than 1000 tables, and adds new tables
regularly. Slony-I and pgpool apparently don't support dynamic
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Mon, Sep 12, 2005 at 10:05:36AM -0400, Reid Thompson wrote:
>> Why is that? In order to use an index, does the query have to utilize
>> the 'first' element of the index?
> The "leftmost part." There's no way to scan an index if you don't know
> the
Hmm, in fact if the redundant values you're worried about come in
long stretches (e.g., temperature is the same for many observations
in a row), I suppose you could do the same thing - map a constant
value to the range of observation IDs for which it holds. This gets
back to having many tables
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
>> Example:
>> assume a table of 10 columns, three of which are fname, lname, and dob.
>> If an index is created on (fname, lname, dob), will a query that
>> utilizes two of the columns ( sel
On Mon, Sep 12, 2005 at 10:05:36AM -0400, Reid Thompson wrote:
> Alvaro Herrera wrote:
> > On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
> >> Example:
> >> assume a table of 10 columns, three of which are fname, lname, and
> >> dob. If an index is created on (fname, lname, dob), wi
On Mon, Sep 12, 2005 at 10:05:36AM -0400, Reid Thompson wrote:
> Alvaro Herrera wrote:
> > Note that if your example query used the columns (lname, dob),
> > the answer would be "no."
>
> Why is that? In order to use an index, does the query have to utilize
> the 'first' element of the index?
In
On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
> assume a table of 10 columns, three of which are fname, lname, and dob.
> If an index is created on (fname, lname, dob), will a query that
> utilizes two of the columns ( select 'data' from table where fname = 'X'
> and lname = 'Y') u
Alvaro Herrera wrote:
> On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
>> Example:
>> assume a table of 10 columns, three of which are fname, lname, and
>> dob. If an index is created on (fname, lname, dob), will a query that
>> utilizes two of the columns ( select 'data' from table
On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
> Example:
> assume a table of 10 columns, three of which are fname, lname, and dob.
> If an index is created on (fname, lname, dob), will a query that
> utilizes two of the columns ( select 'data' from table where fname = 'X'
> and lna
Example:
assume a table of 10 columns, three of which are fname, lname, and dob.
If an index is created on (fname, lname, dob), will a query that
utilizes two of the columns ( select 'data' from table where fname = 'X'
and lname = 'Y') utilize the index?
thanks,
reid
--
Am Montag, 12. September 2005 13:52 schrieb [EMAIL PROTECTED]:
> I currently have a postgresql 8 system which I want to replicate
Look at DRBD.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting
Hi,
I currently have a postgresql 8 system which I want to replicate
(ideally in realtime) with a spare host in order to introduce some
redundancy - eg. if the master server dies then I've got a ready-to-go
backup. Switchover does not have to be automated.
I've looked into commandprompt.com's ma
suresh ramasamy wrote:
i'm new to postgreSQL as well as new to database concepts. please tell me
how can i learn. i mean the easiest and fast way. Your help will be
appreciated.
Make an appropriate posting to pgsql-jobs?
---(end of broadcast)
am 12.09.2005, um 17:08:31 +0530 mailte suresh ramasamy folgendes:
> hi,
>
> i'm new to postgreSQL as well as new to database concepts. please tell me
> how can i learn. i mean the easiest and fast way. Your help will be
Read a book.
http://techdocs.postgresql.org/techdocs/bookreviews.php
Re
hi,
i'm new to postgreSQL as well as new to database concepts. please tell
me how can i learn. i mean the easiest and fast way. Your help will be
appreciated.
Thank you for your input! Individual replies follow below.
##
Chris Travers wrote:
Ok. Imagine two huge huge tables:
file_dataand additional_data
create_table file_data (
file_id serial primary key,
station_id text,
);
create table additional_
I verified that it was not doing anything by erasing the pg_statistics table
and it did not fill it within 24 hours. When I ran vacuum analyze manually it
filled it in.
I am using postgresql 8.03 on gentoo which was downloaded with portage and
included pg_autovacuum as part of the set up.
I wil
31 matches
Mail list logo
