pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedThe reference to 'atacontrol' on FreeBSD is outdated.
6+ messages / 5 participants
[nested] [flat]
* The reference to 'atacontrol' on FreeBSD is outdated.
@ 2017-08-08 22:40 jrekins@gmail.com
0 siblings, 1 reply; 6+ messages in thread
From: jrekins@gmail.com @ 2017-08-08 22:40 UTC (permalink / raw)
To: pgsql-docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/wal-reliability.html
Description:
Hi,
On this page:
https://www.postgresql.org/docs/9.6/static/wal-reliability.html
... there is a reference to 'atacontrol' on FreeBSD: 'On FreeBSD, IDE drives
can be queried using atacontrol...'
This command was deprecated in FreeBSD 9.0 which was released in January
2012. Here is a link to the relevant man page highlighting its obsolesence:
https://www.freebsd.org/cgi/man.cgi?query=atacontrol&sektion=8&apropos=0&man...
The 'camcontrol' is the replacement.
Thanks,
J.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The reference to 'atacontrol' on FreeBSD is outdated.
@ 2017-08-11 19:51 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: jrekins@gmail.com
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2017-08-11 19:51 UTC (permalink / raw)
To: jrekins@gmail.com; pgsql-docs
On 8/8/17 18:40, jrekins@gmail.com wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/wal-reliability.html
> Description:
>
> Hi,
>
> On this page:
> https://www.postgresql.org/docs/9.6/static/wal-reliability.html
>
> ... there is a reference to 'atacontrol' on FreeBSD: 'On FreeBSD, IDE drives
> can be queried using atacontrol...'
>
> This command was deprecated in FreeBSD 9.0 which was released in January
> 2012. Here is a link to the relevant man page highlighting its obsolesence:
> https://www.freebsd.org/cgi/man.cgi?query=atacontrol&sektion=8&apropos=0&man...
>
> The 'camcontrol' is the replacement.
Could you supply a new phrasing of that paragraph? Does camcontrol now
handle both IDE and SCSI?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The reference to 'atacontrol' on FreeBSD is outdated.
@ 2017-08-12 21:47 John Ekins <jrekins@gmail.com>
parent: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 6+ messages in thread
From: John Ekins @ 2017-08-12 21:47 UTC (permalink / raw)
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; +Cc: pgsql-docs
Hi,
Sure. Camcontrol does indeed cover IDE, SCSI and SAS drives.
Replace this line:
On FreeBSD, IDE drives can be queried using atacontrol...
With this:
On FreeBSD, IDE drives can be queried using camcontrol identify...
In other words, the query is the same as for SCSI drives. For verification this is what the output looks like:
root@bsd11desk:/home/jre # camcontrol identify 0:0:0 | egrep "Feature|write cache"
Feature Support Enabled Value Vendor
write cache yes yes
I appreciate the Postgresql docs are not meant to be FreeBSD tutorials.
Thanks,
J.
> On 11 Aug 2017, at 20:51, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
>
> On 8/8/17 18:40, jrekins@gmail.com wrote:
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/docs/9.6/static/wal-reliability.html
>> Description:
>>
>> Hi,
>>
>> On this page:
>> https://www.postgresql.org/docs/9.6/static/wal-reliability.html
>>
>> ... there is a reference to 'atacontrol' on FreeBSD: 'On FreeBSD, IDE drives
>> can be queried using atacontrol...'
>>
>> This command was deprecated in FreeBSD 9.0 which was released in January
>> 2012. Here is a link to the relevant man page highlighting its obsolesence:
>> https://www.freebsd.org/cgi/man.cgi?query=atacontrol&sektion=8&apropos=0&man...
>>
>> The 'camcontrol' is the replacement.
>
> Could you supply a new phrasing of that paragraph? Does camcontrol now
> handle both IDE and SCSI?
>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachments:
[application/pgp-signature] signature.asc (841B, ../../E1F09343-9031-4351-9837-1C5FA8055A7E@gmail.com/3-signature.asc)
download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [DOCS] The reference to 'atacontrol' on FreeBSD is outdated.
@ 2023-11-22 01:11 Bruce Momjian <bruce@momjian.us>
parent: John Ekins <jrekins@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 2023-11-22 01:11 UTC (permalink / raw)
To: John Ekins <jrekins@gmail.com>; +Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-docs
On Sat, Aug 12, 2017 at 10:47:00PM +0100, John Ekins wrote:
> Hi,
>
> Sure. Camcontrol does indeed cover IDE, SCSI and SAS drives.
>
> Replace this line:
> On FreeBSD, IDE drives can be queried using atacontrol...
>
> With this:
> On FreeBSD, IDE drives can be queried using camcontrol identify...
>
> In other words, the query is the same as for SCSI drives. For verification this
> is what the output looks like:
>
> root@bsd11desk:/home/jre # camcontrol identify 0:0:0 | egrep "Feature|write
> cache"
> Feature Support Enabled Value Vendor
> write cache yes yes
>
> I appreciate the Postgresql docs are not meant to be FreeBSD tutorials.
I know this email is six years old, but I have applied this fix to all
supported Postgres versions. A huge apology for this delay.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [DOCS] The reference to 'atacontrol' on FreeBSD is outdated.
@ 2023-11-22 02:25 Thomas Munro <thomas.munro@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 6+ messages in thread
From: Thomas Munro @ 2023-11-22 02:25 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: John Ekins <jrekins@gmail.com>; Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-docs
On Wed, Nov 22, 2023 at 2:12 PM Bruce Momjian <bruce@momjian.us> wrote:
> On Sat, Aug 12, 2017 at 10:47:00PM +0100, John Ekins wrote:
> > Sure. Camcontrol does indeed cover IDE, SCSI and SAS drives.
> >
> > Replace this line:
> > On FreeBSD, IDE drives can be queried using atacontrol...
> >
> > With this:
> > On FreeBSD, IDE drives can be queried using camcontrol identify...
> >
> > In other words, the query is the same as for SCSI drives. For verification this
> > is what the output looks like:
> >
> > root@bsd11desk:/home/jre # camcontrol identify 0:0:0 | egrep "Feature|write
> > cache"
> > Feature Support Enabled Value Vendor
> > write cache yes yes
> >
> > I appreciate the Postgresql docs are not meant to be FreeBSD tutorials.
>
> I know this email is six years old, but I have applied this fix to all
> supported Postgres versions. A huge apology for this delay.
It's funny that we discuss IDE drives at all. They stopped being
manufactured a decade ago and are not supported by modern chipsets or
boards etc[1]. I've been meaning to do something about that, but I
didn't have enough round tuits to research what to write about current
storage technologies... but also in the case of FreeBSD, it doesn't
let you turn the write cache on and off with nvmecontrol yet, but
someone has a relevant patch out (D32700) so I was also waiting for
that to go somewhere before writing in...
[1] https://en.wikipedia.org/wiki/Parallel_ATA#Primacy_and_obsolescence
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [DOCS] The reference to 'atacontrol' on FreeBSD is outdated.
@ 2023-11-22 02:36 Bruce Momjian <bruce@momjian.us>
parent: Thomas Munro <thomas.munro@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2023-11-22 02:36 UTC (permalink / raw)
To: Thomas Munro <thomas.munro@gmail.com>; +Cc: John Ekins <jrekins@gmail.com>; Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-docs
On Wed, Nov 22, 2023 at 03:25:07PM +1300, Thomas Munro wrote:
> On Wed, Nov 22, 2023 at 2:12 PM Bruce Momjian <bruce@momjian.us> wrote:
> > On Sat, Aug 12, 2017 at 10:47:00PM +0100, John Ekins wrote:
> > > Sure. Camcontrol does indeed cover IDE, SCSI and SAS drives.
> > >
> > > Replace this line:
> > > On FreeBSD, IDE drives can be queried using atacontrol...
> > >
> > > With this:
> > > On FreeBSD, IDE drives can be queried using camcontrol identify...
> > >
> > > In other words, the query is the same as for SCSI drives. For verification this
> > > is what the output looks like:
> > >
> > > root@bsd11desk:/home/jre # camcontrol identify 0:0:0 | egrep "Feature|write
> > > cache"
> > > Feature Support Enabled Value Vendor
> > > write cache yes yes
> > >
> > > I appreciate the Postgresql docs are not meant to be FreeBSD tutorials.
> >
> > I know this email is six years old, but I have applied this fix to all
> > supported Postgres versions. A huge apology for this delay.
>
> It's funny that we discuss IDE drives at all. They stopped being
> manufactured a decade ago and are not supported by modern chipsets or
> boards etc[1]. I've been meaning to do something about that, but I
> didn't have enough round tuits to research what to write about current
> storage technologies... but also in the case of FreeBSD, it doesn't
> let you turn the write cache on and off with nvmecontrol yet, but
> someone has a relevant patch out (D32700) so I was also waiting for
> that to go somewhere before writing in...
I don't think it is safe to disable the nvme cache since it is a cache
and a staging area. If you turn it off, it will burn out the chips over
time.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-11-22 02:36 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-08-08 22:40 The reference to 'atacontrol' on FreeBSD is outdated. jrekins@gmail.com
2017-08-11 19:51 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2017-08-12 21:47 ` John Ekins <jrekins@gmail.com>
2023-11-22 01:11 ` Bruce Momjian <bruce@momjian.us>
2023-11-22 02:25 ` Thomas Munro <thomas.munro@gmail.com>
2023-11-22 02:36 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox