Postgres Database + AWS RDS | Django (3.0) Crash Course Tutorials (pt 21)

[@DennisIvy]

Don't forget to check out my Complete Django course! dub.sh/NvGboTI

[@adamh2250]

So glad I found Dennis Ivy. Its easy to find good Django tutorial for beginners but its hard to find solid intermediate tutorials for Django. This really helps get to the next level and see how it all comes together. Thanks

[@DennisIvy]

Thank you Adam :) A lot of my videos are still somewhat basic but I do plan on going into much deeper topics and advanced projects. Appreciate your comment :)

[@louzynerd129]

when i press save at 4:57 i get this error: Unable to connect to server: FATAL: password authentication failed for user "postgres" what can i do?

[@Pimvrolijks]

@@louzynerd129 I dont know if you have solved this already. I had the same issue but if I recall correclty you get a prompt in which you can reset your master password. That fixed it for me..

[@ahmadsaadeddin9035]

For those who are getting this error: "... Connection timed out", these are what I did to solve the problem: from top right change zone N. California work with me then - Go to "Security group rules" (under "Connectivity & security") - Click the item "default" Security group - Click "Actions" > "Edit inbound rules" > "Add rule" - Select... Type: "All traffic", Source: "My IP", then click "Save rules"

[@tusifuedison5867]

this solution absolutely worked with me, thank you so much

[@louzynerd129]

so i have to recreate the data base?

[@louzynerd129]

it still gives the same error, what do i do

[@pauladeniyi5876]

This works for me. Thanks

[@phucutube]

Thanks man!

[@alter.nativotech3823]

Why haven't I found this earlier!! Thanks Dennis, you're rocking it in the Django Community man. I've seen you in Traversy Media also. Awesome association.

[@CarryDepie]

For those who are getting this error: "... Connection timed out (0x0000274C/10060)", these are what I did to solve the problem: - Go to "Security group rules" (under "Connectivity & security") - Click the item "default" Security group - Click "Actions" > "Edit inbound rules" > "Add rule" - Select... Type: "All traffic", Source: "My IP", then click "Save rules"

[@mediatwinkleTV]

Dude, you've been a real blessing ! I'l be using RDS in production ! Thx

[@louzynerd129]

The tables are not showing up even though i migrated and everything was Ok in the command prompt idk what's the issue here please help someone.

[@japsimransingh9933]

@@louzynerd129 try to refresh the tables

[@keanemafika2290]

Did u work on it during production? If so can u please give me tips on the configurations, which settings I must be aware of when I'm configuring, I'm sure some mistakes may prove costly. I'll be trying it soon too

[@network2901]

Your tutorials are really very interesting, your videos are now my reference in django, thanx really man for this excellent work, hope one day see a tutorial to connect django to mangodb and work with it. thanx a lot.

[@DennisIvy]

I'm honed to hear that Kamal! I'll definitely make a video on this in the near future since I still primary build in django but want to switch my database to Mongo DB. I'll share after I master it.

[@Copt774]

dude thank you so much for this project and for continuing to add content - you earned this subscriber!

[@vishnusingh4118]

I'm so glad YT recommended this to me. Most tutorials are about the basic stuff, default settings with sqlite. You explain how to take this from ground up to real-time, production level stuff in a crystal clear way. In one video, you introduced the viewer to both postgres and AWS effortlessly. Thanks a lot Dennis! More power to you man!

[@fahansheikh]

For my lads with ubuntu or similar....you might have postgres already installed in your system....installing some other version over the existing one can create unnecessary trouble for beginners(like me).....check if you have it installed in your system already....if you want to upgrade delete the previous one or make necessary settings for proper functioning

[@kibi4979]

Thank you Dennis. You are a winner in Django/Python technology! All of your videos are very interesting!

[@tjdud2651]

This is exactly what i'm looking for

[@Pimvrolijks]

Hi Dennis, First thank you for your clear tutorials! I first tried to set this up using Azure SQL server but that was giving me a lot of problems. I added the postgres to the other ecommerce tutorial you've made. One remark with that one. When the cart is checked with the total in the form to set the order to complete the values do not match anymore. For instance 23.4 is regarded not equal to 23.40. So setting both values to the same data type (for instance float) did solve it for me.

[@justicepeltier9001]

Thank you for making these tutorials. They are absolutely exceptional!

[@enricosaccheggiani3192]

Thanks so much with your help I have connected my project with a aws database. Thanks a lot

[@JackHeidz]

Congrats Dennis! I didnt know about free tier option.

[@Kmaw777]

Hi Dennis, PostgreSQL for Amazon RDS isn't free, at least not anymore. There is no option to select free tier when creating the database, and if you scroll at the bottom it will say how much a month it costs.

[@rajendrachoudhary9098]

There is a free tier option there

[@jackieyu3008]

I also encountered the same problem

[@sebastiansilvavidal452]

Hi, did you solve the problem?

[@Kmaw777]

@@sebastiansilvavidal452 I did not check back on this guide. Does it still require payment?

[@deaglannolan8468]

I got the PostgreSQL database to work, but now it wont let me log in with my existing users. How do you get the existing users into the postgreSQL database?

[@abhish8395]

Hey @deaglannolan8468 were you able to resolve this issue? I have the same problem after I migrated to Postgresql

[@danielampey9131]

Getting error in linking rds to my pgadmin. Unable to connect to server: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "xxxxxxxxxxxxxxxxxxxxxxxxxxx" (xx.xxx.xxx.xx) and accepting TCP/IP connections on port 5432?

[@RiccardoDiBiagio88]

have you solved it?

[@danielampey9131]

@@RiccardoDiBiagio88 Yes, added AWS location to settings.py

[@ElvisMunteanu]

@@RiccardoDiBiagio88 I did not :(

[@jorjolandes]

​@@danielampey9131 Could you be a little bit more specific please? What do you mean with AWS location, for example: us-east-2b? And we have to add it to which setting of the settings file? Thanks beforehand!

[@danielampey9131]

@@jorjolandes Ok sure. So you will add: AWS_S3_HOST = 's3.us-east-2.amazonaws.com' and AWS_S3_REGION_NAME = 'us-east-2' in your settings.py. However, 'us-east-2' is my location, you have to change to your location. I hope this solves your issue.

[@muhammadmiraj1203]

wow that is awesome. Perfectly understood everything in this video. Thanks for that.

[@abhikhatri5414]

I also subscribed to ur channel... I liked the way u r explaining... However, I think u r missing something that matters much for understanding to minimize the error during the project using ur follow-up guidelines step-by-step by those users who are completely new to Django... The way u r explaining is quite good for those who have already evolved into Django... I do hope u will figure this out and make ur video tutorial the best one... I watched all the parts, all parts are very good enough contents and enough explanations as well... One seriously following ur guidelines will definitely develop a Django app and deploy for the production grade.....

[@sreerajpr4555]

Love and respect from Kerala, India.

[@priyanshuparashar7548]

Kerala, nepal

[@shayhalfon5460]

Amazing tutorial! Any chance you add a video on how to track visits and store the visitor data?

[@louzynerd129]

The tables are not showing up even though i migrated and everything was Ok in the command prompt idk what's the issue here please help someone.

[@muneerahmed2629]

Hi Dennis, I'm simply not able to connect the postgres to AWS. I followed all your instructions yet it says "Error Saving Properties. Unable to connect to server: timeout expired." Any ideas why I might be getting this error. Any help would be much appreciated! Thanks.

[@МихаилКалашников-е9т]

I've got the same problem

[@DennisIvy]

If its the error I think your getting then its probably because you forgot to allow "Public accessibility". I talk about this at 11:20. This means you haven't set permissions to access the database outside of AWS. Is this error happening when connecting from PG Admin.

[@cesarjaramillo9455]

@@DennisIvy First of all, thank you for putting out this great content. Been following the series since the beginning, and almost done. But I am having the same issue. I followed along and even made sure to give permission to access the database outside of AWS. I deleted the database and tried again, but still same issue. I tried finding other solutions online, but also no luck. If you have any suggestions I would appreciate it much. Thanks, and looking forward to all the good content to come.

[@salmixH2o]

@@DennisIvy same problem for me too UPDATE: I've solved my problem! I've uninstalled postgresql, then I've re-installed both postgresql and pgAdmin and now it works, don't ask me why. When the db in AWS is created, now I notice that my first security group type is 'CIDR/IP - Inbound', while before it was 'EC2 something'...

[@elmerperez724]

Guys did you find the problem ? I did, I edit the inbound rules

[@billywilliamvanheerden8558]

Great job! thank you so much, I appreciate the amazing videos.

[@celloucisse7548]

Thanks for this video. It has been very helpfull. I have an issue: after creating my database in aws and setting my database configuration in my project, I still getting errors while running migration. #connection error

[@jarvis1707]

Hey guys, I can't seem to install and configure postgresql and Pgadmin4 them to work. I'm using Ubuntu operaring system. Any help is appreciate. So far i've been liking the tutorials; great stuff, no ghost code, everything explained in details. Thanks Dennis

[@mosouley]

Hi Dennis, i've been following your tutos but i wonder why for none of them, you didn't build on virtual environments. For instance getting the project to work with psycopg2 under a mac virtualenv is a nightmare

[@syrgakomuraliev]

how can we then hide these postgres passwords that we included in settings

[@mkhnuser]

Привет, я тут узнал, что у тебя русская фамилия, и, знаешь, это делает меня счастливым ;)

[@TURKISTONIM2]

Localhost is not have in my dashboard ⁉️⁉️⁉️

[@damonwu9658]

just googled, for python 3.8, we can do this: pip install psycopg2-binary

[@karryvenkatesh5116]

Thanks for the Tutorial. How to fetch data from database?

[@MuhammadMahirQ8]

Amazing. Much needed. thank you

[@claesnordahl5647]

Hi Dennis, I know this session is for connecting PostgresSQL DB to the django project. I'm working on a use case where I want to connect to an existing graph database (neo4j), and I want to incorporate some visualizations into my application. Could you address how I can combine what I've built through your course, but also connect to a separate existing graph database in django?

[@jadynchowdhury680]

I am having issue creating an AWS account and using RDS. Is this necessary. Are there free alternatives?

[@ryan_0337]

Hi Dennis , I am currently wondering how to estimate the fees for hosting a web app on a hosting services. I saw a lot of offers plans but I don't what the technicals terms are such as bandwidth... Do you know how to estimate the price od this kind of stuff for a lot of website in the same hosting service? For example , if the traffic increase how could we estimate the budget or the storage of images and video ? Thanks in advance your content is very clear and help us a lot.

[@ravenreyes8051]

hi thanks for this, i just have question. if ever in the future i want to change the name like the name of tables and models or add new tables and database, all i have to do is to rewrite the code base and migrate it again right?

[@jansoriano6687]

Hi Dennis and everyone, I'm having a problem with the endpoint that I'm using because once I added it to the HostName/Address this error pops up "Unable to connect to server: could not connect to server: Connection timed out (0x0000274C/10060)" I don't know if is this about the region since I'm in the Philippines?

[@RoylanMartinez]

I have the same problem :( edit: There is a solution in the first comment of this video

[@zaturntarto3814]

1:48 It seems that "pgAdmin 4" is already included with POSTGRESQL. But you still download pgAmin 4 seperately ?

[@charmz973]

for linux devs After installing postgres on the machine,do this to follow along: $ psql -U postgres -h localhost then ---> $ CREATE DATABASE OWNER postgres; ----->$\l ---> to check if database i created if the above is successful change the connection details in settings.py file and run migrations for AWS RDS: after creating the database Open the database security group in AWS; and choose "Edit inbound rules"; "Add rule". There is a "My IP" option in the dropdown menu; select that option to auto-populate with your computer's public IP address in CIDR notation and click Save rules Now if that is finished ,you will be able to connect to the RDS successfully using this command,hope u remember ur initial database name,password,username and port. -->psql --host= --port=5432 --username= --password --dbname= If the above was successful ,change the connection details and do migrations.

[@ConsulGold]

Premium grade stuff...kudos

[@drvification]

Отличное видео, очень помогло 👍

[@dradrigapatrick]

Hello, I got stuck on the user role permission of allowing only a customer or admin to view some specific parts. Is there a better way to write this? It is my first time into writing anything in django. It doesnt allow me to login as a customer, but only as admin and only in the admin section. This is piece of code is the problem "def admin_only(view_func): def wrapper_function(request, *args, **kwargs): group = None if request.user.groups.exists(): group = request.user.groups.all()[0].name if group == 'customer': return redirect('user') if group == 'admin': return view_func(request, *args, **kwargs) return wrapper_function" And results into this error [ ValueError at / The view accounts.decorators.wrapper_function didn't return an HttpResponse object. It returned None instead.] Any help will be very great

[@gen-ztiktok6990]

Same here

[@kunalgautam8312]

after modifying database object and running command "python manage.py migrate" giving error: django.db.utils.ProgrammingError: relation "auctions_category" does not exist

[@shubhamsharma9756]

i have one doubt about ReactJs course.I m full stack django developer but i m much curious about React and how it works with django web and i want to do full course on React.if i will do some course on Reactjs and after doing it can i m able to jump to my django project directly to use react or i have to do some other course to use react in my django project?pls suggest it will be appreciable.

[@hbcck]

I'm new to these issues. I have a question. Changes made in Django for the database will now be kept on the Cloud, right? so if change something in Django, it will change on Cloud too(i am talking for database). am i wrong?

[@omk6258]

can you make one video of database route...? Thks

[@zamanEhsani]

thanks dennis. it helped!!

[@GreatAdib]

superb work but i don't have credit card now so AWS is useless for me now pretty unfortunate

[@DennisIvy]

Debit card should do but I suppose you mean card in general. That's to bad, I don't know of any hosting platforms that don't require a payment method upfront.

[@GreatAdib]

@@DennisIvy your right as soon as I get the card I will learn AWS. For now I have to wait and learn other things

[@FernandoLopez-kj1pu]

I have a problem it does not allow me to connect to the amazon server, what can I do?

[@unstable_diffusion]

Hey Dennis, thanks for the video. Not using Python/Django, however trying to connect to RDS from Node, which is kinda similar using node-postgres. My question is why do you put 'postgres' in your database name if you have 'database-1' in your RDS and it works. Initially I used 'database-1' in my app, I got an error that my database doesn't exist. However after changing my database variable in my app to 'postgres' the connection magically worked. Can you explain what's happening or do you have any assumptions? Thank you!

[@Boilnardo]

nice job

[@yusuffabdulmusawwir6807]

Why is the rdsadmin database throwing an error(internal server error)

[@hasantareq9394]

AWS needs a valid bank account... I haven't one... is there any way to access Database???

[@juneddavada]

I got error while connecting amazon aws database to pgadmin4 Unable to connect to server : timeout expired What should i have to do

[@NiceKaTkA]

Have you solved the problem? I have the same, If you can help me, write the solving please)))

[@juneddavada]

No i didnot solve that yet

[@OburKoray]

I have the same problem any solution?

[@demehinibukun1445]

Hi guys I'm having an issue I'm getting an error during installation, something about database cluster could not be created, I am using a Windows 10 OS Thanks for your help

[@jhkz4313]

thanks for the tutorials, is it okay to download psycopg2-binary? i can't install the psycopg2 in virtual environment. I read about differences between those psycopg2, one for production and the other one is for dev and test.

[@mohammedfaris5326]

how can i solve database 'demo_1' not exist error

[@anoopnagarmunoli8266]

is the process same if we buy a different instance of postgres sql? i have bought db.t3.micro . and when i try to create server in pdAdmin it gives me error this error saying : "unable to connect to server; timeout expired" .. can u please help me out with this one. or atlease guide me on what can resolve the issue! thanks in advance!

[@louzynerd129]

The tables are not showing up even though i migrated and everything was Ok in the command prompt idk what's the issue here please help someone.

[@deepjyotide181]

"The view accounts.decorators.wrapper_function didn't return an HttpResponse object. It returned None instead." This is the error showing. the wrapper_function couldn't find the Groups I created, neither admin nor customer. I once uninstalled Postgresql cause it wasn't connecting to AWS. Now the AWS issue is solved and this is the new malfunction. @Dennis do reply sir. You never replied to any of my queries.

[@nicolas00865]

You have to create a super user account and create manually the groups "admin" and "customer"

[@deepjyotide181]

@@nicolas00865 I already did. Still I faced that issue

[@p3jtu]

@@nicolas00865 Thanks. This worked for me.

[@rajendrachoudhary9098]

You should use singnls There are 2 videos in this series to solve it

[@abdurahmanyusuf5170]

Amazing you are my mentor thanks sir i have some problem for me in series toturial that is TypeError at / 'QuerySet' object is not callable when i am try to add filter my django project hes said like this

[@DennisIvy]

Can you please send your source code to [e-mail]? I’ll take a look at this for you. A screenshot of the view and template may be enough for now.

[@practicalbong1497]

@@DennisIvy after chaging the database from sqlite to PostgreSQL ,im not able to login all me admin user ,customer all gone ,please help me

[@fahanfarooq3844]

Couple of minutes to download 😂😂😂...took me a lifetime #kashmir #2g

[@danishsharma4363]

sorry for you brother

[@fahanfarooq3844]

@@danishsharma4363 ❤️

[@yohannesayana9456]

The Debit card in my country is only valid inside the country....I mean the debit card is not international...Any means that I'll have AWS account?

[@TariqAhmed_]

Can we use this in mysql ? is the process remain same?

[@franciscojosecastillocarra7535]

Hi Dennis, awesome content, thanks so much! Here I leave a comment in case it can help some people. I finally have my database live thanks to you :) For anyone experiencing the "timeout expired" error, which I have experienced myself, I would recommend following the documentation: aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/?nc2=type_a The main difference with this video is that you don't use existing VPC security groups, you use a new one which you can name yourself. I am not very experienced so I can't explain much. I followed the docs and solved my problem.

[@celloucisse7548]

Thank you so much Mr. It's solved my problem too

[@gregruiz921]

Thank you. Your suggestion solved my timeout issue as well. To reiterate... when creating the database, you have to select "Create New" for the "VPC security group" and then give it a name. That's the ONLY thing I did different from the video, and it works great.

[@yusuffabdulmusawwir6807]

Can you do this once the database has been created completely?

[@ayaanlone5736]

I am unable to get Free tier option while creating rds.

[@rashidaliev9460]

Could someone explain me please why we are creating a new server group and is it necessary?

[@Magistrado1914]

Excellent course 26/07/2020

[@truecaretaker]

I'm having trouble doing this in linux

[@balogunolajide7204]

pls i need help with, am trying to use Postgres db. django.db.utils.OperationalError: fe_sendauth: no password supplied

[@alenkozlic3344]

for newbies like me just uninstall whatever database you are using and install it again, and also check if you mispelled the 'PASSWORD' i cracked my head and found that i only have one 'S' :D

[@ifeanyiemmanuelanagaepenet4506]

You are the best

[@foysalkhjoy]

The Latest PostgreSQL has default pgadmin

[@MarsLanding91]

THANK YOU!

[@Nomanqureshi2204]

hey thanks pls make videos on django rest api

[@DennisIvy]

Coming soon :) Need to launch this one live first ;)

[@sannjayy]

@@DennisIvy Waiting broooo

[@antonsalamov5164]

ERROR: LINE 1: ..." ("products_id", "tag_id") VALUES (1, 1), (1, 2) ON CONFLIC... The author’s request to show how to cope with these errors, the second day I can’t continue to work normally because of migrations to Postgres! I tried everything that is described below!

[@abhikhatri5414]

My one question, hope u do reply... U didn't create Virtual environment for the project, however automatically appeared at 05:52/17:08 in part-21 folder named ENV, how?

[@abhikhatri5414]

I also subscribed to ur channel... I liked the way u r explaining... However, I think u r missing something that matters much for understanding to minimize the error during the project using ur follow-up guidelines step-by-step by those users who are completely new to Django... The way u r explaining is quite good for those who have already evolved into Django... I do hope u will figure this out and make ur video tutorial the best one... I watched all the parts, all parts are very good enough contents and enough explanations as well... One seriously following ur guidelines will definitely develop a Django app and deploy for the production grade.....

[@PythonCareerCoach]

After this I could enter the details in pgadmin and updated the same in settings.py. But when i ran "python manage.py" migrate it gave error as Operational error:FATAL: database does not exist. Pls advise

[@PythonCareerCoach]

Found solution : stackoverflow.com/questions/26369952/operational-error-fatal-database-django-does-not-exist/26370072 Thanks

[@frassettiguido]

The free tier its not aviable any more for de 13teen version

[@petecodes]

Saved my bacon again!

[@louzynerd129]

Note: AWS takes $1 from you by default, just a heads up

[@ThorEgilOlsen]

I assume there is free service without credit cards also, any tip about that? I might be para noid about creditcard fraud, but a company that only accepts local laws is one I fear have an issue with the law.

[@rjjaictin847]

Can you just serve sqlite on heroku if your site is not that database resource hungry?

[@haithamali2593]

Kinda late but I've tried heroku with small app before and it works fine, don't about apps of this scale though.

[@shashikumar-vi6ne]

hello dennis ! after connecting my project with AWS i am m not able to login / admin login. . Plz suggest how to solve this problem.

[@amankumar-qs5fy]

Have you got the fix?

[@haithamali2593]

@@amankumar-qs5fy stuck with the same issue, did you find the cause? It seems that the database is connected properly for some reason, when I switch back to local database to works with no problems

[@shahrukhfazli5408]

Unable to connect to server: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" I'm getting this error while creating SERVER. Please help to resolve this issue. I am using master password while creating SERVER but getting error.

[@clubfootbear3159]

I have the same issue, but found this solution: stackoverflow.com/questions/7695962/postgresql-password-authentication-failed-for-user-postgres

[@darren1107]

I'm not sure why I had issues with connecting to the AWS DB from my PC, but I had to change the "Inbound" rules on AWS to allow "My IP" rather than allow any.. Maybe it's some mistake I've made along the way.

[@MASBHANOMAN]

hi, have you resolved it / facing the same issue

[@rajendrachoudhary9098]

@@MASBHANOMAN how..can u please explain in brief

[@nabilalhoussein7877]

I'm 16 years old and can't manage to get a credit card in the aws. Any advice?

[@rajbiswas776]

In my country(India), you can use any debit card, doesn't need to be yours, and when it asks for tax details you just say don't have any. They will probably give an automated call or something to verify the account. If you stay within the free tier its all good. Check if you have something similar in your country.

[@Zatra_]

The free tier its not aviable :,(

[@асемабдирашова]

I'm getting such error: Is the server running on host "database-1..." and accepting TCP/IP connections on port 5432? Anyone resolve this?

[@GlosicielPrawdy]

this shows because ip address set in rds changes all the time, so if you refresh ip address in security group rules (set again my ip) it will work. But problem is that with next computer start ip changes again. Solution is elastic iP but I don't know how to set it for rds.

[@асемабдирашова]

@@GlosicielPrawdy thanks🙌🏻

[@thhdxb9041]

Hi Dennis! Very useful tutorial. By the way, I cannot log-in or register after migrating the database to postgres and AWS. Error shows django.contrib.auth.models.Group.DoesNotExist: Group matching query does not exist.

[@Hard_Tackle]

Have you gotten a solution

[@yamanrana7531]

Sir i dont have credit card account what shall i do??

[@Hard_Tackle]

Use a debit card

[@christianmagnus1003]

Hey bro, this is free? i mean aws rds

[@nedyalkokarabadzhakov5405]

for a new aws account RDS t2.micro is free for a single year.

[@haobamjameskumar3962]

Why we connect AWS RDS with postgres is really necessary? Anyone Pliz reply i want to know y

[@louzynerd129]

The tables are not showing up even though i migrated and everything was Ok in the command prompt idk what's the issue here please help someone.

[@Pimvrolijks]

You can connect to other databases if you like. But the standard SQLite is not fit for running on a production environment because it is a very lightweight database and the possibilities that locks or other errors occur are not something you want to have in a production-like environment.

[@sarathkumar-gq8be]

Aws is free of cost or paid ,

[@DennisIvy]

There is a free tier but it is a paid product

[@sarathkumar-gq8be]

@@DennisIvy hmm ok bro

[@sarathkumar-gq8be]

@@DennisIvy I have doubt in uploading images but I try different method ,but it won't work ,can you help me

[@shivanshsharma5893]

and don't connect it with cloud

[@deaglannolan8468]

I'm using MacOS and ran the following command in terminal: "pip install psycopg2" and I got this error: Error: pg_config executable not found Not sure how to fix this any help would be appreciated. Thank you in advance :) Full error message " pg_config is required to build psycopg2 from source. Please add the directory containing pg_config to the $PATH or specify the full executable path with the option: python setup.py build_ext --pg-config /path/to/pg_config build ... or with the pg_config option in 'setup.cfg'. If you prefer to avoid building psycopg2 from source, please install the PyPI 'psycopg2-binary' package instead. For further information please check the 'doc/src/install.rst' file (also at ). ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output. "

[@deaglannolan8468]

I upgraded my pip using the following command in terminal: "pip install --upgrade pip" I also installed homebrew (its a packagemanager like pip) using the follwoing commandline: "/bin/bash -c "$(curl -fsSL raw.githubusercontent.com/Homebrew/install/master/install.sh)" Then I entered this into terminal and things started to work: "brew install postgresql" I hope this helps I was stuck on this for ages

[@nguyenquang97]

I don't have Visa Card

[@shyamraa]

Psyco PG2 ? 😲 Should be PG 18+ 😝

[@phucutube]

For anyone receiving ERROR: Command errored out with exit status 1: I was unable to install psycog2 directly. However, I was successful in downloading the psycog2 binary file. You can follow this link to help solve your problem or reply to this comment and I'll do what I can to help. www.dark-hamster.com/programming/how-to-solve-error-on-installing-psycopg2-using-pip-by-using-psycopg2-binary-instead/

[@idleglance99]

Ivanov seems to be a Russian last name

[@nhanNguyen-wo8fy]

2:25