Patrick Spinler wrote:
> Adam Witney wrote:
> > Hi all,
> >
> > I am experimenting with a few OS's for my new hardware. I plan to have a
> > software RAID5 device for my pgsql data directory.
> >
> > I have been experimenting with FreeBSD and with Linux, does anyone have any
> > thoughts on wheth
When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
Patrick Spinler <[EMAIL PROTECTED]> confessed:
>
> According to the theory they expound, a database with any significant
> write activity whatsoever should never be on raid 5, but instead be on
> raid 0+1.
>
Kind of related and a poin
Your pardon, but I submit that the responder did answer your question.
Unfortunately, your question may be meaningless in the context asked.
Specifically, you are asking for an Oracle specific feature, which may
not have any direct comparison in another system. Instead, it is better
to ask how
Adam Witney wrote:
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are better than Linux software R
Hi Bruno,
Thanks for the reply. Still my questions were unanswered. Pl could
anyone give a solution.
1. Is there any way I can generate archive log in postgres
2. Is it possible to run the postgres in standby mode (like Oracle stnd
by server) and apply the archive logs
Thanks and regards,
Sa
On Tue, 16 Dec 2003 [EMAIL PROTECTED] wrote:
> > I am experimenting with a few OS's for my new hardware. I plan to have a
> > software RAID5 device for my pgsql data directory.
> >
> > I have been experimenting with FreeBSD and with Linux, does anyone have any
> > thoughts on whether vinum RAID de
> I am experimenting with a few OS's for my new hardware. I plan to have a
> software RAID5 device for my pgsql data directory.
>
> I have been experimenting with FreeBSD and with Linux, does anyone have any
> thoughts on whether vinum RAID devices are better than Linux software RAID?
> Or vice ver
This is another discuttion about this
problem.
Please read these mails.
>>
>>
I cannot write here all the syntax:I'll give an example: you have a
table called "person" and
Existing table column data types cannot be altered in any stable version
of postgres(7.4 or previous). I don't know if it is available in a beta
release.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jodi
KanterSent: Tuesday, December 16,
On Tue, Dec 16, 2003 at 12:32:05PM -0500, Jodi Kanter wrote:
> Can I alter a column from character varying(128) to text without having
> to create a temp table? I am running 7.3.3.
The FAQ has a question entitled "How do you remove a column from a
table, or change its data type?":
http://www.po
Can I alter a column from character varying(128) to text without having
to create a temp table? I am running 7.3.3.
Thanks
--
___
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
[EMA
On Tue, 16 Dec 2003, Adam Witney wrote:
>
> Hi all,
>
> I am experimenting with a few OS's for my new hardware. I plan to have a
> software RAID5 device for my pgsql data directory.
>
> I have been experimenting with FreeBSD and with Linux, does anyone have any
> thoughts on whether vinum RAID
On Sun, Dec 14, 2003 at 01:25:11PM -, Arun Gananathan wrote:
> Could any one let me know is there a way to findout the rules previously created in
> the database .
Try this:
SELECT * FROM pg_rules;
--
Michael Fuhr
---(end of broadcast)---
Rich Cullingford wrote:
> Well, I was gonna use pg_dumpall to avoid the tedium of individual
> dumps, but (gotcha!) pg_dumpall doesn't accept
> --use-set-session-authorization (tho' it does run pg_dump!).
It supplies that option automatically.
> If I use
> pg_dumpall, will pg_restore (with --use-
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are better than Linux software RAID?
Or vice vers
Arun Gananathan wrote:
Could any one let me know is there a way to findout the rules previously created in the database .
thanks
ganesh
http://www.postgresql.org/docs/7.4/static/view-pg-rules.html#AEN51975
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)-
16 matches
Mail list logo
