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)-
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
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-
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)---
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
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, 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
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,
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
> 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
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
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
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
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
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
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
16 matches
Mail list logo
