On 12/10/2014 01:00 PM, Adrian Klaver wrote:
On 12/10/2014 09:54 AM, Gabriel Sánchez Martínez wrote:
On 12/10/2014 12:47 PM, Adrian Klaver wrote:
On 12/10/2014 09:25 AM, Gabriel Sánchez Martínez wrote:
On 12/10/2014 11:49 AM, Adrian Klaver wrote:
On 12/10/2014 08:31 AM, Gabriel Sánchez Martínez wrote:
On 12/10/2014 11:16 AM, Adrian Klaver wrote:
On 12/10/2014 08:07 AM, Gabriel Sánchez Martínez wrote:
Hi all,
Also how did the Postgres server get installed?
apt-get install
Install from what repo?
The default Ubuntu repository.
What was the exact package installed?
I don't recall, but it was probably "postgresql".
Try:
dpkg -l|grep postgresql
to get the actual package.
Output is :
ii postgresql 9.3+154 all
object-relational SQL database (supported version)
ii postgresql-9.3 9.3.5-0ubuntu0.14.04.1 amd64
object-relational SQL database, version 9.3 server
ii postgresql-9.3-pgrouting 2.0.0-release-ppa1~trusty1
amd64 Routing functionality support for PostgreSQL/PostGIS
ii postgresql-9.3-postgis-2.1 2.1.2+dfsg-2
amd64 Geographic objects support for PostgreSQL 9.3
ii postgresql-9.3-postgis-2.1-scripts
2.1.2+dfsg-2 all PostGIS for
PostgreSQL 9.3 -- scripts -- dummy package
ii postgresql-9.3-postgis-scripts 2.1.2+dfsg-2
all Geographic objects support for PostgreSQL 9.3 -- scripts
ii postgresql-client-9.3 9.3.5-0ubuntu0.14.04.1
amd64 front-end programs for PostgreSQL 9.3
ii postgresql-client-common 154
all manager for multiple PostgreSQL client versions
ii postgresql-common 154 all
PostgreSQL database-cluster manager
ii postgresql-contrib 9.3+154
all additional facilities for PostgreSQL (supported version)
ii postgresql-contrib-9.3 9.3.5-0ubuntu0.14.04.1
amd64 additional facilities for PostgreSQL
ii postgresql-server-dev-9.3 9.3.5-0ubuntu0.14.04.1
amd64 development files for PostgreSQL 9.3 server-side programming
The database was
upgraded to 9.3 when Ubuntu was upgraded to 14.04. But I ran it for a
while without issues. This issue is recent.
So what was the version before?
9.1. It has always been whatever was on the Ubuntu repos.
Where I am going with this, is trying to determine whether you have a
'contaminated' data directory.
I appreciate it! Perhaps it is worth mentioning that the server had
some issues with the linux md raid a while back. Two disks failed in
quick succession and some data was corrupted. Those disks have been
replaced and the RAID has been fine ever since. The database cluster
was recreated from scratch after that, from backups of a few months
before the disks started misbehaving. This is when that table was
created with pg_restore. There were no issues with the restore, and the
backup was from a few months before the disk issue, so I don't suspect
corruption in the backup.
Was there another instance of Postgres already(or currently) installed
on this machine?
No. There has always been only one instance.
Thanks in advance,
Gabriel
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
