[pg_dump][1] defaults to plain SQL export. both data and structure. 

open [command prompt][2] and 
run `pg_dump -U username -h localhost databasename &gt;&gt; sqlfile.sql`

Above command is preferable as most of the times there will be an error which will be something like  - `...FATAL:  Peer authentication failed for user ...`

  [1]: https://www.postgresql.org/docs/current/static/app-pgdump.html
  [2]: http://windows.microsoft.com/en-us/windows-vista/open-a-command-prompt-window

In windows, first, make sure the path is added in environment variables PATH 

```C:\Program Files\PostgreSQL\12\bin```

After a successful path adding restart cmd and type command

```pg_dump -U username -p portnumber -d dbname -W -f location```
&gt; this command will export both schema and data 

for only schema use -s in place of -W
and for only data use -a.

replace each variable like username, portnumber, dbname and location according to your situation 
&lt;b&gt; everything is case sensitive, make sure you insert everything correctly,&lt;/b&gt;
and to import

```psql -h hostname -p port_number -U username -f your_file.sql databasename ```

make sure your db is created or creation query is present in .sql file

My problem is that **I don&#39;t know how to start using Retrofit 2.0 with received API** - mentioned below...

Firstly, I need to username, password, fbID (optional), gmailID (optional), twitID (optional), gender, birthDate, location (not required - if long and lat has values), longitude (optional), latitude (optional), profileImage (optional).

When all parameters are good - receive `status = true`. 
If not - receive `status = false` and required parameters which are wrong (e.g. mail is already taken)

So I can receive 
`status = true` 
or 
`status = false` and array with max 5 parameters (username, email, password, gender, birthDate).

I tried this `API Interface`:

    public interface AuthRegisterUserApi {
        @PUT()
        Call&lt;AuthRegisterUserModel&gt; getStatus(
                @Field(&quot;username&quot;) String username,
                @Field(&quot;email&quot;) String email,
                @Field(&quot;password&quot;) String password,
                @Field(&quot;fbID&quot;) String fbID,
                @Field(&quot;gmailID&quot;) String gmailID,
                @Field(&quot;twitID&quot;) String twitID,
                @Field(&quot;gender&quot;) String gender,
                @Field(&quot;birthDate&quot;) String birthDate,
                @Field(&quot;location&quot;) String location,
                @Field(&quot;longitude&quot;) String longitude,
                @Field(&quot;latitude&quot;) String latitude,
                @Field(&quot;profileImage&quot;) String profileImage
                );
    
        class Factory {
            private static AuthRegisterUserApi service;
    
            public static AuthRegisterUserApi getInstance() {
                Retrofit retrofit = new Retrofit.Builder()
                        .baseUrl(ApiConstants.REGISTER_URL)
                        .addConverterFactory(GsonConverterFactory.create())
                        .build();
    
                service = retrofit.create(AuthRegisterUserApi.class);
    
                return service;
            }
        }
    }

[with this API models (Pastebin.com)][1]

and this code in `Activity`:

    AuthRegisterUserApi.Factory.getInstance()
            .getStatus(
                    usernameEditText.getText().toString(),
                    emailEditText.getText().toString(),
                    passwordEditText.getText().toString(),
                    &quot;&quot;, &quot;&quot;, &quot;&quot;,
                    (maleRadioButton.isChecked() ? &quot;male&quot; : &quot;female&quot;),
                    mYear + &quot;-&quot; + mMonth+1 + &quot;-&quot; + mDay,
                    (geoLocationToggleButton.isChecked() ? geoLocationEditText.getText().toString() : &quot;&quot;),
                    (!geoLocationToggleButton.isChecked() ? &quot;50&quot; : &quot;&quot;),
                    (!geoLocationToggleButton.isChecked() ? &quot;50&quot; : &quot;&quot;),
                    &quot;&quot;)
            .enqueue(new Callback&lt;AuthRegisterUserModel&gt;() {
        @Override
        public void onResponse(Call&lt;AuthRegisterUserModel&gt; call, Response&lt;AuthRegisterUserModel&gt; response) {
            if(response.isSuccessful()) {
                if (response.body().isStatus()) {
                    showToast(getApplicationContext(), &quot;Registration ok.&quot;);
                } else {
                    response.body().getInfo().getUsername();
                }
            }
        }
    
        @Override
        public void onFailure(Call&lt;AuthRegisterUserModel&gt; call, Throwable t) {
    
        }
    });

I have error: `java.lang.IllegalArgumentException: @Field parameters can only be used with form encoding. (parameter #1) for method AuthRegisterUserApi.getStatus`

I tried to register user using Postman and it works when I used option `Body` -&gt; `x-www-form-urlencoded`.

**How can I create I `register` query to this API?** Change `@Field` to something else? I have got this error always...

**EDIT: Need to change `API Interface` to this**:

    public interface AuthRegisterUserApi {
        @FormUrlEncoded
        @PUT(&quot;/api/register&quot;)
        Call&lt;AuthRegisterUserModel&gt; getStatus(
                @Field(&quot;username&quot;) String username,
                @Field(&quot;email&quot;) String email,
                @Field(&quot;password&quot;) String password,
                @Field(&quot;fbID&quot;) String fbID,
                @Field(&quot;gmailID&quot;) String gmailID,
                @Field(&quot;twitID&quot;) String twitID,
                @Field(&quot;gender&quot;) String gender,
                @Field(&quot;birthDate&quot;) String birthDate,
                @Field(&quot;location&quot;) String location,
                @Field(&quot;longitude&quot;) String longitude,
                @Field(&quot;latitude&quot;) String latitude,
                @Field(&quot;profileImage&quot;) String profileImage
                );
    
        class Factory {
            private static AuthRegisterUserApi service;
    
            public static AuthRegisterUserApi getInstance() {
                Retrofit retrofit = new Retrofit.Builder()
                        .baseUrl(ApiConstants.BASE_URL)
                        .addConverterFactory(GsonConverterFactory.create())
                        .build();
    
                service = retrofit.create(AuthRegisterUserApi.class);
    
                return service;
            }
        }
    }

`BASE_URL = http://ip_address:8400` for me...

But still got error: `Response.rawResponse = Response{protocol=http/1.1, code=400, message=Bad Request, url=http://ip_address:8400/api/register}`. Using Postman with the same data I received code=201 Created. **Don&#39;t know why...**

  [1]: http://pastebin.com/7X5D0NjL

Retrofit 2.0 throwing &quot;IllegalArgumentException: @Field parameters can only be used with form encoding&quot;. How to do right API query and fix it?

So, I&#39;m diving deeper and deeper into **Clojure.Spec**.

One thing I stumbled upon is, **where to put my specs**. I see three options:


# Global Spec File

In most examples, I found online, there is one big `spec.clj` file, that gets required in the main namespace. It has all the `(s/def)` and `(s/fdef)` for all the &quot;data types&quot; and functions.

Pro: 

* One file to rule them all

Contra:

* This file can be big
* Single Responsibliy Principle violated?


# Specs in production namespaces

You could put your `(s/def)` and `(s/fdef)` right next to your production code. So that, the implementation and the spec co-exist in the same namespace.

Pro:

* co-location of implementation and spec
* one namespace - one concern?

Contra:

* production code could get messy
* one namespace - two concerns?

# Dedicated spec namespace structure

Then I thought, maybe Specs are a third kind of code (next to production and test). So maybe they deserve their own structure of namespaces, like this:

    ├─ src
    │&#160; └─ package
    │   &#160; ├─ a.clj
    │   &#160; └─ b.clj
    ├─ test
    │&#160; └─ package
    │   &#160; ├─ a_test.clj
    │   &#160; └─ b_test.clj
    └─ spec
     &#160; └─ package
        &#160; ├─ a_spec.clj
        &#160; └─ b_spec.clj

Pro:

* dedicated (but related) namespaces for specs

Contra:

* you have to source and require the correct namespaces

---

Who has experience with one of the approaches?  
Is there another option?  
What do you think about the different options?

Where to put specs for Clojure.Spec?

I want to export my database as a .sql file. 
Can someone help me? The solutions I have found don&#39;t work.
A detailed description please.
On Windows 7.

Postgresql Database export to .sql file

<p>I want to export my database as a .sql file.
Can someone help me? The solutions I have found don't work.
A detailed description please.
On Windows 7.</p>


I&#39;m creating a lot of migrations that have foreign keys in PostgreSQL 9.4.

This is creating a headache because the tables must all be in the exact order expected by the foreign keys when they are migrated. It gets even stickier if I have to run migrations from other packages that my new migrations depend on for a foreign key.

In MySQL, I can simplify this by simply adding `SET FOREIGN_KEY_CHECKS = 0;` to the top of my migration file. How can I do this temporarily in PostgresSQL only for the length of the migration code?

BTW, using the Laravel Schema Builder for this.

Disable PostgreSQL foreign key checks for migrations

I would like to &quot;declare&quot; what are effectively multiple TEMP tables using the WITH statement. 
The query I am trying to execute is along the lines of:

    WITH table_1 AS (
    SELECT GENERATE_SERIES(&#39;2012-06-29&#39;, &#39;2012-07-03&#39;, &#39;1 day&#39;::INTERVAL) AS date
    )
    
    WITH table_2 AS (
    SELECT GENERATE_SERIES(&#39;2012-06-30&#39;, &#39;2012-07-13&#39;, &#39;1 day&#39;::INTERVAL) AS date
    )
    
    SELECT * FROM table_1
    WHERE date IN table_2

I&#39;ve read [PostgreSQL documentation][1] and researched into using multiple `WITH` statements and was unable to find an answer. 



  [1]: https://www.postgresql.org/docs/9.5/static/functions-srf.html

How to use multiple WITH statements in one PostgreSQL query?

    INSERT into Group (Name,CreatedDate) VALUES (&#39;Test&#39;,UTC_TIMESTAMP(), 1);

This is the query I have used for mysql to insert current date time.
When I am using this in postgresql, I am getting below error.

        HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    ********** Error **********
    
    ERROR: function utc_timestamp() does not exist
    SQL state: 42883

I have tried like below using `now()`, however it is inserting like `&quot;2016-07-07 17:01:18.410677&quot;`. I need to insert in `&#39;yyyymmdd hh:mi:ss tt&#39;` format.

    INSERT into Group (Name,CreatedDate) VALUES (&#39;Test&#39;,UTC_TIMESTAMP(), 1);

How to insert current date time in insert query of postgresql in above format ?

How to insert current datetime in postgresql insert query

## Problem ##
I&#39;m trying to start postgres in a docker container on my Mac, but I keep getting the following error message

&gt; docker: Error response from daemon: driver failed programming external connectivity on endpoint postgres (8392b9e5cfaa28f480fe1009dee461f97e82499726f4afc4e916358dd2d2f61e): Error starting userland proxy: Failed to bind tcp 0.0.0.0:5432 address already in use.

I have postgres installed locally, but I stopped it and running 

    pg_ctl status

returns 
&gt;pg_ctl: no server running

I&#39;ve ran the following to check what&#39;s running on 5432 

    lsof -i tcp:5432

&amp;

    netstat -anp tcp | grep 5432

and nothing is running on the port.

## Versions ##

Mac - OS X El Capitan Version 10.11.2

PostgreSQL - 9.5 

Docker - Docker version 1.12.0-rc2, build 906eacd, experimental


Docker &amp; Postgres: Failed to bind tcp 0.0.0.0:5432 address already in use

I have PostgreSQL 9.3 installed on a server running Ubuntu Server 14.04.

If I ssh into the server via terminal, I&#39;m able to connect with psql. But when I try to configure pgAdmin III to do the remote connection, I get:

&gt; Server doesn&#39;t listen The server doesn&#39;t accept connections: the
&gt; connection library reports  could not connect to server: Connection
&gt; refused Is the server running on host &quot;172.24.3.147&quot; and accepting
&gt; TCP/IP connections on port 5432?

When I run on the server `service postgresql status` it gives me:

    9.3/main (port 5432): online

So of course I&#39;m missing something important here.

EDIT

When running `netstat -na` on the server, I get (relevant portion, I guess):

    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State      
    tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN     
    tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN     
    tcp        0      0 172.24.3.147:22         172.24.3.240:61950      ESTABLISHED
    tcp        0      0 172.24.3.147:22         172.24.3.240:60214      ESTABLISHED



Content Type	Original Author	Original Content on Stackoverflow
Question	moxmlb	View Question on Stackoverflow
Solution 1 - Postgresql	Vao Tsun	View Answer on Stackoverflow
Solution 2 - Postgresql	Chirag goyal	View Answer on Stackoverflow

Postgresql Database export to .sql file

Postgresql Problem Overview

Postgresql Solutions

Solution 1 - Postgresql

Solution 2 - Postgresql

Where to put specs for Clojure.Spec?

Retrofit 2.0 throwing "IllegalArgumentException: @Field parameters can only be used with form encoding". How to do right API query and fix it?

Attributions