Ubuntu
postgresql-common package

Remove the postgresql package without problems, without encountering the problem "Error: / var/lib/postgresql/8.4/main is not accessible or does not exist"

Asked by Glody Fimpa

Hello, I have a problem with the package postgresql-common. I accidentally deleted the file postgresql.conf in the directory / etc/postgresql/8.4/main, I tried to change the port because I had two versions of postgresql, 8.4 and 9.1. After nothing was not working anymore, not even 9.1. I decided to remove all the packages postgresql but not removed because it tells me that
"Error: / var/lib/postgresql/8.4/main is not accessible or does not exist." But I remember not having deleted this file. What should I do to remove all the postgresql package without any problems and reinstall it after?

PS: Because even after I installed the postgresql-9.3 which works well with the database but not with PHP5 and apache server.

Thanks !

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu postgresql-common Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

Did you try using touch to make the missing file?
Does it actually exist?

Revision history for this message
Manfred Hampl (m-hampl) said : 		#2

What is the output of the terminal command

dpkg -l | grep postgresql

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#3

I ran the command. He appeared to me the list of postgresql. But what is this command? Is not helping me at all

Envoyé depuis Windows Mail

De : Manfred Hampl
Envoyé : ‎lundi‎ ‎13‎ ‎janvier‎ ‎2014 ‎13‎:‎16
À : Glody Fimpa

Your question #242065 on postgresql-common in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065

Manfred Hampl requested more information:
What is the output of the terminal command

dpkg -l | grep postgresql

--
To answer this request for more information, you can either reply to
this email or enter your reply at the following page:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065

You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#4

That command should list the status (installed / not installed) of the postgresql packages.
For helping you, we need some information about your system. So please paste the output into this question document that we can see it. Then we can try finding a solution for your problem.

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#5

figlody@figlody-laptop:~$ dpkg -l | grep postgresql
iU postgresql 9.1+129ubuntu1 object-relational SQL database (supported version)
iU postgresql-9.1 9.1.11-0ubuntu0.12.04 object-relational SQL database, version 9.1 server
ii postgresql-client-9.1 9.1.11-0ubuntu0.12.04 front-end programs for PostgreSQL 9.1
ii postgresql-client-common 129ubuntu1 manager for multiple PostgreSQL client versions
iF postgresql-common 129ubuntu1 PostgreSQL database-cluster manager

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #242065]: Remove the postgresql package without problems, without encountering the problem "Error: / var/lib/postgresql/8.4/main is not accessible or does not exist"
> Date: Sat, 18 Jan 2014 17:06:21 +0000
>
> Your question #242065 on postgresql-common in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> Status: Open => Needs information
>
> Manfred Hampl requested more information:
> That command should list the status (installed / not installed) of the postgresql packages.
> For helping you, we need some information about your system. So please paste the output into this question document that we can see it. Then we can try finding a solution for your problem.
>
> --
> To answer this request for more information, you can either reply to
> this email or enter your reply at the following page:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#6

Thank you for providing the output. It shows that some of the postgresql packages are in an unhealthy state.

Please execute the following commands in a terminal and copy/paste all output as done before.

ps ax | grep postgresql
sudo dpkg --audit
sudo dpkg --configure -a

(Note: This most probably will not solve your problem, but should provide some more detail information that hopefully will help finding the solution.)

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#7

figlody@figlody-laptop:~$ ps ax | grep postgresql
 2640 pts/0 S+ 0:00 grep --color=auto postgresql
figlody@figlody-laptop:~$ sudo dpkg --audit
The following packages have been unpacked but not yet configured.
They must be configured using dpkg --configure or the configure
menu option in dselect for them to work:
 postgresql object-relational SQL database (supported version)
 postgresql-9.1 object-relational SQL database, version 9.1 server

The following packages are only half configured, probably due to problems
configuring them the first time. The configuration should be retried using
dpkg --configure <package> or the configure menu option in dselect:
 postgresql-common PostgreSQL database-cluster manager

figlody@figlody-laptop:~$ sudo dpkg --configure -a
Setting up postgresql-common (129ubuntu1) ...
/bin/df: `/var/lib/postgresql/9.1/main': No such file or directory
/bin/df: no file systems processed
 * Starting PostgreSQL 9.1 database server * Error: /var/lib/postgresql/9.1/main is not accessible or does not exist
                                                                         [fail]
invoke-rc.d: initscript postgresql, action "start" failed.
dpkg: error processing postgresql-common (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql-9.1:
 postgresql-9.1 depends on postgresql-common (>= 115~); however:
  Package postgresql-common is not configured yet.
dpkg: error processing postgresql-9.1 (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql:
 postgresql depends on postgresql-9.1; however:
  Package postgresql-9.1 is not configured yet.
dpkg: error processing postgresql (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 postgresql-common
 postgresql-9.1
 postgresql
figlody@figlody-laptop:~$

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #242065]: Remove the postgresql package without problems, without encountering the problem "Error: / var/lib/postgresql/8.4/main is not accessible or does not exist"
> Date: Mon, 20 Jan 2014 07:41:29 +0000
>
> Your question #242065 on postgresql-common in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> Status: Open => Needs information
>
> Manfred Hampl requested more information:
> Thank you for providing the output. It shows that some of the postgresql
> packages are in an unhealthy state.
>
> Please execute the following commands in a terminal and copy/paste all
> output as done before.
>
> ps ax | grep postgresql
> sudo dpkg --audit
> sudo dpkg --configure -a
>
> (Note: This most probably will not solve your problem, but should
> provide some more detail information that hopefully will help finding
> the solution.)
>
> --
> To answer this request for more information, you can either reply to
> this email or enter your reply at the following page:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#8

It seems to me that the best approach is to try completely removing all postgresql packages, and then to start installing the required packages again.

Try the terminal command

sudo dpkg -P postgresql-common postgresql-9.1 postgresql postgresql-client-9.1 postgresql-client-common

and copy/paste all output into this question document as done before.

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#9

I used the command three times in the first two cases came out a different output than the one below. At the third and last time, was released this output that I posted below:

figlody@figlody-laptop:~$ sudo dpkg -P postgresql-common postgresql-9.1 postgresql postgresql-
[sudo] password for figlody:
Sorry, try again.
[sudo] password for figlody:
dpkg: warning: there's no installed package matching postgresql-common
dpkg: warning: there's no installed package matching postgresql-9.1
dpkg: warning: there's no installed package matching postgresql
dpkg: warning: there's no installed package matching postgresql-

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #242065]: Remove the postgresql package without problems, without encountering the problem "Error: / var/lib/postgresql/8.4/main is not accessible or does not exist"
> Date: Mon, 20 Jan 2014 13:01:29 +0000
>
> Your question #242065 on postgresql-common in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> Status: Open => Answered
>
> Manfred Hampl proposed the following answer:
> It seems to me that the best approach is to try completely removing all
> postgresql packages, and then to start installing the required packages
> again.
>
> Try the terminal command
>
> sudo dpkg -P postgresql-common postgresql-9.1 postgresql postgresql-
> client-9.1 postgresql-client-common
>
> and copy/paste all output into this question document as done before.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065/+confirm?answer_id=7
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#10

Some of the packages have already been successfully deinstalled, but it sees that the command has been truncated, so please try again with:

sudo dpkg -P postgresql-client-9.1 postgresql-client-common
dpkg -l | grep postgresql

and copy/paste all output as done before.

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#11

This is the output after the two commands:

figlody@figlody-laptop:~/java_lab$ sudo dpkg -P postgresql-client-9.1 postgresql-client-common
[sudo] password for figlody:
(Reading database ... 251864 files and directories currently installed.)
Removing postgresql-client-9.1 ...
dpkg: warning: while removing postgresql-client-9.1, directory '/usr/share/postgresql/9.1' not empty so not removed.
Removing postgresql-client-common ...
Purging configuration files for postgresql-client-common ...
Processing triggers for man-db ...
figlody@figlody-laptop:~/java_lab$ dpkg -l | grep postgresql
figlody@figlody-laptop:~/java_lab$

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #242065]: Remove the postgresql package without problems, without encountering the problem "Error: / var/lib/postgresql/8.4/main is not accessible or does not exist"
> Date: Tue, 21 Jan 2014 06:51:14 +0000
>
> Your question #242065 on postgresql-common in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> Status: Open => Answered
>
> Manfred Hampl proposed the following answer:
> Some of the packages have already been successfully deinstalled, but it
> sees that the command has been truncated, so please try again with:
>
> sudo dpkg -P postgresql-client-9.1 postgresql-client-common
> dpkg -l | grep postgresql
>
> and copy/paste all output as done before.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065/+confirm?answer_id=9
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#12

Now there is no postgresql package installed on your system any more.
You can now decide which version you want, and should try installing that.

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#13

So everything is resolved. Postgresql -8.4 -9.1 e have all been uninstalled??

Thank you so much !!!

Inviata da Windows Mail

Da: <email address hidden>
Data invio: ‎mercoledì‎ ‎22‎ ‎gennaio‎ ‎2014 ‎22‎:‎41
A: Glody Fimpa

Your question #242065 on postgresql-common in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065

    Status: Open => Answered

Manfred Hampl proposed the following answer:
Now there is no postgresql package installed on your system any more.
You can now decide which version you want, and should try installing that.

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065/+confirm?answer_id=11

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065

You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#14

To be exact: There is no postgresql package installed any more that had been installed from Ubuntu/Debian sources. If you have installed a postgesql package manually (downloaded from postgesql.org and compiled from source etc.), that might still be there.

To check for any remnants, I recommend issuing the following commands:

sudo updatedb
locate postgresql

Please copy/paste all output as done before.

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#15

This is the output after you run the two commands :

/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Guayaquil
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Guyana
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Halifax
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Havana
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Hermosillo
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indianapolis
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Inuvik
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Iqaluit
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Jamaica
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Jujuy
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Juneau
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Kentucky
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Knox_IN
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Kralendijk
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/La_Paz
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Lima
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Los_Angeles
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Louisville
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Lower_Princes
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Maceio
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Managua
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Manaus
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Marigot
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Martinique
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Matamoros
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Mazatlan
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Mendoza
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Menominee
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Merida
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Metlakatla
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Mexico_City
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Miquelon
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Moncton
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Monterrey
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Montevideo
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Montreal
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Montserrat
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Nassau
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/New_York
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Nipigon
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Nome
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Noronha
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/North_Dakota
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Ojinaga
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Panama
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Pangnirtung
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Paramaribo
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Phoenix
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Port-au-Prince
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Port_of_Spain
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Porto_Acre
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Porto_Velho
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Puerto_Rico
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Rainy_River
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Rankin_Inlet
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Recife
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Regina
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Resolute
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Rio_Branco
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Rosario
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Santa_Isabel
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Santarem
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Santiago
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Santo_Domingo
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Sao_Paulo
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Scoresbysund
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Shiprock
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Sitka
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/St_Barthelemy
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/St_Johns
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/St_Kitts
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/St_Lucia
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/St_Thomas
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/St_Vincent
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Swift_Current
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Tegucigalpa
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Thule
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Thunder_Bay
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Tijuana
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Toronto
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Tortola
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Vancouver
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Virgin
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Whitehorse
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Winnipeg
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Yakutat
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Yellowknife
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Buenos_Aires
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Catamarca
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/ComodRivadavia
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Cordoba
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Jujuy
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/La_Rioja
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Mendoza
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Rio_Gallegos
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Salta
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/San_Juan
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/San_Luis
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Tucuman
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Argentina/Ushuaia
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Indianapolis
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Knox
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Marengo
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Petersburg
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Tell_City
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Vevay
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Vincennes
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Indiana/Winamac
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Kentucky/Louisville
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/Kentucky/Monticello
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/North_Dakota/Beulah
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/North_Dakota/Center
/opt/PostgreSQL/9.3/share/postgresql/timezone/America/North_Dakota/New_Salem
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Casey
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Davis
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/DumontDUrville
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Macquarie
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Mawson
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/McMurdo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Palmer
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Rothera
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/South_Pole
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Syowa
/opt/PostgreSQL/9.3/share/postgresql/timezone/Antarctica/Vostok
/opt/PostgreSQL/9.3/share/postgresql/timezone/Arctic/Longyearbyen
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Aden
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Almaty
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Amman
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Anadyr
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Aqtau
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Aqtobe
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ashgabat
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ashkhabad
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Baghdad
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Bahrain
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Baku
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Bangkok
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Beirut
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Bishkek
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Brunei
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Calcutta
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Choibalsan
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Chongqing
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Chungking
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Colombo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Dacca
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Damascus
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Dhaka
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Dili
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Dubai
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Dushanbe
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Gaza
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Harbin
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Hebron
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ho_Chi_Minh
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Hong_Kong
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Hovd
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Irkutsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Istanbul
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Jakarta
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Jayapura
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Jerusalem
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kabul
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kamchatka
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Karachi
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kashgar
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kathmandu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Katmandu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Khandyga
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kolkata
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Krasnoyarsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kuala_Lumpur
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kuching
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Kuwait
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Macao
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Macau
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Magadan
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Makassar
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Manila
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Muscat
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Nicosia
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Novokuznetsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Novosibirsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Omsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Oral
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Phnom_Penh
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Pontianak
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Pyongyang
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Qatar
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Qyzylorda
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Rangoon
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Riyadh
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Riyadh87
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Riyadh88
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Riyadh89
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Saigon
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Sakhalin
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Samarkand
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Seoul
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Shanghai
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Singapore
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Taipei
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Tashkent
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Tbilisi
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Tehran
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Tel_Aviv
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Thimbu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Thimphu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Tokyo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ujung_Pandang
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ulaanbaatar
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ulan_Bator
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Urumqi
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Ust-Nera
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Vientiane
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Vladivostok
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Yakutsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Yekaterinburg
/opt/PostgreSQL/9.3/share/postgresql/timezone/Asia/Yerevan
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Azores
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Bermuda
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Canary
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Cape_Verde
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Faeroe
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Faroe
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Jan_Mayen
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Madeira
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Reykjavik
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/South_Georgia
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/St_Helena
/opt/PostgreSQL/9.3/share/postgresql/timezone/Atlantic/Stanley
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/ACT
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Adelaide
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Brisbane
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Broken_Hill
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Canberra
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Currie
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Darwin
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Eucla
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Hobart
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/LHI
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Lindeman
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Lord_Howe
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Melbourne
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/NSW
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/North
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Perth
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Queensland
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/South
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Sydney
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Tasmania
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Victoria
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/West
/opt/PostgreSQL/9.3/share/postgresql/timezone/Australia/Yancowinna
/opt/PostgreSQL/9.3/share/postgresql/timezone/Brazil/Acre
/opt/PostgreSQL/9.3/share/postgresql/timezone/Brazil/DeNoronha
/opt/PostgreSQL/9.3/share/postgresql/timezone/Brazil/East
/opt/PostgreSQL/9.3/share/postgresql/timezone/Brazil/West
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Atlantic
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Central
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/East-Saskatchewan
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Eastern
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Mountain
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Newfoundland
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Pacific
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Saskatchewan
/opt/PostgreSQL/9.3/share/postgresql/timezone/Canada/Yukon
/opt/PostgreSQL/9.3/share/postgresql/timezone/Chile/Continental
/opt/PostgreSQL/9.3/share/postgresql/timezone/Chile/EasterIsland
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+0
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+1
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+10
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+11
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+12
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+2
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+3
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+4
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+5
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+6
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+7
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+8
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT+9
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-0
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-1
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-10
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-11
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-12
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-13
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-14
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-2
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-3
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-4
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-5
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-6
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-7
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-8
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT-9
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/GMT0
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/Greenwich
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/UCT
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/UTC
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/Universal
/opt/PostgreSQL/9.3/share/postgresql/timezone/Etc/Zulu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Amsterdam
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Andorra
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Athens
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Belfast
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Belgrade
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Berlin
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Bratislava
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Brussels
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Bucharest
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Budapest
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Busingen
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Chisinau
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Copenhagen
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Dublin
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Gibraltar
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Guernsey
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Helsinki
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Isle_of_Man
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Istanbul
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Jersey
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Kaliningrad
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Kiev
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Lisbon
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Ljubljana
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/London
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Luxembourg
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Madrid
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Malta
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Mariehamn
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Minsk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Monaco
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Moscow
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Nicosia
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Oslo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Paris
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Podgorica
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Prague
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Riga
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Rome
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Samara
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/San_Marino
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Sarajevo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Simferopol
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Skopje
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Sofia
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Stockholm
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Tallinn
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Tirane
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Tiraspol
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Uzhgorod
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Vaduz
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Vatican
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Vienna
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Vilnius
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Volgograd
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Warsaw
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Zagreb
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Zaporozhye
/opt/PostgreSQL/9.3/share/postgresql/timezone/Europe/Zurich
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Antananarivo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Chagos
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Christmas
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Cocos
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Comoro
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Kerguelen
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Mahe
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Maldives
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Mauritius
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Mayotte
/opt/PostgreSQL/9.3/share/postgresql/timezone/Indian/Reunion
/opt/PostgreSQL/9.3/share/postgresql/timezone/Mexico/BajaNorte
/opt/PostgreSQL/9.3/share/postgresql/timezone/Mexico/BajaSur
/opt/PostgreSQL/9.3/share/postgresql/timezone/Mexico/General
/opt/PostgreSQL/9.3/share/postgresql/timezone/Mideast/Riyadh87
/opt/PostgreSQL/9.3/share/postgresql/timezone/Mideast/Riyadh88
/opt/PostgreSQL/9.3/share/postgresql/timezone/Mideast/Riyadh89
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Apia
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Auckland
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Chatham
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Chuuk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Easter
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Efate
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Enderbury
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Fakaofo
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Fiji
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Funafuti
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Galapagos
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Gambier
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Guadalcanal
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Guam
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Honolulu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Johnston
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Kiritimati
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Kosrae
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Kwajalein
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Majuro
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Marquesas
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Midway
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Nauru
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Niue
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Norfolk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Noumea
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Pago_Pago
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Palau
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Pitcairn
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Pohnpei
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Ponape
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Port_Moresby
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Rarotonga
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Saipan
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Samoa
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Tahiti
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Tarawa
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Tongatapu
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Truk
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Wake
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Wallis
/opt/PostgreSQL/9.3/share/postgresql/timezone/Pacific/Yap
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Alaska
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Aleutian
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Arizona
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Central
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/East-Indiana
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Eastern
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Hawaii
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Indiana-Starke
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Michigan
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Mountain
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Pacific
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Pacific-New
/opt/PostgreSQL/9.3/share/postgresql/timezone/US/Samoa
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Africa.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/America.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Antarctica.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Asia.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Atlantic.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Australia
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Australia.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Default
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Etc.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Europe.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/India
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Indian.txt
/opt/PostgreSQL/9.3/share/postgresql/timezonesets/Pacific.txt
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/danish.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/dutch.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/english.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/finnish.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/french.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/german.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/hungarian.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/hunspell_sample.affix
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/ispell_sample.affix
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/ispell_sample.dict
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/italian.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/norwegian.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/portuguese.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/russian.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/spanish.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/swedish.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/synonym_sample.syn
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/thesaurus_sample.ths
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/turkish.stop
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/unaccent.rules
/opt/PostgreSQL/9.3/share/postgresql/tsearch_data/xsyn_sample.rules
/usr/share/postgresql
/usr/share/applications/pg-doc-postgresql-9_3.desktop
/usr/share/applications/pg-doc-postgresql-releasenotes-9_3.desktop
/usr/share/desktop-directories/pg-postgresql-9_3.directory
/usr/share/icons/hicolor/32x32/apps/pg-postgresql-9_3.png
/usr/share/postgresql/9.1
/usr/share/postgresql/9.1/tsearch_data
/usr/share/postgresql/9.1/tsearch_data/en_au.affix
/usr/share/postgresql/9.1/tsearch_data/en_au.dict
/usr/share/postgresql/9.1/tsearch_data/en_ca.affix
/usr/share/postgresql/9.1/tsearch_data/en_ca.dict
/usr/share/postgresql/9.1/tsearch_data/en_gb.affix
/usr/share/postgresql/9.1/tsearch_data/en_gb.dict
/usr/share/postgresql/9.1/tsearch_data/en_us.affix
/usr/share/postgresql/9.1/tsearch_data/en_us.dict
/usr/share/postgresql/9.1/tsearch_data/en_za.affix
/usr/share/postgresql/9.1/tsearch_data/en_za.dict
/usr/share/postgresql/9.1/tsearch_data/es.affix
/usr/share/postgresql/9.1/tsearch_data/es.dict
/usr/share/postgresql/9.1/tsearch_data/fr.affix
/usr/share/postgresql/9.1/tsearch_data/fr.dict
/usr/share/postgresql/9.1/tsearch_data/he.affix
/usr/share/postgresql/9.1/tsearch_data/he.dict
/usr/share/postgresql/9.1/tsearch_data/it_it.affix
/usr/share/postgresql/9.1/tsearch_data/it_it.dict
/usr/share/postgresql/9.1/tsearch_data/pt.affix
/usr/share/postgresql/9.1/tsearch_data/pt.dict
/usr/share/postgresql/9.1/tsearch_data/pt_br.affix
/usr/share/postgresql/9.1/tsearch_data/pt_br.dict
/usr/share/postgresql/9.1/tsearch_data/sw_tz.affix
/usr/share/postgresql/9.1/tsearch_data/sw_tz.dict
/usr/share/postgresql/9.1/tsearch_data/xh_za.affix
/usr/share/postgresql/9.1/tsearch_data/xh_za.dict
/var/cache/apt/archives/postgresql-9.1_9.1.11-0ubuntu0.12.04_i386.deb
/var/cache/apt/archives/postgresql_9.1+129ubuntu1_all.deb
/var/crash/postgresql-common.0.uploaded
/var/lib/postgresql
/var/lib/postgresql/8.4
/var/lib/postgresql/8.4/main
/var/lib/update-rc.d/postgresql-8.4
/var/lib/update-rc.d/postgresql-9.3
figlody@figlody-laptop:~$

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #242065]: Remove the postgresql package without problems, without encountering the problem "Error: / var/lib/postgresql/8.4/main is not accessible or does not exist"
> Date: Thu, 23 Jan 2014 06:46:14 +0000
>
> Your question #242065 on postgresql-common in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> Status: Open => Answered
>
> Manfred Hampl proposed the following answer:
> To be exact: There is no postgresql package installed any more that had
> been installed from Ubuntu/Debian sources. If you have installed a
> postgesql package manually (downloaded from postgesql.org and compiled
> from source etc.), that might still be there.
>
> To check for any remnants, I recommend issuing the following commands:
>
> sudo updatedb
> locate postgresql
>
> Please copy/paste all output as done before.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065/+confirm?answer_id=13
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065
>
> You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#16

This shows, that there are remainders of (at least) three different postgresql packages on your system (8.4, 9.1, 9.3).

Can you remember how you have installed postgresql-9.3?
I assume you have downloaded a zipped source file and installed with a "make install" command or something like that.
To clean that up you have to deinstall that program with a "make uninstall" command or similar.

Since you did not use the standard Ubuntu package but some other source, it is not possible to provide exact instructions.

Revision history for this message
Glody Fimpa (glodyfimpa) said : 		#17

Ok. What about the remains of -8.4 and -9.1 Postgresql that are still in my PC, how do I remove them ??

Inviata da Windows Mail

Da: <email address hidden>
Data invio: ‎venerdì‎ ‎24‎ ‎gennaio‎ ‎2014 ‎09‎:‎01
A: Glody Fimpa

Your question #242065 on postgresql-common in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065

    Status: Open => Answered

Manfred Hampl proposed the following answer:
This shows, that there are remainders of (at least) three different
postgresql packages on your system (8.4, 9.1, 9.3).

Can you remember how you have installed postgresql-9.3?
I assume you have downloaded a zipped source file and installed with a "make install" command or something like that.
To clean that up you have to deinstall that program with a "make uninstall" command or similar.

Since you did not use the standard Ubuntu package but some other source,
it is not possible to provide exact instructions.

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065/+confirm?answer_id=15

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/postgresql-common/+question/242065

You received this question notification because you asked the question.

Revision history for this message
Manfred Hampl (m-hampl) said : 		#18

It seems that the output of the locate command has been truncated, and the first part is missing.

The remainders of postgresql 9.1 that are visible in the list can be deleted with the terminal commands

sudo rm -rf /usr/share/postgresql/9.1
sudo rm /var/cache/apt/archives/postgresql*

and for 8.4

sudo rm -rf /var/lib/postgresql/8.4
sudo rm /var/lib/update-rc.d/postgresql-8.4

but I am not sure whether there aren't more files that were not shown in the truncated list.
When you have removed postgresql 9.3 you should run the terminal commands

sudo updatetdb
locate postgresql

again to check if there are some more.

Can you help with this problem?

Provide an answer of your own, or ask Glody Fimpa for more information if necessary.

To post a message you must log in.