Closed

PostGres Expert Needed -2

Please read this post in its entirety before bidding..

1.) DO NOT RESPOND if you are NOT an expert with PostgreSQL

2.) DO NOT RESPOND If your profile does not have anything about architecting or supporting a PostgreSQL Database

3.) I will not be able to send you anything from the database, everything will be done via screen sharing. It will be a collaborative session with my engineers. If this is not acceptable DO NOT RESPOND

I need a person that is an expert with PostgreSQL to help us troubleshoot an issue with a database upgrade and to help us with performance tuning of the database and server. Our current system we need assistance on is:

CentOS Linux release 7.2.1511 (Core)

psql (PostgreSQL) 9.4.9

The issue we are experiencing is:

When trying to create a Foreign key Constraint from a newly created table (FOO) to a certain existing table (BAR) the process goes into waiting. We are able to successfully create foreign keys to any other table except this one, For example table FOO with a Foreign key to BUU works successfully. When trying to reindex BAR the process goes into waiting. I believe the table BAR is corrupt, although I can successfully select from the table.

Skills: Database Administration, Hadoop, Linux, MySQL, PostgreSQL

See more: postgresql commercial support, pgx services, postgresql consul, postgresql support, 2ndquadrant, sharepoint server installation expert needed, clickbank expert needed, net graphics expert needed, j2me expert needed, php web scraping expert needed, zen cart expert needed, mod rewrite expert needed, linux expert needed, digg expert needed, volusion expert needed

About the Employer:
( 1 review ) Chicago, United States

Project ID: #16014686

5 freelancers are bidding on average $18/hour for this job

khannanav

We are an exceptionally competent team with an average experience of 10+ years in various fields of Information Technology. We have rich experience working with PostgreSql. We have worked with clients across industrie More

$28 USD / hour
(8 Reviews)
4.2
axprof

Hi! I've seen your problem on freelancer before. In order to help you (without any reason) i'd tell that $5/hr and expert (as you write) are incompatible things. Could you please show you query execution plan an pgsql More

$38 USD / hour
(2 Reviews)
2.8
lemarin68

Database Administrator, 8 years experience, infrastructure dba, for SQL Server, PostgreSQL. Recently focused with AWS and virtualization, my last good experience with PostgreSQL 9.2 and 9.3 include configuring HA envi More

$5 USD / hour
(2 Reviews)
1.2
wangzistar2000

Thank you for your post. I have read your project details. I have a wealth of experience in writing large projects using PHP, JS, CSS, and HTML5. I have a team and my team has abundant experience. I am interested i More

$5 USD / hour
(0 Reviews)
0.0
$16 USD / hour
(0 Reviews)
0.0