Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    manila
    Posts
    9

    Unanswered: How to: psql dump data?

    good day to all..

    is there anyone can tell me how can i dump a database from a PostgreSQL server?
    let say im connecting to host 123.16.0.100 with the data marter_data. what i want to do is dump this data to my local machine so i will not dammage the server data. what command should i use or howw can i accomplish that?

    BTW my /usr/local/pgsql/data was i set to initdb..

    im running RH7.3 and PostgreSQL7.3.2

    any suggestion will great appreciated. thaks you so much.

    chris

  2. #2
    Join Date
    Mar 2004
    Posts
    110
    u can dump a database with pg_dump.

    Check it out in the docs.

    -Ed

  3. #3
    Join Date
    Mar 2004
    Location
    manila
    Posts
    9

    How to: psql dump data?

    Originally posted by Edje
    u can dump a database with pg_dump.

    Check it out in the docs.

    -Ed
    i try this and ggot some warning/error:
    [neo@trinity neo]$ pg_dump -a -C -h 123.16.0.100 -U neo polmap_akbayan > pol_ak_copy.out
    Password:
    [neo@trinity neo]$ psql -d test -f pol_ak_copy.out
    psqlol_ak_copy.out:5: \connect: FATAL: user "dbadmin" does not exist
    ------------------------------
    what thats should mean? what ii have to do to solve it?

    plss help..

  4. #4
    Join Date
    Mar 2004
    Posts
    110
    dbadmin, is that your login name to the computer perhaps?

    Looks to me that the dbadmin account isnt known in postgresql. (pg_shadow; wich stores all user(s))

    -Ed

  5. #5
    Join Date
    Mar 2004
    Location
    manila
    Posts
    9
    Originally posted by Edje
    dbadmin, is that your login name to the computer perhaps?

    Looks to me that the dbadmin account isnt known in postgresql. (pg_shadow; wich stores all user(s))

    -Ed
    dbadmin is my my loggin name but im a member of admin user group to the postgres data base..

    is there a way i can used dumb database to my local drive from server?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •