topic How to pg_dump the database for backup? in Nuxeo Forum

How to pg_dump the database for backup?

Alessandro_Raff — Thu, 17 May 2012 18:03:24 GMT

OS: Ubuntu Server 12.04 LTS

PostgreSQL 9.1

I've logged in via SSH.

Nuxeo: 5.5 ( installed via apt-get )

I've tried several commands and/or psql but can't find and dump the nuxeo db.

$ sudo su - postgres

$ psql

# SELECT * FROM pg_user;

I only see 1 user: postgres

# \l

I only see postgres, template0 and template1

Where are nuxeo user and db?

Any help?

Fred_Vadon — Fri, 18 May 2012 10:48:58 GMT

Hi!

If you are running a default installation, it's probably because the nuxeodb postgres server is listening on port 5433. If you connect with :

psql -p 5433

then you should see more infos 🙂

And a command like :

pg_dump -p 5433 -f yourdumpfile.dump nuxeo

should give you what you are looking for.

Alessandro_Raff — Fri, 18 May 2012 12:00:04 GMT

Thanks!!!