Dear Experts,
For what its worth : I have been running a postgresql database on a hardware
raid 5 (adaptec 2400A hardware card and 4 x 200GB WD IDE drives) for about
6months and in my (relatively low volume read write by transaction standards
described by others here) environment all has been s
> 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 ve
When grilled further on (Wed, 17 Dec 2003 08:45:43 -0700 (MST)),
"scott.marlowe" <[EMAIL PROTECTED]> confessed:
>
> Just wondering, was that on hardware or software RAID5, and if hardware
> did it have battery backed cache controllers? Makes a huge difference. I
> would never use SW RAID5 for
Anjan Dave wrote:
> Is there a way I can assign EXECUTE privilege for a user-defined
> function in the GRANT command in 7.2? (7.3 has it)
No.
> Also, how do I list all the user-defined functions/stored procedures.
> Once listed, how to give UPDATE privilege to a user on all of them?
Functions do
Title: GRANT in pg7.2
Hi,
I need some help for the following:
Is there a way I can assign EXECUTE privilege for a user-defined function in the GRANT command in 7.2? (7.3 has it)
Also, how do I list all the user-defined functions/stored procedures. Once listed, how to give UPDATE privile
Well, we currently use pg_dumpall and pipe it to a tar file. It backups
up all data and the database schema. So if a database goes down, I can
just pipe that file to pgsql and it will reload everything including all
tables, users, grant rights, etc.
There is also a company called Bakbone soft
I forgot to add one thing :
For file system backup and restore PostgreSQL must be stoped
Regards
V Kashyap
Dear Van L. Loggins ,
What methods are available to easily backup the contents of a
PostgreSQL database?
PostgreSQL both file system backup option and SQL data in form of
insert statem
Dear Van L. Loggins ,
What methods are available to easily backup the contents of a PostgreSQL database?
PostgreSQL both file system backup option and SQL data in form of
insert statement :
Note: I have done this thing with > PostgreSQL 7.3
This is what I do
1. Take a file system backup of
>
> 1. Is there any way I can generate archive log in postgres
I run cron jobs that dump all my databases each evening, plus GLOBALS. The
cronlogs are then my archive log.
> 2. Is it possible to run the postgres in standby mode (like Oracle stnd
>by server) and apply the archive logs
Nope.
On Wed, 17 Dec 2003, Adam Witney wrote:
> On 17/12/03 3:45 pm, "scott.marlowe" <[EMAIL PROTECTED]> wrote:
>
> > On Tue, 16 Dec 2003, Robert Creager wrote:
> >
> >> When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
> >> Patrick Spinler <[EMAIL PROTECTED]> confessed:
> >>
> >>>
> >>> Ac
On 17/12/03 3:45 pm, "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> On Tue, 16 Dec 2003, Robert Creager wrote:
>
>> 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 sig
On Tue, 16 Dec 2003, Robert Creager wrote:
> 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 i
What methods are available to easily backup the contents of a PostgreSQL database?
We are in the process of converting over to it from Progress, and we need to figure
out what our best option is to have a complete backup in case of disaster.
Thanks for the input,
Van
--
Van Loggins[
hello
in postgresql there is any system variable for update
Means if i update a record so any system variable store the
timestamp(update time) of that updated record.
Thankyou
Ashok
---(end of broadcast)---
TIP 7: don't forget to increase your fr
Am Mittwoch, 17. Dezember 2003 12:18 schrieb A.Bhuvaneswaran:
> > You need to double quote the name to preserve case.
>
> IMO, in 7.3.4, these two scripts (createuser & dropuser) preserve the
> case by default even without double quote. For example, 'createuser
> Admin' makes an entry Admin(not adm
> You need to double quote the name to preserve case.
IMO, in 7.3.4, these two scripts (createuser & dropuser) preserve the
case by default even without double quote. For example, 'createuser
Admin' makes an entry Admin(not admin) in pg_shadow. Similarly, dropuser
deletes the same entry even with
> As user postgres I have run initdb. I create a user named
> Administrator via the createuser script. All goes well and I get the
> response CREATE USER.
> Then I try:
>
> psql -U Administrator template1
>
> and get the response:
> psql: FATAL: IDENT authentication failed for user "Administrat
Am Mittwoch, 17. Dezember 2003 09:39 schrieb Paul Power:
> But if I try DROP USER Administrator I get
>
> ERROR: DROP USER: user "administrator" does not exist
>
> Note the last error has "administrator" rather than "Administrator".
You need to double quote the name to preserve case.
I have been following the basic install process for Linux.
As user postgres I have run initdb. I create a user named Administrator via the createuser script. All goes well and I get the response CREATE USER.
Then I try:
psql -U Administrator template1
and get the response:
psql: FATAL: IDENT au
Jodi Kanter <[EMAIL PROTECTED]> writes:
> Can I alter a column from character varying(128) to text without having
> to create a temp table? I am running 7.3.3.
Yeah, if you're brave enough: change the column's atttypid to 'text'
(25, I think, but check it) and atttypmod to -1 in pg_attribute.
Thi
20 matches
Mail list logo
