Find Jobs
Hire Freelancers

PostGres Expert Needed -2

$2-50 USD / hour

Closed
Posted about 6 years ago

$2-50 USD / hour

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.
Project ID: 16014686

About the project

4 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $22 USD/hour for this job
User Avatar
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 industries like telecom, healthcare, IT, Education to name a few. FullStack: JAVA, Python, Golang, JavaScript, Java, R, Hadoop, Kafka Database: PostgreSQL, OracleDB, Dynamo, Cassandra, Hbase WebApp Server: Nginx, ApacheTomcat, Node.Js, Weblogic Spring, Flask, Expressjs, Reactjs build tools Maven Ivy, Ant Linux, AWS, Azure Price quoted is ballpark. Please share details to discuss about your project.
$28 USD in 40 days
5.0 (9 reviews)
4.2
4.2
User Avatar
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 proc stat? At first look thats NOT pgsql problem . Regards, Alexander
$38 USD in 10 days
5.0 (6 reviews)
3.1
3.1
User Avatar
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 environment including PgPool plus some automatization tasks.
$5 USD in 8 days
5.0 (2 reviews)
1.2
1.2

About the client

Flag of UNITED STATES
Chicago, United States
5.0
1
Payment method verified
Member since Nov 13, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.