Re: [pgadmin-support] Unable to Restor Table Named "User"

2015-06-15 Thread Soule, Cathi (HQP)
Is this what you mean? If so, no success. Or should I try something else? I really appreciate your help. [cid:image001.png@01D0A75A.4CBC04B0] From: Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com] Sent: Monday, June 15, 2015 10:50 AM To: Soule, Cathi (HQP) Cc: pgadmin-support@postgresql

Re: [pgadmin-support] Unable to Restor Table Named "User"

2015-06-15 Thread Melvin Davidson
Cathi, If the restore command is reporting no errors "Process returned exit code 0.", but the table exists and has no data, then it is quite probable thatA. The backup was made when there was no data in the tableORB. The backup of the user table was made with the  -s or -schema-only flag, which

Re: [pgadmin-support] Unable to Restor Table Named "User"

2015-06-15 Thread Soule, Cathi (HQP)
Hi Melvin, Still not working for me – sorry I am new to Postgres and not a unix person--- Any help you can provide is much appreciated. --The data is not being restored for table ‘user’. It appears that the ‘process returned exit code 0’ msg is for the first step only (connecting to database

Re: [pgadmin-support] Unable to Restor Table Named "User"

2015-06-15 Thread Ashesh Vashi
Try this command on the command-prompt: "C:\Program Files\PostgreSQL\9.4\bin\pg_restore.exe" --host localhost --port 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table "\"user\"" --schema xyz1 --verbose "E:\20150611 Mig32QA user4.backup" -- Thanks & Regards, A

Re: [pgadmin-support] Unable to Restor Table Named "User"

2015-06-15 Thread Melvin Davidson
"Process returned exit code 0." Indicates No errors occurred during the restore, so I do not understand what exactly your problem is. Are there any errors in the PostgreSQL error log file with regards to your "user" table? What is the setting for log_min_messages & log_min_error_statement in pos

[pgadmin-support] Unable to Restor Table Named "User"

2015-06-15 Thread Soule, Cathi (HQP)
Hello, We are not able to restore a table using pgAdmin from object browser. We have been successful using backup / restore functions with 30 other tables. However, we are not able to restore one table named 'user'. Here are details: Thank you! - pgAdmin version 1.20.0 -

[pgadmin-support] Naming of 'valid until' in role properties

2015-06-15 Thread Jan-Peter Seifert
Hello, on the 'Definition' tab in role properties 'valid until' is named 'Account expires'. This is not correct. It's the password and not the account that expires and therefore affects roles for which password authentication methods (password or md5) are being used only. Best regards, Peter

[pgadmin-support] backtrace pgadmin3 wx3.0 assertion error when saving query to file

2015-06-15 Thread Vincent schurink
Hi PGadmin folks, We've run into an issue with Pgadmin3 - version 1.20.0 (pgadmin3 1.20.0-1.pgdg70+1 amd64) on our debian wheezy (7.8) system. Whenever we try to run query and save to file we get an (non-fatal) assert error backtrace. If we ignore the error the output gets stored successfull