pgdump not dumping my database

Started by Oliver Munyaoover 12 years ago4 messagesbugs
Jump to latest
#1Oliver Munyao
omunyao@gmail.com

Hi,
Am having a postgresql 9.2 database which is running very well with my
application.My only problem comes in when doing abackup where it backs up
empty tables theough my tables have data.I have another database in the
same installation which is backing up well , what could be the problem
here! am stuck

--
Kind Regards,
Munyao Oliver,
+254 718 108 359
omunyao@gmail.com

*“It's not the load that breaks you down, it's the way you carry it.” *

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Oliver Munyao (#1)
Re: pgdump not dumping my database

On Thu, 2013-11-21 at 18:29 +0300, Oliver Munyao wrote:

Am having a postgresql 9.2 database which is running very well with my
application.My only problem comes in when doing abackup where it backs
up empty tables theough my tables have data.I have another database in
the same installation which is backing up well , what could be the
problem here! am stuck

Please show exactly what command you are running and what output you
get.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#3Oliver Munyao
omunyao@gmail.com
In reply to: Peter Eisentraut (#2)
Re: pgdump not dumping my database

Hi am using PgadminIII dump option.It only dumps part of the DB with blank
tables though my database has data when i run my application.I have also
tried

pg_dump olli > mhu.backup but the output is the same as the pgadminII
one.Kindly help because I need to dump the same DB in another server.Am
running on postgres 9.2

On Sat, Nov 23, 2013 at 4:04 PM, Peter Eisentraut <peter_e@gmx.net> wrote:

On Thu, 2013-11-21 at 18:29 +0300, Oliver Munyao wrote:

Am having a postgresql 9.2 database which is running very well with my
application.My only problem comes in when doing abackup where it backs
up empty tables theough my tables have data.I have another database in
the same installation which is backing up well , what could be the
problem here! am stuck

Please show exactly what command you are running and what output you
get.

--
Kind Regards,
Munyao Oliver,
+254 718 108 359
omunyao@gmail.com

*“It's not the load that breaks you down, it's the way you carry it.” *

#4Oliver Munyao
omunyao@gmail.com
In reply to: Oliver Munyao (#3)
Re: pgdump not dumping my database

I meant the pgadminIII backup option ....Thanks!

On Mon, Nov 25, 2013 at 1:53 PM, Oliver Munyao <omunyao@gmail.com> wrote:

Hi am using PgadminIII dump option.It only dumps part of the DB with blank
tables though my database has data when i run my application.I have also
tried

pg_dump olli > mhu.backup but the output is the same as the pgadminII
one.Kindly help because I need to dump the same DB in another server.Am
running on postgres 9.2

On Sat, Nov 23, 2013 at 4:04 PM, Peter Eisentraut <peter_e@gmx.net> wrote:

On Thu, 2013-11-21 at 18:29 +0300, Oliver Munyao wrote:

Am having a postgresql 9.2 database which is running very well with my
application.My only problem comes in when doing abackup where it backs
up empty tables theough my tables have data.I have another database in
the same installation which is backing up well , what could be the
problem here! am stuck

Please show exactly what command you are running and what output you
get.

--
Kind Regards,
Munyao Oliver,
+254 718 108 359
omunyao@gmail.com

*“It's not the load that breaks you down, it's the way you carry it.” *

--
Kind Regards,
Munyao Oliver,
+254 718 108 359
omunyao@gmail.com

*“It's not the load that breaks you down, it's the way you carry it.” *