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?
There
I try to do it by rpm installation buttheseemed 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
Hello.
Im 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 PRIMARY KEY
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 intervals to
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 records in the
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.
brew
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 can
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,
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
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 add
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 that
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 can
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:
snip
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 transaction,
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
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 | NOCREATEUSER
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
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 it
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
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
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 hyperref package.
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:
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-transaction. If
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
27 matches
Mail list logo