Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to connect to PostgreSQL database with Laravel Homestead?

Tags:

laravel-5

homestead

I have updated the DB connection in my .env file to change the default mysql database to use PostgreSQL DB. But I don't know how to proceed with this.

DB_CONNECTION=pgsql

For example, we use

mysql -uhomestead -psecret <DB Name>

to connect to our database. By using psql, how to connect to DB?

like image 821
suguna Avatar asked Mar 17 '16 06:03

suguna

People also ask

How connect PostgreSQL to laravel?

Laravel makes connecting with Postgres databases and running queries extremely simple out of the box. The Postgres database configuration for your application is located at Laravel Project Root Folder, config/database. php . In this file you may define Postgres database connection for your Laravel Application.

How do I connect to Homestead database?

Connecting To Your Databases To connect to your MySQL or Postgres database from your main machine via Navicat or Sequel Pro, you should connect to 127.0. 0.1 and port 33060 (MySQL) or 54320 (Postgres). The username and password for both databases is homestead / secret .

1 Answers

Try this one,

psql -U homestead -h localhost <DB Name>

After that, it will ask for password, enter secret. That's it.

like image 157
Anandhan Avatar answered Oct 13 '22 01:10

Anandhan
Sign in to Comment

Related questions

Laravel return value from within transactions
Laravel 5.6 - Uncaught RuntimeException: A facade root has not been set
Change extends(layout) dynamically in laravel 5
Using $input->all() instead of Input::all() Laravel-5
Laravel HTML to PDF conversion (DOMPDF)
Laravel - call to undefined method illuminate\Foundation\Application::bindshared()
How to get Laravel Query Builder result as integer
Laravel - JWT Auth The token could not be parsed from the request
Blade returns undefined offset
laravel 5 : Extend a Facade
How to access a column in laravel query result
How to access Mail data from MessageSent event on Laravel?
Laravel debugger - enable/disable depending on IP address while caching implemented
Configuring Redis as Cache interface in a Laravel 5 Application
Laravel Eloquent find for composite key
Laravel 5 - Finding the pagination page for a model
How to declare unlimited parameters in Laravel?
Test basic auth
How can i decode hash value in laravel 5?
Laravel 5 Package Scheduled Tasks

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!