Find Jobs
Hire Freelancers

Database admin

$25-50 USD / hour

Fechado
Publicado há 7 meses

$25-50 USD / hour

I have an issue with timescale db 1. From db logs hosted in kubernetes env WARNING: oldest multixact is far in the past HINT: Close open transactions with multixacts soon to avoid wraparound problems. WARNING: oldest xmin is far in the past HINT: Close open transactions soon to avoid wraparound problems. You might also need to commit or roll back old prepared transactions, or drop stale replication slots. 2 when querying one table or vacuuming this table called features in the db, can query other tables ERROR: [data-timescale-data-2]: multixact "members" limit exceeded SQL state: 54000 Detail: This command would create a multixact with 15 members, but the remaining space is only enough for 0 members. Hint: Execute a database-wide VACUUM in database with OID 16384 with reduced vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age settings. I don’t have recent backup and cannot afford to loose data, can you help resolve it? Synopsis - We have a timescaledb that internally uses postgres12.7. It is running on a kubernetes cluster hosted in AWS. We used helm to deploy this Db. I am connected currently to it through pdadmin4. This db has 5 tables, i am able to query all the tables but one. When i query that table, it gives me an error 2 (multixact "members" limit exceeded) When i check the logs of the db i.e container logs i see error 1. There are 3 replicas i.e three pods running. Two pods are throwing error 1. i have tried vacuum it but was unsuccesful, unable to understand how to resolve this issue i need help recovering this table and adjust parameters that will suit the db, that way we can continue our normal operations. Right now, i have disabled any data flow into the db. So taking downtime, cannot afford it
ID do Projeto: 37335604

Sobre o projeto

28 propostas
Projeto remoto
Ativo há 6 meses

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
28 freelancers estão ofertando em média $37 USD/hora for esse trabalho
Avatar do Usuário
Hello Good afternoon , I hope you are doing great. Just finished reading the brief details of your job . I see you have been looking for a freelancer who has experience with MySQL, Database Administration, SQL, Database Development and Database Programming. Upon the first look I feel confident about getting it done because of having experience doing similar jobs My Experience? I have 9 years of experience working with those technologies. Its been 8 years since I have been working on freelancer.com, Please review my profile. Check: Skills, Portfolio, Customer Feedbacks. Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern US Time I would like you to start the chat so we could discuss it in detail and we will continue from there. Thanks! Awais
$25 USD em 29 dias
5,0 (13 avaliações)
6,3
6,3
Avatar do Usuário
I have extensive experience in SQL database administration and I am confident that I can handle the complete administration of your SQL database. With over 10+ years of experience in various web development technologies, including PHP, Python, and Node.js, I have gained a deep understanding of SQL databases. I have a strong expertise in SQL database administration and have successfully managed and maintained SQL databases in the past. I am skilled in performance tuning and optimization techniques, ensuring that your database runs smoothly and efficiently. Additionally, I am familiar with backup and recovery processes, which will ensure the safety and security of your data. I am also experienced in troubleshooting and resolving issues related to database tables. With my knowledge and expertise, I am confident that I can resolve the current errors you are facing with your database. Please take a moment to review my profile for feedback and portfolio. I would appreciate the opportunity to discuss your project in more detail. Let's start chatting and find the best solutions for your database administration needs.
$40 USD em 7 dias
5,0 (3 avaliações)
5,3
5,3
Avatar do Usuário
Hi. I'm Kundan Bihari. As the project description I guess you're facing problem with PG and Vaccum. Please look for any long running open transaction and Kil it. Get the help of Google to do it. I hope the problem will be fixed. Thanks.
$60 USD em 40 dias
5,0 (33 avaliações)
5,1
5,1
Avatar do Usuário
Dear Prakyathbittu,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in SQL, MySQL, Database Administration, Database Programming, Database Development and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details or let's appoint time for Zoom meeting to meet and discuss your project in details.    Best regards, Sales department Tangram Canada Inc.   
$35 USD em 5 dias
5,0 (7 avaliações)
4,8
4,8
Avatar do Usuário
I am going to start work right now. I have strong expertise in SQL database administration. I'll address the current issues with your SQL database, specifically regarding multixacts and query problems. With my experience, I'll ensure the smooth administration and optimization of your database.
$38 USD em 40 dias
5,0 (5 avaliações)
4,5
4,5
Avatar do Usuário
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..
$50 USD em 1376 dias
5,0 (1 avaliação)
3,6
3,6
Avatar do Usuário
Hello, I am Muhammad Abdullah from ABDULLAH TECH LTD, and I understand that you are looking for a skilled database administrator who can help you with complete administration of a SQL database. From my experience of 5 years in various fields, I believe I am the perfect person for the job. I have extensive knowledge in providing dedicated assistance for both Linux and Windows systems, as well as performance tuning and optimization techniques. Additionally, I have experience in managing and maintaining SQL databases, as well as in backup and recovery processes. Therefore, I am confident that I can provide the necessary skills to successfully complete this project. I would be delighted to discuss further if you are interested. Please feel free to contact me directly if you require any additional information or clarification on anything discussed here
$25 USD em 40 dias
5,0 (10 avaliações)
3,6
3,6
Avatar do Usuário
Hi there, I'm bidding on your project "Database admin " Being a professional electrical engineer, I can do this project for you. please leave a message on my chat so we can discuss the budget and deadline of the project. Also, have a look at my profile for my reviews and portfolios. Thanks Note: This is not an automated bid and i'm ready to discuss your project right now. .. .
$50 USD em 798 dias
5,0 (2 avaliações)
3,4
3,4
Avatar do Usuário
I have extensive experience in SQL database administration, including PostgreSQL and TimescaleDB. I can help resolve the current issues with your database, such as addressing the oldest multixact and xmin warnings and mitigating the "multixact limit exceeded" error. My expertise includes optimizing database performance, managing transactions, and adjusting configuration settings to prevent wraparound problems. I will work diligently to ensure your database operates smoothly and efficiently. Let's collaborate to resolve these issues and enhance your database's performance.
$38 USD em 40 dias
5,0 (1 avaliação)
3,1
3,1
Avatar do Usuário
hello i am available to work on this task, and i have 6+ years experience in it and web devloppment contact me for more details on the task in chat am available to work on it. best regards
$38 USD em 40 dias
5,0 (2 avaliações)
2,7
2,7
Avatar do Usuário
Hi, Database admin PrakyathbittuSQL, MySQL, Database Administration, Database Programming, Database DevelopmentSQLUnited States We are an expert team which have many years of experience on SQL, MySQL, Database Administration, Database Programming, Database Development Lets connect in chat so that We discuss further. Regards
$37 USD em 7 dias
0,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
Prakyathbittu! Nice to meet you The project "Database admin " seems great and I want to work with you. I am an expert who has many years of experience on SQL, MySQL, Database Administration, Database Programming, Database Development so I am sure that I am a god fit for your project. And as an expert, I have enough energies and powers to do your projects. Lets connect in chat so that We discuss further. Thank You
$34 USD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am ready to get start work right now... I specialize in creating user-friendly data collection forms that enhance precision and efficiency. Additionally, I have extensive knowledge of database administration tools such as SQL, which will be useful for you on this project. With my skillset I am confident that I can help you complete your project completely by administering and optimizing your SQL database. I understand that you are looking for a skilled database administrator who can help you with complete administration of a SQL database. I believe that I am the perfect candidate for this job because of my strong expertise in SQL database administration, experience in managing and maintaining SQL databases, knowledge of performance tuning and optimization techniques as well as an ability to troubleshoot and resolve issues related to database tables.
$38 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello! My name is Soham and I am a skilled and experienced developer with expertise in Opencart, Wordpress, Prestashop, and all ecommerce site development. With over 5 years of experience in the industry, I have honed my skills in creating responsive and user-friendly websites that not only look great but also function seamlessly. I understand that you are looking for a database administrator who can help you with complete administration of a SQL database. Specifically, I have strong expertise in SQL database administration, experience managing and maintaining SQL databases, knowledge of performance tuning and optimization techniques, ability to troubleshoot and resolve issues related to database tables, as well as familiarity with backup and recovery processes. I believe that I am the right person for the job. Please do not hesitate to contact me if you would like to discuss further or need any additional information for making an informed decision on whether or not I would be the best fit for this project. Thank you for your time!
$30 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello! I'm a skilled database administrator experienced in SQL database administration. I have expertise in managing and maintaining SQL databases, performance tuning, optimization techniques, backup and recovery processes, and troubleshooting database table issues. Regarding the current issues you mentioned: 1. The warning messages about the oldest multixact and xmin being far in the past indicate potential wraparound problems. To resolve this, it's important to close any open transactions with multixacts and close open transactions to avoid wraparound problems. Additionally, consider committing or rolling back old prepared transactions and dropping stale replication slots. 2. The error related to the "multixact" limit being exceeded when querying or vacuuming the "features" table suggests that there is limited space available for multixacts. To address this, I recommend executing a database-wide VACUUM in the database with OID 16384, with reduced settings for vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age. I'm confident that with my expertise in SQL database administration, I can help resolve these issues and provide comprehensive administration for your SQL database. Let's discuss further to understand your specific requirements and how we can work together to ensure the smooth operation of your database.
$25 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, Hoping you doing well. I'm glad to submit my proposal for your project. I have 5 years of experience with developing websites. I have rich experience in database management, front-end and back-end technology. As a full stack developer, I'm good at various programming languages, web technologies and frameworks. I have extensive experience in designing, developing and testing web applications. I'm available to start working immediately and l would love to discuss about detail for project including price and timeline. If you have any questions please contact to me. Thanks for considering my proposal.
$30 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I understand from your description that you are looking for a professional with strong expertise in SQL database administration who can help you with complete administration of a SQL database. I believe I am the perfect fit for this project as I have the skills needed to get the job done right. I have extensive experience in database development and MySQL specifically which will be needed for this project. Additionally, I have knowledge of performance tuning and optimization techniques which will be needed to ensure optimal performance of your database system. My experience in healthcare industry gives me insight into healthcare integration processes which will be necessary for this project to run smoothly. I believe I am the best fit for this job due to my skillset and experience which will result in a successful outcome for both parties. Please let me know if you would like more information about me or any other topic related to this project so we can move forward together! Thank you
$38 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I understand you are looking for a skilled database administrator who can help you with complete administration of a SQL database. With my experience of more than 7 years in designing, developing and programming websites, mobile applications I believe I am the best fit for this project. My skills include strong expertise in SQL database administration, experience in managing and maintaining SQL databases and knowledge of performance tuning and optimization techniques. Additionally, I have knowledge of backup and recovery processes. Therefore I believe I am the best choice for you as I can handle all aspects of database administration effectively. I would be delighted to discuss this project further with you if given the opportunity. Please let me know if you need any additional information or would like me to present any further details regarding my skills or experience in any other way. Regards Raza
$38 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I'm an IT expert with more than 20 years of experience in the IT industry . I'm Cisco Certified networking professional 300-100 and 300-115 and Linux Certified Professional lpi 101, 102,103 and red hat certified system administrator and VMware Certified Professional 4, 5,5.5 and Data Center and Microsoft System administrateur /Engineer ranging from 2003 to 2012 .
$50 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Charlotte, United States
0,0
0
Membro desde out. 20, 2023

Verificação do Cliente

Outros trabalhos deste cliente

Database admin -- 2
min $50 USD / hour
Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.