pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Postgresql pg_dumpall
2+ messages / 1 participants
[nested] [flat]

* Re: Postgresql pg_dumpall
@ 2007-11-03 23:39  Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Koczan @ 2007-11-03 23:39 UTC (permalink / raw)
  To: Suresh Gupta VG <suresh.g@zensar.com>; +Cc: pgsql-admin

Hi Suresh, you should Cc: pgsql-admin@postgresql.org in case I don't know or
someone else can help you sooner.

I am using on prod server with psql version : psql 7.4.2
>
> In another test server the version of psql is : Portions Copyright (c)
> 1996-2003, (could not get version)
>
You should figure out what version you're running. You can run psql
--version in a terminal to figure that out. Make sure you're running the
latest revision of whatever major version you choose (8.2.5, for instance).

> I could run this command on test server but couldn't run on prod server.
> May I have some help? Where commercelink is my database name. We use to
> enter into database like this "psql commercelink".
>
pg_dumpall dumps an entire database cluster, not just a database. Either
omit the database name or use pg_dump instead of pg_dumpall.

Peter

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgresql pg_dumpall
@ 2007-11-05 17:32  Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Koczan @ 2007-11-05 17:32 UTC (permalink / raw)
  To: Suresh Gupta VG <suresh.g@zensar.com>; +Cc: pgsql-admin

>
> *CC mailing* : I got the bounced mail as in attachment from you when I
> CCed to "pgsql-admin@postgresql.org" So, I am not doing so.
>
Like the message says, you should contact the powers that be to figure out
what happened. Please always email the mailing list, as I am *not* your
personal help desk.

> *Version* : I used psql –help, it does not work, So, I used psql –V, it
> gave me the result as follows
>
So psql and the server are different versions...that's concerning and
confusing.

> *Updation to new version *: Now we are in implementation of new module
> with tight schedule for our application. Once we complete that we will
> concentrate on this. In the mean time, can you please provide us how to
> update to latest version. We are using "Solaris 9 9/04 s9s_u7wos_09 SPARC"
> and current version of database on this server is Psql 7.4.2
>
 http://www.postgresql.org/docs/8.2/static/install-upgrading.html

> *Pg_dumpall *: pg_dumpall is working without database name on psql 7.4.2.
>

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-11-05 17:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-03 23:39 Re: Postgresql pg_dumpall Peter Koczan <pjkoczan@gmail.com>
2007-11-05 17:32 Re: Postgresql pg_dumpall Peter Koczan <pjkoczan@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox