On 12/1/15 10:26 AM, Scott Mead wrote:
The data directory will cause you many problems. You will need one data
directory that is accessed by one AND ONLY one host for each node
connected. You can't run an instance on multiple machines pointing to
the same 'data' directory simultaneously. Data di
Thanks for the info Scott.
Can I setup a primary server called A that uses the Postgres installation
on a nfs mounted filesystem and then A does a daily backup of database A
and restores to database B on same filesystem.
Then I have server B acting as cold standby and if server A goes down, then
On 12/01/2015 09:16 AM, anj patnaik wrote:
Thanks for the info Scott.
Can I setup a primary server called A that uses the Postgres
installation on a nfs mounted filesystem and then A does a daily backup
of database A and restores to database B on same filesystem.
Then I have server B acting as
> On Nov 30, 2015, at 12:54, anj patnaik wrote:
>
> 1) directory listing:
>
> /opt/nfsDir/postgres/9.4/
> /bin
> /data
> /etc
>/pgAdmin3
>
1) directory listing:
/opt/nfsDir/postgres/9.4/
/bin
/data
/etc
/pgAdmin3
2) The way I am using PG now is that I ha
Hello,
Yes, postgres is currently installed on a nfs mounted file system. So when
graphical installer runs, there is a form which asks location for
installation. I specified this path /opt/nfsDir/Postgres where nfsDir is a
nfs mount. So currently this is where PG 9.4 lives.
My question is when I a
On 11/30/2015 09:54 AM, anj patnaik wrote:
1) directory listing:
/opt/nfsDir/postgres/9.4/
/bin
/data
/etc
/pgAdmin3
On 11/27/2015 01:17 PM, anj patnaik wrote:
Hello,
Yes, postgres is currently installed on a nfs mounted file system. So
when graphical installer runs, there is a form which asks location for
installation. I specified this path /opt/nfsDir/Postgres where nfsDir is
a nfs mount. So currently this is
On 11/27/2015 01:17 PM, anj patnaik wrote:
Hello,
Yes, postgres is currently installed on a nfs mounted file system. So
when graphical installer runs, there is a form which asks location for
installation. I specified this path /opt/nfsDir/Postgres where nfsDir is
a nfs mount. So currently this is
On 11/25/2015 10:28 AM, anj patnaik wrote:
Hello all,
I've got 2 more questions. The cron job is now setup and email gets
generated with proper body.
I've one setup with NFS which appears to work smoothly. Now soon, I will
be given a Linux VM on a different physical server, but will retain my
NF
anj patnaik wrote:
> I've got 2 more questions. The cron job is now setup and email gets generated
> with proper body.
>
> I've one setup with NFS which appears to work smoothly. Now soon, I will be
> given a Linux VM on a
> different physical server, but will retain my NFS mount. I've installed
Hello all,
I've got 2 more questions. The cron job is now setup and email gets
generated with proper body.
I've one setup with NFS which appears to work smoothly. Now soon, I will be
given a Linux VM on a different physical server, but will retain my NFS
mount. I've installed Postgres 9.4 using th
On Jun 21, 2011, at 7:49 AM, Vick Khera wrote:
> Ok...there is *one* advantage:
> you can lose any two drives at the same time and still survive, with
> RAID-10 if you lose the wrong two drives you're hosed.
Exactly. The performance advantage of RAID-10 over RAID-6 in this sever is, I
think, not
On Fri, Jun 17, 2011 at 1:35 PM, Scott Ribe wrote:
> RAID-1 & RAID-10 are not ruled out, I'm just exploring options. And I'm not
> actually wanting to use RAID 5; it's RAID 6 that I'm considering...
You have 4 disk bays and you want RAID-6? How will that improve
anything over RAID-10? You will
On Fri, Jun 17, 2011 at 1:20 PM, Scott Marlowe wrote:
> Pluses for the Arecas I've used:
> Out Of Band monitoring. Heck, I've updated the firmware on them from
> 1000 miles away.
> fast in RAID-10. Lots of HW controllers (I'm looking at you, LSI)
> perform poorly with layered RAID.
> They all us
On Jun 17, 2011, at 11:23 PM, Greg Smith wrote:
> I guess you could call Highpoint a RAID manufacturer, but I wouldn't do so.
> They've released so many terrible problems over the years that it's hard to
> take the fact that they may have something reasonable you can buy now (the
> 43XX cards
On 06/17/2011 01:02 PM, Scott Ribe wrote:
1) Is my impression correct that given a choice between Areca& Highpoint, it's
a no-brainer to go with Areca?
I guess you could call Highpoint a RAID manufacturer, but I wouldn't do
so. They've released so many terrible problems over the years t
On Fri, Jun 17, 2011 at 11:35 AM, Scott Ribe
wrote:
> It's small enough that there's some other things going on at the same small
> server with 4 disk bays ;-) My thinking was that write-back cache might
> mitigate the poor write performance enough to not be noticed. This db doesn't
> generally
On Jun 17, 2011, at 11:20 AM, Scott Marlowe wrote:
> Generally, yes, but the model of the card is more important than the
> maker. I.e. an Areca 1880 or 1680 is a fantastic performer. But the
> older 1120 series aren't gonna set the world on fire or anything.
And, in further digging, I discover
Thanks much for the specific info on Areca RAID cards. Very helpful.
On Jun 17, 2011, at 11:20 AM, Scott Marlowe wrote:
> The problem with RAID-5 is crappy write performance. Being big or
> small won't change that. Plus if the db is small why use RAID-5?
It's small enough that there's some oth
On Fri, Jun 17, 2011 at 11:02 AM, Scott Ribe
wrote:
> No responses to my earlier post, I'm assuming because OS X experience is
> rather thin in this group ;-) So a couple of more specific questions:
>
> 1) Is my impression correct that given a choice between Areca & Highpoint,
> it's a no-braine
No responses to my earlier post, I'm assuming because OS X experience is rather
thin in this group ;-) So a couple of more specific questions:
1) Is my impression correct that given a choice between Areca & Highpoint, it's
a no-brainer to go with Areca?
2) I understand why RAID 5 is not general
Hi,
I'm using vs2005 to debug PG, and I have 2 questions to ask:
1. I want to add a function to contrib/xml2/xpath.c I changed xpath.c,
pgxml.sql, pgxml.sql.in at the same time, then I builded and installed as the
document said.When I execute "psql test < pgxml.sql", all functions created
Hi,I'm using vs2005 to debug PG, and I have 2 questions to ask:1. I want to add
a function to contrib/xml2/xpath.c I changed xpath.c, pgxml.sql, pgxml.sql.in
at the same time, then I builded and installed as the document said.When I
execute "psql test < pgxml.sql", all functions created s
Jason Tesser wrote:
There's an example in the manuals - chapter "7.2.1.4. Table Functions"
SELECT *
FROM dblink('dbname=mydb', 'select proname, prosrc from pg_proc')
AS t1(proname name, prosrc text)
WHERE proname LIKE 'bytea%';
So basically, you need to supply the type definitions in
>
> There's an example in the manuals - chapter "7.2.1.4. Table Functions"
>
> SELECT *
> FROM dblink('dbname=mydb', 'select proname, prosrc from pg_proc')
>AS t1(proname name, prosrc text)
> WHERE proname LIKE 'bytea%';
>
> So basically, you need to supply the type definition
Jason Tesser wrote:
OK here is an example of a function where I had to create a type called
login.
How could I have written this function without having to create a type.
CREATE OR REPLACE FUNCTION "public"."loginbyindidget" (integer) RETURNS
SETOF "public"."login" AS'
[snip]
There's an example in
OK here is an example of a function where I had to create a type called
login.
How could I have written this function without having to create a type.
CREATE OR REPLACE FUNCTION "public"."loginbyindidget" (integer) RETURNS
SETOF "public"."login" AS'
declare
iindid alias for $1;
returnRec RECORD;
Jason Tesser wrote:
1. i have a few funcions that depend on a type. i don't want to have to srop
every function just so I can drop the type and recreat everything.
Is there a better way to do this in Postgres?
Not really - if you're redefining the type then the functions really
have to be recrea
1. i have a few funcions that depend on a type. i don't want to have to srop
every function just so I can drop the type and recreat everything.
Is there a better way to do this in Postgres?
2. The reason I had to create my own type was because record didn't ork for me
when I was selecting data
30 matches
Mail list logo