[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.

[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

[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

[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

[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

[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 #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',

[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 #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

[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

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

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] 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

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 report!

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

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 might

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] 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 --- thanks for