Learn how Neon's autoscaling works - it estimates Postgres' working set size and keeps it in memory. Engineering post here

Passwordless auth

Learn how to connect to Neon without a password

Neon's psql passwordless auth feature helps you quickly authenticate a connection to Neon without providing a password.

The following instructions require a working installation of psql, an interactive terminal for working with Postgres. For information about psql, refer to the psql reference, in the PostgreSQL Documentation.

To connect using Neon's psql passwordless auth feature:

  1. In your terminal, run the following command:

    psql -h pg.neon.tech

    A response similar to the following is displayed:

    NOTICE:  Welcome to Neon!
    Authenticate by visiting:
        https://console.neon.tech/psql_session/6d32af5ef8215b62
  2. In your browser, navigate to the provided link. Log in to Neon if you are not already logged in. You are asked to select a Neon project to connect to. If your project has more than one compute, you are also asked to select one.

    After making your selections, you are advised that you can return to your terminal or command window where information similar to the following is displayed:

    NOTICE:  Connecting to database.
    psql (15.0 (Ubuntu 15.0-1.pgdg22.04+1))
    Type "help" for help.
    
    casey=>

    The passwordless auth feature connects to the first database created in the branch. To check the database you are connected to, issue this query:

    SELECT current_database();
     current_database
    ------------------
     neondb

    Switching databases from the psql prompt (using \c <database_name>, for example) after you have authenticated restarts the passwordless auth authentication process to authenticate a connection to the new database.

Running queries

After establishing a connection, try running the following queries:

CREATE TABLE my_table AS SELECT now();
SELECT * FROM my_table;

The following result set is returned:

SELECT 1
              now
-------------------------------
 2022-09-11 23:12:15.083565+00
(1 row)

Need help?

Join our Discord Server to ask questions or see what others are doing with Neon. Users on paid plans can open a support ticket from the console. For more detail, see Getting Support.

Last updated on

Was this page helpful?