Is there any possibility to change datatype of a
field.
regards,
S Baskar
dear hal,
I Guess Application layer interfaces like (libpq,libpq++ etc)
exists for talking to it?
regds
mallah.
On Saturday 25 May 2002 03:44 am, Hal Lynch wrote:
> Can someone give me a clue as to where I find
> docs, howto, etc on how to talk to the postgresql backend
> through port 5432?
>
Hi Fred,
I have only two hardisks and no HW card.
how can i utilize them best?
i do not want to loose data one fine day
discovering one my SCSI havaing DB
has failed.:-(
should i run database on only 1 18GB scsi and
pg_dump every 6 hrs my critical tables
on other machine (which has not
"Fred Moyer" <[EMAIL PROTECTED]>(by way of Rajesh Kumar Mallah.
<[EMAIL PROTECTED]>) writes:
> use raid 10 (striping with mirroring) if you have more than 2 hard
> disks. much faster than raid 1.
Is there any rhyme or reason to the various "RAID n" designations?
Or were they just invented on th
use raid 10 (striping with mirroring) if you have more than 2 hard
disks. much faster than raid 1.
> Hi
>
> I am setting up a new database server.
> the data is critical that is why i am thniking
> to mirror the SCSI disks in RAID 1 configuration.
>
> I do not have a hardware raid controller.
>
Good Morning Mallah,
I've heard bad things from a friend that worked at IBM about using RAID and
databases. He said there could be a definite performance hit with a
hardware raid controller doing RAID5, so i can only imagine that software
raid would be worse :(. Mirroring should be as bad, but i
I would use hardware RAID level 1 for performance reasons.
Egon
"Rajesh Kumar Mallah." wrote:
> Hi
>
> I am setting up a new database server.
> the data is critical that is why i am thniking
> to mirror the SCSI disks in RAID 1 configuration.
>
> I do not have a hardware raid controller.
>
> cou
Hi all,
I went through pg_hba.conf, I tried to change
'local' and 'Host' permissions.
I gave permissions like
local all
password
host all x.x.x.x x.x.x.x password
if i tried to login using my database password i
got an error like 'password authentication failed'.
can any bod
Can someone give me a clue as to where I find
docs, howto, etc on how to talk to the postgresql backend
through port 5432?
hal
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
"Rajesh Kumar Mallah." wrote:
> I am setting up a new database server.
> the data is critical that is why i am thniking
> to mirror the SCSI disks in RAID 1 configuration.
> I do not have a hardware raid controller.
If it's that critical, you would be wise to go buy a hardware RAID
controller.
>
Rajesh Kumar Mallah. wrote:
> Hi
>
> I am setting up a new database server.
> the data is critical that is why i am thniking
> to mirror the SCSI disks in RAID 1 configuration.
>
> I do not have a hardware raid controller.
>
> could anyone give me some pointer , or suggest me
> if its advisable
On Fri, 24 May 2002, shreedhar wrote:
> How can i drop a foreign key relation. In my database I gave reverse
> relation ships which i should alter.
You'll need to drop the three triggers that are created by the
foreign key constraint. If you go to techdocs.postgresql.org there
are some pages on
Hi
I am setting up a new database server.
the data is critical that is why i am thniking
to mirror the SCSI disks in RAID 1 configuration.
I do not have a hardware raid controller.
could anyone give me some pointer , or suggest me
if its advisable to use RAID 1 with database servers.
thanks
On Thu, May 23, 2002 at 11:20:27PM -0400, Jeff Kowalczyk wrote:
> I made a dumb mistake, and forgot to write down the autogenerated
> administrator password when I first started the Postgres database on
> RedHat 7.3. I'm having a hard time finding information on how to do this
> online, and it's a
Hi all,
How can i drop a foreign key relation. In my
database I gave reverse relation ships which i should alter.
thanks alot,
with best regards,
baskar
15 matches
Mail list logo
