curl: (52) Empty reply from server

[twistedlizard]

Please somebody redirect me if this isn't the best place for this question.

I couldn't get postgrest to work on the windows server I use (see other thread) so I've installed it on linux instead. Now, I'm following Tutorial 0.

I have a database, schema, table, roles & permissions all set up on a remote postgresql server, as per the tutorial. From the linux machine I'm testing on, I can connect to that remote postgresql server using, for example, PgAdmin3.

postgrest seems to start ok

$ ./postgrest tutorial.conf
Listening on port 3000
Attempting to connect to the database...
Connection successful

Then, attempting to use curl in another terminal window

$ curl http://localhost:3000/todos
curl: (52) Empty reply from server

could anyone suggest how I can fault find?
postgrest 0.4.2.0
postgresql 9.6.3

[steve-chavez]

Are you behind a proxy? If that's the case you may need to modify http_proxy env var to not proxy localhost.

[twistedlizard]

No, I'm using curl from the same machine as postgrest is running on, although the postgresql server is elsewhere.

There's no requirement that postgrest run on the same host as postgresql?
I can connect to & use the database from the machine on which I'm testing postgrest.

[steve-chavez]

No requirement, postgREST doesn't need to run in the same host as postgresql server.
How about doing a curl -v http://localhost:3000/todos(with the -v verbose flag) and then paste the output.

[twistedlizard]

% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed

0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 127.0.0.1...

• Connected to localhost (127.0.0.1) port 3000 (#0)

GET /todos HTTP/1.1
Host: localhost:3000
User-Agent: curl/7.47.0
Accept: /

0 0 0 0 0 0 0 0 --:--:-- 0:00:01 --:--:-- 0* Empty reply from server

0 0 0 0 0 0 0 0 --:--:-- 0:00:01 --:--:-- 0

• Connection #0 to host localhost left intact
  curl: (52) Empty reply from server

[begriffs]

@twistedlizard can you enable db logging and see what queries your web requests trigger? There are instructions for how to do this here: https://postgrest.com/en/v4.1/admin.html#debugging

[ruslantalpa]

this is either a firewall issue. closing until more detail is given

[SirRolin]

I'm having the same issue. This is my log:

2017-10-30 16:08:01.332 CET [9985] postgres@nyxia LOG:  statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2017-10-30 16:08:01.332 CET [9985] postgres@nyxia LOG:  statement: SELECT 1
2017-10-30 16:08:01.334 CET [9985] postgres@nyxia LOG:  execute <unnamed>: SELECT current_setting('server_version_num')::integer
2017-10-30 16:08:01.336 CET [9985] postgres@nyxia LOG:  execute 0: 
	    SELECT
	      n.nspname AS table_schema,
	      c.relname AS table_name,
	      NULL AS table_description,
	      c.relkind = 'r' OR (c.relkind IN ('v','f'))
	      AND (pg_relation_is_updatable(c.oid::regclass, FALSE) & 8) = 8
	      OR (EXISTS
	        ( SELECT 1
	          FROM pg_trigger
	          WHERE pg_trigger.tgrelid = c.oid
	          AND (pg_trigger.tgtype::integer & 69) = 69) ) AS insertable
	    FROM pg_class c
	    JOIN pg_namespace n ON n.oid = c.relnamespace
	    WHERE c.relkind IN ('v','r','m')
	      AND n.nspname NOT IN ('pg_catalog', 'information_schema')
	    GROUP BY table_schema, table_name, insertable
	    ORDER BY table_schema, table_name 
2017-10-30 16:08:01.348 CET [9985] postgres@nyxia LOG:  execute 1: 
	    SELECT DISTINCT
	        info.table_schema AS schema,
	        info.table_name AS table_name,
	        info.column_name AS name,
	        info.description AS description,
	        info.ordinal_position AS position,
	        info.is_nullable::boolean AS nullable,
	        info.data_type AS col_type,
	        info.is_updatable::boolean AS updatable,
	        info.character_maximum_length AS max_len,
	        info.numeric_precision AS precision,
	        info.column_default AS default_value,
	        array_to_string(enum_info.vals, ',') AS enum
	    FROM (
	        /*
	        -- CTE based on information_schema.columns to remove the owner filter
	        */
	        WITH columns AS (
	            SELECT current_database()::information_schema.sql_identifier AS table_catalog,
	                nc.nspname::information_schema.sql_identifier AS table_schema,
	                c.relname::information_schema.sql_identifier AS table_name,
	                a.attname::information_schema.sql_identifier AS column_name,
	                d.description::information_schema.sql_identifier AS description,
	                a.attnum::information_schema.cardinal_number AS ordinal_position,
	                pg_get_expr(ad.adbin, ad.adrelid)::information_schema.character_data AS column_default,
	                    CASE
	                        WHEN a.attnotnull OR t.typtype = 'd'::"char" AND t.typnotnull THEN 'NO'::text
	                        ELSE 'YES'::text
	                    END::information_schema.yes_or_no AS is_nullable,
	                    CASE
	                        WHEN t.typtype = 'd'::"char" THEN
	                        CASE
	                            WHEN bt.typelem <> 0::oid AND bt.typlen = (-1) THEN 'ARRAY'::text
	                            WHEN nbt.nspname = 'pg_catalog'::name THEN format_type(t.typbasetype, NULL::integer)
	                            ELSE format_type(a.atttypid, a.atttypmod)
	                        END
	                        ELSE
	                        CASE
	                            WHEN t.typelem <> 0::oid AND t.typlen = (-1) THEN 'ARRAY'::text
	                            WHEN nt.nspname = 'pg_catalog'::name THEN format_type(a.atttypid, NULL::integer)
	                            ELSE format_type(a.atttypid, a.atttypmod)
	                        END
	                    END::information_schema.character_data AS data_type,
	                information_schema._pg_char_max_length(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.cardinal_number AS character_maximum_length,
	                information_schema._pg_char_octet_length(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.cardinal_number AS character_octet_length,
	                information_schema._pg_numeric_precision(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.cardinal_number AS numeric_precision,
	                information_schema._pg_numeric_precision_radix(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.cardinal_number AS numeric_precision_radix,
	                information_schema._pg_numeric_scale(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.cardinal_number AS numeric_scale,
	                information_schema._pg_datetime_precision(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.cardinal_number AS datetime_precision,
	                information_schema._pg_interval_type(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*))::information_schema.character_data AS interval_type,
	                NULL::integer::information_schema.cardinal_number AS interval_precision,
	                NULL::character varying::information_schema.sql_identifier AS character_set_catalog,
	                NULL::character varying::information_schema.sql_identifier AS character_set_schema,
	                NULL::character varying::information_schema.sql_identifier AS character_set_name,
	                    CASE
	                        WHEN nco.nspname IS NOT NULL THEN current_database()
	                        ELSE NULL::name
	                    END::information_schema.sql_identifier AS collation_catalog,
	                nco.nspname::information_schema.sql_identifier AS collation_schema,
	                co.collname::information_schema.sql_identifier AS collation_name,
	                    CASE
	                        WHEN t.typtype = 'd'::"char" THEN current_database()
	                        ELSE NULL::name
	                    END::information_schema.sql_identifier AS domain_catalog,
	                    CASE
	                        WHEN t.typtype = 'd'::"char" THEN nt.nspname
	                        ELSE NULL::name
	                    END::information_schema.sql_identifier AS domain_schema,
	                    CASE
	                        WHEN t.typtype = 'd'::"char" THEN t.typname
	                        ELSE NULL::name
	                    END::information_schema.sql_identifier AS domain_name,
	                current_database()::information_schema.sql_identifier AS udt_catalog,
	                COALESCE(nbt.nspname, nt.nspname)::information_schema.sql_identifier AS udt_schema,
	                COALESCE(bt.typname, t.typname)::information_schema.sql_identifier AS udt_name,
	                NULL::character varying::information_schema.sql_identifier AS scope_catalog,
	                NULL::character varying::information_schema.sql_identifier AS scope_schema,
	                NULL::character varying::information_schema.sql_identifier AS scope_name,
	                NULL::integer::information_schema.cardinal_number AS maximum_cardinality,
	                a.attnum::information_schema.sql_identifier AS dtd_identifier,
	                'NO'::character varying::information_schema.yes_or_no AS is_self_referencing,
	                'NO'::character varying::information_schema.yes_or_no AS is_identity,
	                NULL::character varying::information_schema.character_data AS identity_generation,
	                NULL::character varying::information_schema.character_data AS identity_start,
	                NULL::character varying::information_schema.character_data AS identity_increment,
	                NULL::character varying::information_schema.character_data AS identity_maximum,
	                NULL::character varying::information_schema.character_data AS identity_minimum,
	                NULL::character varying::information_schema.yes_or_no AS identity_cycle,
	                'NEVER'::character varying::information_schema.character_data AS is_generated,
	                NULL::character varying::information_schema.character_data AS generation_expression,
	                CASE
	                    WHEN c.relkind = 'r'::"char" OR (c.relkind = ANY (ARRAY['v'::"char", 'f'::"char"])) AND pg_column_is_updatable(c.oid::regclass, a.attnum, false) THEN 'YES'::text
	                    ELSE 'NO'::text
	                END::information_schema.yes_or_no AS is_updatable
	            FROM pg_attribute a
	               LEFT JOIN pg_catalog.pg_description AS d ON d.objoid = a.attrelid and d.objsubid = a.attnum
	               LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
	               JOIN (pg_class c
	               JOIN pg_namespace nc ON c.relnamespace = nc.oid) ON a.attrelid = c.oid
	               JOIN (pg_type t
	               JOIN pg_namespace nt ON t.typnamespace = nt.oid) ON a.atttypid = t.oid
	               LEFT JOIN (pg_type bt
	               JOIN pg_namespace nbt ON bt.typnamespace = nbt.oid) ON t.typtype = 'd'::"char" AND t.typbasetype = bt.oid
	               LEFT JOIN (pg_collation co
	               JOIN pg_namespace nco ON co.collnamespace = nco.oid) ON a.attcollation = co.oid AND (nco.nspname <> 'pg_catalog'::name OR co.collname <> 'default'::name)
	            WHERE NOT pg_is_other_temp_schema(nc.oid) AND a.attnum > 0 AND NOT a.attisdropped AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char", 'f'::"char"]))
	              /*--AND (pg_has_role(c.relowner, 'USAGE'::text) OR has_column_privilege(c.oid, a.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text))*/
	        )
	        SELECT
	            table_schema,
	            table_name,
	            column_name,
	            description,
	            ordinal_position,
	            is_nullable,
	            data_type,
	            is_updatable,
	            character_maximum_length,
	            numeric_precision,
	            column_default,
	            udt_name
	        /*-- FROM information_schema.columns*/
	        FROM columns
	        WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
	    ) AS info
	    LEFT OUTER JOIN (
	        SELECT
	            n.nspname AS s,
	            t.typname AS n,
	            array_agg(e.enumlabel ORDER BY e.enumsortorder) AS vals
	        FROM pg_type t
	        JOIN pg_enum e ON t.oid = e.enumtypid
	        JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
	        GROUP BY s,n
	    ) AS enum_info ON (info.udt_name = enum_info.n)
	    ORDER BY schema, position 
2017-10-30 16:08:01.490 CET [9985] postgres@nyxia LOG:  execute 2: 
	    with view_columns as (
	        select
	            c.oid as view_oid,
	            a.attname::information_schema.sql_identifier as column_name
	        from pg_attribute a
	        join pg_class c on a.attrelid = c.oid
	        join pg_namespace nc on c.relnamespace = nc.oid
	        where
	            not pg_is_other_temp_schema(nc.oid)
	            and a.attnum > 0
	            and not a.attisdropped
	            and (c.relkind = 'v'::"char")
	            and nc.nspname not in ('information_schema', 'pg_catalog')
	    ),
	    view_column_usage as (
	        select distinct
	            v.oid as view_oid,
	            nv.nspname::information_schema.sql_identifier as view_schema,
	            v.relname::information_schema.sql_identifier as view_name,
	            nt.nspname::information_schema.sql_identifier as table_schema,
	            t.relname::information_schema.sql_identifier as table_name,
	            a.attname::information_schema.sql_identifier as column_name,
	            pg_get_viewdef(v.oid)::information_schema.character_data as view_definition
	        from pg_namespace nv
	        join pg_class v on nv.oid = v.relnamespace
	        join pg_depend dv on v.oid = dv.refobjid
	        join pg_depend dt on dv.objid = dt.objid
	        join pg_class t on dt.refobjid = t.oid
	        join pg_namespace nt on t.relnamespace = nt.oid
	        join pg_attribute a on t.oid = a.attrelid and dt.refobjsubid = a.attnum
	
	        where
	            nv.nspname not in ('information_schema', 'pg_catalog')
	            and v.relkind = 'v'::"char"
	            and dv.refclassid = 'pg_class'::regclass::oid
	            and dv.classid = 'pg_rewrite'::regclass::oid
	            and dv.deptype = 'i'::"char"
	            and dv.refobjid <> dt.refobjid
	            and dt.classid = 'pg_rewrite'::regclass::oid
	            and dt.refclassid = 'pg_class'::regclass::oid
	            and (t.relkind = any (array['r'::"char", 'v'::"char", 'f'::"char"]))
	    ),
	    candidates as (
	        select
	            vcu.*,
	            (
	                select case when match is not null then coalesce(match[8], match[7], match[4]) end
	                from regexp_matches(
	                    CONCAT('SELECT ', SPLIT_PART(vcu.view_definition, 'SELECT', 2)),
	                    CONCAT('SELECT.*?((',vcu.table_name,')|(\w+))\.(', vcu.column_name, ')(\s+AS\s+("([^"]+)"|([^, \n\t]+)))?.*?FROM.*?(',vcu.table_schema,'\.|)(\2|',vcu.table_name,'\s+(as\s)?\3)'),
	                    'nsi'
	                ) match
	            ) as view_column_name
	        from view_column_usage as vcu
	    )
	    select
	        c.table_schema,
	        c.table_name,
	        c.column_name as table_column_name,
	        c.view_schema,
	        c.view_name,
	        c.view_column_name
	    from view_columns as vc, candidates as c
	    where
	        vc.view_oid = c.view_oid
	        and vc.column_name = c.view_column_name
	    order by c.view_schema, c.view_name, c.table_name, c.view_column_name
	    
2017-10-30 16:08:01.492 CET [9985] postgres@nyxia LOG:  execute 3: 
	    SELECT ns1.nspname AS table_schema,
	           tab.relname AS table_name,
	           column_info.cols AS columns,
	           ns2.nspname AS foreign_table_schema,
	           other.relname AS foreign_table_name,
	           column_info.refs AS foreign_columns
	    FROM pg_constraint,
	       LATERAL (SELECT array_agg(cols.attname) AS cols,
	                       array_agg(cols.attnum)  AS nums,
	                       array_agg(refs.attname) AS refs
	                  FROM ( SELECT unnest(conkey) AS col, unnest(confkey) AS ref) k,
	                       LATERAL (SELECT * FROM pg_attribute
	                                 WHERE attrelid = conrelid AND attnum = col)
	                            AS cols,
	                       LATERAL (SELECT * FROM pg_attribute
	                                 WHERE attrelid = confrelid AND attnum = ref)
	                            AS refs)
	            AS column_info,
	       LATERAL (SELECT * FROM pg_namespace WHERE pg_namespace.oid = connamespace) AS ns1,
	       LATERAL (SELECT * FROM pg_class WHERE pg_class.oid = conrelid) AS tab,
	       LATERAL (SELECT * FROM pg_class WHERE pg_class.oid = confrelid) AS other,
	       LATERAL (SELECT * FROM pg_namespace WHERE pg_namespace.oid = other.relnamespace) AS ns2
	    WHERE confrelid != 0
	    ORDER BY (conrelid, column_info.nums) 
2017-10-30 16:08:01.494 CET [9985] postgres@nyxia LOG:  execute 4: 
	    /*
	    -- CTE to replace information_schema.table_constraints to remove owner limit
	    */
	    WITH tc AS (
	        SELECT current_database()::information_schema.sql_identifier AS constraint_catalog,
	            nc.nspname::information_schema.sql_identifier AS constraint_schema,
	            c.conname::information_schema.sql_identifier AS constraint_name,
	            current_database()::information_schema.sql_identifier AS table_catalog,
	            nr.nspname::information_schema.sql_identifier AS table_schema,
	            r.relname::information_schema.sql_identifier AS table_name,
	                CASE c.contype
	                    WHEN 'c'::"char" THEN 'CHECK'::text
	                    WHEN 'f'::"char" THEN 'FOREIGN KEY'::text
	                    WHEN 'p'::"char" THEN 'PRIMARY KEY'::text
	                    WHEN 'u'::"char" THEN 'UNIQUE'::text
	                    ELSE NULL::text
	                END::information_schema.character_data AS constraint_type,
	                CASE
	                    WHEN c.condeferrable THEN 'YES'::text
	                    ELSE 'NO'::text
	                END::information_schema.yes_or_no AS is_deferrable,
	                CASE
	                    WHEN c.condeferred THEN 'YES'::text
	                    ELSE 'NO'::text
	                END::information_schema.yes_or_no AS initially_deferred
	        FROM pg_namespace nc,
	            pg_namespace nr,
	            pg_constraint c,
	            pg_class r
	        WHERE nc.oid = c.connamespace AND nr.oid = r.relnamespace AND c.conrelid = r.oid AND (c.contype <> ALL (ARRAY['t'::"char", 'x'::"char"])) AND r.relkind = 'r'::"char" AND NOT pg_is_other_temp_schema(nr.oid)
	        /*--AND (pg_has_role(r.relowner, 'USAGE'::text) OR has_table_privilege(r.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(r.oid, 'INSERT, UPDATE, REFERENCES'::text))*/
	        UNION ALL
	        SELECT current_database()::information_schema.sql_identifier AS constraint_catalog,
	            nr.nspname::information_schema.sql_identifier AS constraint_schema,
	            (((((nr.oid::text || '_'::text) || r.oid::text) || '_'::text) || a.attnum::text) || '_not_null'::text)::information_schema.sql_identifier AS constraint_name,
	            current_database()::information_schema.sql_identifier AS table_catalog,
	            nr.nspname::information_schema.sql_identifier AS table_schema,
	            r.relname::information_schema.sql_identifier AS table_name,
	            'CHECK'::character varying::information_schema.character_data AS constraint_type,
	            'NO'::character varying::information_schema.yes_or_no AS is_deferrable,
	            'NO'::character varying::information_schema.yes_or_no AS initially_deferred
	        FROM pg_namespace nr,
	            pg_class r,
	            pg_attribute a
	        WHERE nr.oid = r.relnamespace AND r.oid = a.attrelid AND a.attnotnull AND a.attnum > 0 AND NOT a.attisdropped AND r.relkind = 'r'::"char" AND NOT pg_is_other_temp_schema(nr.oid)
	        /*--AND (pg_has_role(r.relowner, 'USAGE'::text) OR has_table_privilege(r.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(r.oid, 'INSERT, UPDATE, REFERENCES'::text))*/
	    ),
	    /*
	    -- CTE to replace information_schema.key_column_usage to remove owner limit
	    */
	    kc AS (
	        SELECT current_database()::information_schema.sql_identifier AS constraint_catalog,
	            ss.nc_nspname::information_schema.sql_identifier AS constraint_schema,
	            ss.conname::information_schema.sql_identifier AS constraint_name,
	            current_database()::information_schema.sql_identifier AS table_catalog,
	            ss.nr_nspname::information_schema.sql_identifier AS table_schema,
	            ss.relname::information_schema.sql_identifier AS table_name,
	            a.attname::information_schema.sql_identifier AS column_name,
	            (ss.x).n::information_schema.cardinal_number AS ordinal_position,
	                CASE
	                    WHEN ss.contype = 'f'::"char" THEN information_schema._pg_index_position(ss.conindid, ss.confkey[(ss.x).n])
	                    ELSE NULL::integer
	                END::information_schema.cardinal_number AS position_in_unique_constraint
	        FROM pg_attribute a,
	            ( SELECT r.oid AS roid,
	                r.relname,
	                r.relowner,
	                nc.nspname AS nc_nspname,
	                nr.nspname AS nr_nspname,
	                c.oid AS coid,
	                c.conname,
	                c.contype,
	                c.conindid,
	                c.confkey,
	                c.confrelid,
	                information_schema._pg_expandarray(c.conkey) AS x
	               FROM pg_namespace nr,
	                pg_class r,
	                pg_namespace nc,
	                pg_constraint c
	              WHERE nr.oid = r.relnamespace AND r.oid = c.conrelid AND nc.oid = c.connamespace AND (c.contype = ANY (ARRAY['p'::"char", 'u'::"char", 'f'::"char"])) AND r.relkind = 'r'::"char" AND NOT pg_is_other_temp_schema(nr.oid)) ss
	        WHERE ss.roid = a.attrelid AND a.attnum = (ss.x).x AND NOT a.attisdropped
	        /*--AND (pg_has_role(ss.relowner, 'USAGE'::text) OR has_column_privilege(ss.roid, a.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text))*/
	    )
	    SELECT
	        kc.table_schema,
	        kc.table_name,
	        kc.column_name
	    FROM
	        /*
	        --information_schema.table_constraints tc,
	        --information_schema.key_column_usage kc
	        */
	        tc, kc
	    WHERE
	        tc.constraint_type = 'PRIMARY KEY' AND
	        kc.table_name = tc.table_name AND
	        kc.table_schema = tc.table_schema AND
	        kc.constraint_name = tc.constraint_name AND
	        kc.table_schema NOT IN ('pg_catalog', 'information_schema') 
2017-10-30 16:08:01.498 CET [9985] postgres@nyxia LOG:  execute 5: 
	  SELECT p.proname as "proc_name",
	         d.description as "proc_description",
	         pg_get_function_arguments(p.oid) as "args",
	         tn.nspname as "rettype_schema",
	         coalesce(comp.relname, t.typname) as "rettype_name",
	         p.proretset as "rettype_is_setof",
	         t.typtype as "rettype_typ",
	         p.provolatile
	  FROM pg_proc p
	    JOIN pg_namespace pn ON pn.oid = p.pronamespace
	    JOIN pg_type t ON t.oid = p.prorettype
	    JOIN pg_namespace tn ON tn.oid = t.typnamespace
	    LEFT JOIN pg_class comp ON comp.oid = t.typrelid
	    LEFT JOIN pg_catalog.pg_description as d on d.objoid = p.oid
	  WHERE  pn.nspname = $1
2017-10-30 16:08:01.498 CET [9985] postgres@nyxia DETAIL:  parameters: $1 = 'public'

[SirRolin]

Downgrading to 0.4.0.0 fixes the issue. I'm using the 32 bit version. Problem occurs in 0.4.1.0 to 0.4.3.0

[jsommr]

... Forgot to write that it's the 32 bit Ubuntu version we're using.

[begriffs]

Due to the multiple reports of this issue I'm reopening it for further examination.

[steve-chavez]

We had a report of this happening intermittently on a Rasberry Pi, don't know exactly why this happens but thanks to the hint by @Gameengine1 (not happening on 0.4.0.0) I managed to solve the issue by reverting this change #834 which changed a connection timeout default.

[atlithorn]

In my case (PostgREST 0.5.0.0 via brew) it was because port 3000 was already in use and PostgREST didn't fail or warn as I would have expected.

[steve-chavez]

Latest v6* versions should have this definitely resolved since we don't mess with SIGHUP anymore.

[steve-chavez]

For anyone bumping into this, the issue could be an nginx conf, see #1399 (comment).

[NushratRia]

curl: (52) Empty reply from server
Does anyone find the solution for this?

[steve-chavez]

@NushratRia What's your OS and PostgREST version?

[jsommr]

Also, is the OS 32 bit? I had the same problem and it was gone when changing the same ubuntu to 64 bit.

[xevilstar]

please reopen problem persists on raspberry pi 4

[steve-chavez]

@xevilstar Sure. I'll reopen.

Can you share the output of uname -a(or hostnamectl) and your PostgREST version?

[steve-chavez]

Assuming this was the same problem as #2042 and #1399 - both closed.