Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[Stephen Frost]

* Albe Laurenz (laurenz.a...@wien.gv.at) wrote:
> Marllius wrote:
> > OCFS2 = oracle cluster file system 2
> 
> I think using OCFS2 for PostgreSQL data is a good idea if you want
> to be the first at something or try to discover bugs in OCFS2.

I've found that OCFS2 is a very decent clustered filesystem for smallish
environments (4 or 8).  We had trouble with larger clusters.

> Why do you want a cluster file system for PostgreSQL?  You cannot
> have more than one server access the same data at the same time
> anyway.

This is probably the better question.  Using a clustered filesystem can
be handy for redundancy, and you could use OCFS2 or DRDB for that, but
don't expect to be able to run multiple PG servers concurrently from the
same set of data files.

Thanks!

Stephen


signature.asc
Description: Digital signature

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[Marllius]

Thanks guys, the answers helped me a lot in my decision , I'm evaluating my
options.

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[John R Pierce]

On 4/8/2016 6:16 AM, Marllius wrote:

thank you, but i need a link in official postgresql documentation



as postgresql is operating system independent, its pretty unlikely there 
will be discussions of specific file systems in the official documentation.




--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[Albe Laurenz]

Marllius wrote:
> OCFS2 = oracle cluster file system 2

I think using OCFS2 for PostgreSQL data is a good idea if you want
to be the first at something or try to discover bugs in OCFS2.

Why do you want a cluster file system for PostgreSQL?  You cannot
have more than one server access the same data at the same time
anyway.

Yours,
Laurenz Albe

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[John R Pierce]

On 4/8/2016 7:20 AM, Scott Mead wrote:


I'm not sure if that link exists, the general rule is In g if it's 
POSIX, it'll work. You'll find that most PostgreSQL-ers have strong 
opinions and preferences in regards to filesystems.   Personally, I 
know that XFS will work, it's not *my* preference, but, to each their own.



and my experience is that in RHEL 6 and 7, XFS works very well, and IS 
my preference for data volumes.




--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[Scott Mead]

On Fri, Apr 8, 2016 at 9:16 AM, Marllius  wrote:

> thank you, but i need a link in official postgresql documentation
>

I'm not sure if that link exists, the general rule is In g if it's POSIX,
it'll work. You'll find that most PostgreSQL-ers have strong opinions and
preferences in regards to filesystems.   Personally, I know that XFS will
work, it's not *my* preference, but, to each their own.


>
> OCFS2 = oracle cluster file system 2
>
>
2016-04-08 10:00 GMT-03:00 Bob Lunney :
>
>> XFS absolutely does.  Its well supported on Redhat and CentOS 6.x and
>> 7.x.  Highly recommended.
>>
>> Don’t know about OCFS2.
>>
>> Bob Lunney
>> Lead Data Architect
>> MeetMe, Inc.
>>
>> > On Apr 8, 2016, at 8:56 AM, Marllius  wrote:
>> >
>> > Hi guys!
>> >
>> > The OCFS2 and XFS have compatibility with postgresql 9.3.4?
>> >
>>
>
I did some experimentation with ocfs2 back about 7 or 8 years ago
(admittedly, a Big-Bang away, so keep that in mind when reading my
comments).  At the time, OCFS2 was *mostly* POSIX compatible and would
indeed work with Postgres.  What we found (again, at the time) is that
OCFS2 started to have performance problems and eventually a race condition
when using a large number of [relatively] small files.  I believe the DB I
was working on had 10's of databases, each with 1,000+ tables in it, so,
lots of files.  It was really designed for use with Oracle (small number of
large files) and was passed over in favor of ASM.

If it were me, I'd stay away from OCFS2 for anything except Oracle (and in
that case, I'd use ASM).


> > I was looking the documentation but i not found it.
>> >
>> >
>> >
>>
>>
>
>
> --
> Atenciosamente,
>
> Márllius de Carvalho Ribeiro
>

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[Marllius]

thank you, but i need a link in official postgresql documentation

OCFS2 = oracle cluster file system 2

2016-04-08 10:00 GMT-03:00 Bob Lunney :

> XFS absolutely does.  Its well supported on Redhat and CentOS 6.x and
> 7.x.  Highly recommended.
>
> Don’t know about OCFS2.
>
> Bob Lunney
> Lead Data Architect
> MeetMe, Inc.
>
> > On Apr 8, 2016, at 8:56 AM, Marllius  wrote:
> >
> > Hi guys!
> >
> > The OCFS2 and XFS have compatibility with postgresql 9.3.4?
> >
> > I was looking the documentation but i not found it.
> >
> >
> >
>
>


-- 
Atenciosamente,

Márllius de Carvalho Ribeiro

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

[Bob Lunney]

XFS absolutely does.  Its well supported on Redhat and CentOS 6.x and 7.x.  
Highly recommended.

Don’t know about OCFS2.

Bob Lunney
Lead Data Architect
MeetMe, Inc.

> On Apr 8, 2016, at 8:56 AM, Marllius  wrote:
> 
> Hi guys!
> 
> The OCFS2 and XFS have compatibility with postgresql 9.3.4? 
> 
> I was looking the documentation but i not found it.
> 
> 
> 



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Postgresql 9.3.4 file system compatibility

[Marllius]

Hi guys!

The OCFS2 and XFS have compatibility with postgresql 9.3.4?

I was looking the documentation but i not found it.