Re: [BUGS] BUG #7741: Two bugs when backing up databases with default privileges defined on public schema

2012-12-08 Thread Tom Lane
I wrote: > m...@nathanalden.com writes: >> alter default privileges in schema public grant all on types to my_group; >> [ leads to ] >> pg_dump: unknown object type (84) in default privileges > Hmm ... looks like whoever added GRANT ON TYPES did a pretty half-baked > job. Will look into it --- th

Re: [BUGS] pg_restore

2012-12-08 Thread John R Pierce
On 12/5/2012 4:40 AM, Branka Stancic wrote: I have problem. I want to restore only data in database. In pgAdmin I was backup only data from old database and now i have backup file backup.sql. In terminale I want restore only data in new database and I using command pg_restore -i -h localhost -

Re: [BUGS] Installing PG 7.3.4 on Linux 6

2012-12-08 Thread Gavin Flower
On 05/12/12 19:49, JEHAD GHAREEB wrote: Hi all, I want to install "PG 7.3.4" on Linux 6 . So please send all instructions to complete installation . Your prompt response is highly appreciated . Regards, Jehad G. Requesting information is not a bug. If you need further help, then you migh

Re: [BUGS] Migrate Posgresql 8.0.0 beta 5

2012-12-08 Thread Kevin Grittner
Rogelio Monter wrote: > In my company, we're using Postgresql 8.0.0 beta 5 since the > company started to implement databases. > Win 2000 Server Version 8.0 is years out of support, support for it and 8.1 on Windows was dropped years earlier than for other platforms because there were problems w

Re: [BUGS] BUG #7741: Two bugs when backing up databases with default privileges defined on public schema

2012-12-08 Thread Tom Lane
m...@nathanalden.com writes: > alter default privileges in schema public grant all on types to my_group; > [ leads to ] > pg_dump: unknown object type (84) in default privileges Hmm ... looks like whoever added GRANT ON TYPES did a pretty half-baked job. Will look into it --- thanks for the repor

Re: [BUGS] BUG #7733: support Retina display in pgAdmin

2012-12-08 Thread Kevin Grittner
p.ela...@gmail.com wrote: > Description: > > subj This is not a bug report. You might try posting on the pgsql-general list. If you want any useful response, you need to provide a little more detail. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to y

Re: [BUGS] pg_restore

2012-12-08 Thread Kevin Grittner
Branka Stancic wrote: > I using command pg_restore > get an error: pg_restore: [archiver] input file appears to be a > text format dump. Please use psql pg_restore is not used for restoring text files; psql is. If you want to use pg_restore you should use -Fc when you run pg_dump. At this point,

Re: [BUGS] Installing PG 7.3.4 on Linux 6

2012-12-08 Thread Kevin Grittner
This is not a bug report. Next time post to a more appropriate list. http://www.postgresql.org/community/lists/ JEHAD GHAREEB wrote: > I want to install "PG 7.3.4" That version has been out of support for over five years. http://www.postgresql.org/support/versioning/ Unless you're writing a h

[BUGS] pg_restore

2012-12-08 Thread Branka Stancic
Hi,I have problem.I want to restore only data in database.In pgAdmin I was backup only data from old database and now i have backup file backup.sql.In terminale I want restore only data in new database and I using command pg_restore -i -h localhost -p 5432 -U postgres -d payroll --data-only -

[BUGS] BUG #7738: Installer takes hours running icacls

2012-12-08 Thread dnd1066
The following bug has been logged on the website: Bug reference: 7738 Logged by: dnd Email address: dnd1...@gmail.com PostgreSQL version: 9.2.2 Operating system: Windows 8 Description: The installer is trying to change access permissions on every directory in the driv

[BUGS] BUG #7741: Two bugs when backing up databases with default privileges defined on public schema

2012-12-08 Thread me
The following bug has been logged on the website: Bug reference: 7741 Logged by: Nathan Alden, Sr. Email address: m...@nathanalden.com PostgreSQL version: 9.2.2 Operating system: Windows 7 x64 Description: - Create new group role called my_group with default settings

[BUGS] BUG #7734: JPA2/Hibernate4 PG enum insert causes exception

2012-12-08 Thread rmitchell
The following bug has been logged on the website: Bug reference: 7734 Logged by: Rob Mitchell Email address: rmitch...@bzzagent.com PostgreSQL version: 9.1.4 Operating system: MacOS X 10.7 Description: [1] Database script create type GENDER_ENUM as enum ('male', 'fem

[BUGS] BUG #7736: error reading c:\Program Files\PostgreSQL\9.1\data\postgresql.conf during installation

2012-12-08 Thread toponraja
The following bug has been logged on the website: Bug reference: 7736 Logged by: ponraj Email address: toponr...@gmail.com PostgreSQL version: 9.1.6 Operating system: windows xp Description: i tried to install postgres 9.1 but at the end of installation process i got

[BUGS] BUG #7740: Installation cannot fine msi file

2012-12-08 Thread al_chirico
The following bug has been logged on the website: Bug reference: 7740 Logged by: Al Chirico Email address: al_chir...@hotmail.com PostgreSQL version: 9.2.2 Operating system: Win 7 Pro Description: I am getting the following Stack Builder error message during installat

[BUGS] BUG #7739: Specifying PGLOG in sysconfig breaks initdb

2012-12-08 Thread chip . schweiss
The following bug has been logged on the website: Bug reference: 7739 Logged by: Chip Schweiss Email address: chip.schwe...@wustl.edu PostgreSQL version: 9.2.2 Operating system: Centos 6.3 Description: If I set the following in sysconfig: PGDATA=/pgdata PGLOG=/pgdata/

[BUGS] BUG #7733: support Retina display in pgAdmin

2012-12-08 Thread p . elagin
The following bug has been logged on the website: Bug reference: 7733 Logged by: Petr Elagin Email address: p.ela...@gmail.com PostgreSQL version: 9.2.1 Operating system: mac os 10.8.2 Description: subj -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.or

[BUGS] Migrate Posgresql 8.0.0 beta 5

2012-12-08 Thread Rogelio Monter
Hello, In my company, we're using Postgresql 8.0.0 beta 5 since the company started to implement databases. A co-worker said that he couldn't migrate from this version to a newer onw because it use a datatype that doesn't exist anymore. Could you tell me if thats correct. If it is, how i can upg

[BUGS] Installing PG 7.3.4 on Linux 6

2012-12-08 Thread JEHAD GHAREEB
Hi all,  I want to install "PG 7.3.4" on Linux 6 . So please send all instructions to complete installation . Your prompt response is highly appreciated . Regards, Jehad G.