Thanks. I checked and hard links are not supported by the NAS. Will look into getting another disk.
Yes, should upgrade out of 8.3. Thanks again. Claire ---- On Mon, 18 Feb 2013 08:21:19 -0800 Magnus Hagander <mag...@hagander.net> wrote ---- On Fri, Feb 15, 2013 at 6:25 PM, Claire McLister <mclis...@zeesource.net> wrote: > Hi there, > > We recently copied over our 8.3 database cluster files from a local disk to > a network attached storage drive. > > Everything seemed to work okay for a while until we got this error: > > ERROR: could not link file "pg_xlog/00000001000000AA00000030" to > "pg_xlog/00000001000000AA00000096" (initialization of log file 170, segment > 150): Operation not supported > > pg_xlog/00000001000000AA00000096 does not exist in the original file tree, > so I'm wondering if there's some special link that PG is trying to create > that is not permitted in the NAS drive? That's a regular (hard) link. Whether it's supported or not would depend on your NAS, but it certainly looks like it's not supported by yours - or you need different mount options. For example, if your NAS runs something Windows-based, it's likely not supporting links at all. Note that putting the data directory on a NAS is in general not a good idea - it's very easy to get corruption that way, unless you are very careful. > This is for Postgresql 8.3 + PostGIS 1.5 Also, do note that PostgreSQL 8.3 is no longer supported - see http://www.postgresql.org/support/versioning/. You should look into upgrading ASAP. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
