> I use the two mechines with FC3 and postgresql 8.1 RPM installation and
> would like to do DBmirror or other postgresql database replication from
> master to slave server . Could I do this replication using RPM or I must use
> the tar.gz version ? Could anybody suggest me about replication?
The
I try to do it by rpm installation but the seemed to miss some file which was described by the doc. for ex. pending.so and its' path and
perl /./DBmirror.pl
could not run
Could you suggest me the URL how to install DBmirror by the rpm mechine?
Thanks
Amrit
2006/2/25, chris smith <[EMAIL PROTE
Hello.
I’m using Postgresql 7.3 on Linux.
I created sequence
CREATE SEQUENCE event_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 5
START 1
CACHE 1
CYCLE;
And I created table which uses this sequence as primary key.
CREATE TABLE hw_messages
(
event_id INT PRIMAR
OK, added to TODO.
---
Michael Glaesemann wrote:
>
> On Feb 25, 2006, at 12:09 , Bruce Momjian wrote:
>
> > We have this TODO:
> >
> > o Allow infinite dates just like infinite timestamps
> >
> > Do we need to add
On Fri, Feb 24, 2006 at 04:31:48PM -0800, Natasha Galkina wrote:
> I created sequence
>
> CREATE SEQUENCE event_id_seq
> INCREMENT 1
> MINVALUE 1
> MAXVALUE 5
> START 1
> CACHE 1
> CYCLE;
[...]
> My question is how I can rotate the records in the table. I have maximum
> number of reco
> > I'm confused about Linux World east, though. I googled it and it looks
> > like it was in Boston last month.
> >
> It is next month.
Ah, found it. LinuxWorld at the Boston Convention and Exhibit Center on
April 3-6 2006
Sorry, I'm in NYC area and was hoping it was at the Javits Center.
br
On Sat, Feb 25, 2006 at 10:12:38AM -0700, Michael Fuhr wrote:
> > If it is not correct, how can I rotate the records in the table?
>
> One way would be to use a trigger to delete records having the same
> event_id as the record being inserted.
I should mention that with the example I posted you c
On Thursday 23 February 2006 20:37, Russell Denney wrote:
> Any user groups in the Tampa, St. Petersburg, Florida area? Anyone
> interested in starting a group? I am new to PostgreSQL and many aspects
> of programming, but I would very much like to meet with those that have
> the same interests, re
Hello,
looks like PostgreSQL (8.0/8.1) has no support for using
other-than-btree indexes for primary keys. Is there a (perhaps
un(der)documented) way to specify the index type?
Rationale: I'm trying to have PKs on a type that defines only the = and
<> operators, and would work with a hash-based P
On Fri, Feb 24, 2006 at 10:09:25PM -0500, Bruce Momjian wrote:
> Karsten Hilbert wrote:
> > I will also stay with the hope that one day before long we
> > will have "'infinite'::interval".
>
> We have this TODO:
>
> o Allow infinite dates just like infinite timestamps
>
> Do we need to
Roman Neuhauser <[EMAIL PROTECTED]> writes:
> looks like PostgreSQL (8.0/8.1) has no support for using
> other-than-btree indexes for primary keys. Is there a (perhaps
> un(der)documented) way to specify the index type?
No --- at present this is not possible because btree is the only index
type th
Is it possible to give a group the the createuser permission ? This
way if a user in the group they can create users.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Thank you all for the valuable advices.
I'll try them on a test server and will come back.
Thanks again!
Iv
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On 2/26/06, Amrit Angsusing <[EMAIL PROTECTED]> wrote:
> I try to do it by rpm installation but the seemed to miss some file which
> was described by the doc. for ex. pending.so and its' path and
> perl /./DBmirror.pl
> could not run
If you have a problem copy the exact error message, nobody c
On Fri, Feb 24, 2006 at 09:02:04AM -0800, CG wrote:
> I have a search table which I use for partial-match text searches:
> For a string "Hello World" the ltree is created like 'h.e.l.l.o.w.o.r.l.d' ...
> If I wanted to find all rows with "orl" in them i would construct an lquery
> like '*.o.r.l.*'
On Fri, Feb 24, 2006 at 11:56:58AM -0500, Brad Nicholson wrote:
> Simon Riggs wrote:
>
> >A much easier way is to start a serialized transaction every 10 minutes
> >and leave the transaction idle-in-transaction. If you decide you really
> >need to you can start requesting data through that transac
Hello, I am very new to postgreSQL I am using the win32 platform is
there a website URL that has Sample Client Apps written for win32?
I need Samples of very basic things like:
Connect to a db on a remote server
create new db
create table
add records
drop records
ect...
there are some Samples he
On 2/26/06, Jebus <[EMAIL PROTECTED]> wrote:
> Is it possible to give a group the the createuser permission ? This
> way if a user in the group they can create users.
Version 8.1.x does..
postgres=# \h create group
...
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUS
As part of a migration from 8.0 to 8.1 i want to convert the data from
ASCII to UTF-8.
I dumped the database with pg_dump (8.0) and tried to convert it with
iconv, but it shows an error:
$ iconv -t ASCII -t UTF-8 fahstats_data.dump -o fahstats_data_utf-8.dump
iconv: illegal input sequence at posi
Clodoaldo Pinto wrote:
> As part of a migration from 8.0 to 8.1 i want to convert the data
> from ASCII to UTF-8.
ASCII is a subset of UTF-8, so if you really wanted to do that you
wouldn't need to do anything.
> I dumped the database with pg_dump (8.0) and tried to convert it with
> iconv, but
Since I can't use ECPG COPY, I'm trying to use libpq PQputCopyData. Not
realizing I had to use CSV format to include column header names, I used:
PQexec(conn, "COPY detail FROM stdin")
I sent the column headers as the first line of the input. While this I now
know this is wrong, the problem
Hi,
I've noticed that the PDF version of the manuals for 8.0 and 8.1
are lacking bookmarks and/or TOC and document reference links. If
this is generated via LaTeX, such links oculd easily be incorporated
via the hyperref package. It would make the document much easier to
navigate.
--
% Randy Yat
Randy Yates wrote:
Hi,
I've noticed that the PDF version of the manuals for 8.0 and 8.1
are lacking bookmarks and/or TOC and document reference links. If
this is generated via LaTeX, such links oculd easily be incorporated
via the hyperref package. It would make the document much easier to
navig
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Randy Yates wrote:
>> Hi,
>>
>> I've noticed that the PDF version of the manuals for 8.0 and 8.1
>> are lacking bookmarks and/or TOC and document reference links. If
>> this is generated via LaTeX, such links oculd easily be incorporated
>> via the h
On Feb 26, 2006, at 12:30 , Randy Yates wrote:
Can you tell me how, using FC4, I can grab the documentation build
environment from the repository and download it to my machine?
You can find instructions on how to build the documentation in the
documentation in Appendix G:
http://www.postg
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] ("Jim C. Nasby")
wrote:
> On Fri, Feb 24, 2006 at 11:56:58AM -0500, Brad Nicholson wrote:
>> Simon Riggs wrote:
>>
>> >A much easier way is to start a serialized transaction every 10 minutes
>> >and leave the transaction idle-in-transa
Michael Glaesemann wrote:
On Feb 26, 2006, at 12:30 , Randy Yates wrote:
Can you tell me how, using FC4, I can grab the documentation build
environment from the repository and download it to my machine?
You can find instructions on how to build the documentation in the
documentation in Appe
27 matches
Mail list logo