Postgres : pg_dump Error

Tags

error, postgres, shell scripts

Top Forums Shell Programming and Scripting Postgres : pg_dump Error

08-11-2008

Registered User

748, 11

Join Date: Jul 2008

Last Activity: 15 January 2015, 10:57 AM EST

Location: Frederick, MD

Posts: 748

Thanks Given: 4

Thanked 11 Times in 10 Posts

print the output of

ls -lR /home/backup

or run that command and see who has ownership of all the files

Ikon

View Public Profile for Ikon

Find all posts by Ikon

08-11-2008

Registered User

64, 0

Join Date: Jan 2008

Last Activity: 5 August 2013, 4:50 AM EDT

Posts: 64

Thanks Given: 0

Thanked 0 Times in 0 Posts

Postgres Error

Thanks a lot
problem is solved

jagnikam

View Public Profile for jagnikam

Find all posts by jagnikam

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using shell scripting for making queries on postgres sql

I have a situation where I have a list of airplanes that make a series of flights. Therefore I am looking up the different flights that each airplane makes based on a postgres sql query: select flightid from plane where airplane='DELTAx' As a result I get a series of flight numbers...

2. Shell Programming and Scripting

Script for removing Postgres

I made a script to remove Postgres if this is already installed on your system. I have a other script to install Postgres, so this script can be used before you going to install Postgres. Do you like this script? I would love to hear feedback. #!/bin/bash # #################################...

3. UNIX for Advanced & Expert Users

How to set postgres process in monit file?

Dear Friends, I need to add the postgres process in monit file ( Debian machine ). How to add that process in monit?. If anyone know the solution for this, pls let me know. ---------- Post updated at 02:27 PM ---------- Previous update was at 12:21 PM ---------- I have found the...

4. Shell Programming and Scripting

Postgres in Linux

I have this 15 postgres sql queries similar to below to run in linux... Its taking a lot of time to run (3hours) . can any one plz guide me how can i reduce the time of execution execute 'insert into cc.rpt_cons_sub_ccdb_data(report_date, server_name, report_type, count) select...

5. Shell Programming and Scripting

help copy *.txt to postgres

hi all, a have problem to load *.txt to postgres my database: id_list_ip (nextval) list_ip (varchar) txt file (list_ip.txt) hasilping_10.8.248.1 hasilping_119.110.112.226 hasilping_119.110.125.33 hasilping_125.22.1.25 hasilping_192.168.2.1 hasilping_202.73.96.70 script...

6. Shell Programming and Scripting

How to write cron job for calling sql function database is postgres

Hi, Please help me to write cron job for calling sql function daily. I have Postgres database.

7. Shell Programming and Scripting

testing postgres connection in shell script

I have a script that does db query in postgres. I'm trying to put in some error checking in the script. I keep running into the password prompt problem where when invalid credentials/or database is put it, it would prompt me for a password which hangs the script. Is there a way that I can check for...

8. Shell Programming and Scripting

Backup-Script for Postgres

Hi, I'm working with postgres. Now I found a script to backup my databases. # #!/bin/bash # # # setup environment PG_PORT=5432 PG_HOME=/usr/lib/postgresql/8.3 PG_VAR=/backup PG_DATA=/backup/data PG_BACKUPS=/backup/backup PG_LOGS=/backup/logs ...

9. Shell Programming and Scripting

how will i connect postgres database from unix shell script

I have got the solution so just closing this issue.

Shell Programming and Scripting