[BUGS] Installing PG 7.3.4 on Linux 6
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
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 upgrade this database to a newer one or move to another database. System Specs: Win 2000 Server Postgresql 8.0.0 beta 5 Sincerely, Rogelio Monter Magnabyte. Abedules 120, Santa María Insurgentes, Mexico City. Mexico. * http://www.magnabyte.com.mx/* *Rogelio Monter* *Ingeniero de Soporte* rmon...@magnabyte.com.mx Tel. +52 (55) 5541-6073 Abedules 120, Santa María Insurgentes. 06430 Deleg. Cuauhtémoc, Ciudad de México Síguenos en: [image: Facebook]https://www.facebook.com/pages/Magnabyte-SA-de-CV/151768011516300 [image: Twitt us!!!] https://twitter.com/#!/Magnabyte_SA [image: LinkedIn]http://linkd.in/zeUwhz 1er Empresa certificada en MoproSoft Nivel 2 de Calidad (NMX-I-059/02-NYCE-2005) http://www.moprosoft.com.mx/
[BUGS] BUG #7733: support Retina display in pgAdmin
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.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #7739: Specifying PGLOG in sysconfig breaks initdb
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/pgstartup.log service postgresql-9.2 initdb will fail because /pgdata is not empty when it is checking. When out the PGLOG line, initdb will succeed and it can be added back. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #7740: Installation cannot fine msi file
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 installation: Failed to open http://ftp.postgresql.org/pub/projects/pgFoundry/stackbuilder/PgOleDB-1.0.0.20.msi; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #7736: error reading c:\Program Files\PostgreSQL\9.1\data\postgresql.conf during installation
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 an error message c:\Program Files\PostgreSQL\9.1\data\postgresql.conf i tried the solution given in http://archives.postgresql.org/pgsql-bugs/2009-01/msg00132.php but it didnt wrked.plz help me to sort this issue i have been working on it for past 1 week Regards, Ponraj.S -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #7734: JPA2/Hibernate4 PG enum insert causes exception
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', 'female', 'unknown');
create sequence my_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1;
create table my_table (
idinteger NOT NULL DEFAULT nextval('my_seq'),
gender_type GENDER_ENUM NOT NULL,
CONSTRAINT my_table_pkey PRIMARY KEY(id)
);
insert into my_table (gender) values ('male');
insert into my_table (gender) values ('female');
insert into my_table (gender) values ('unknown');
[2] Persistence.xml file
?xml version=1.0 encoding=UTF-8?
persistence xmlns=http://java.sun.com/xml/ns/persistence;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd;
version=2.0
persistence-unit name=MyPersistenceUnit
transaction-type=RESOURCE_LOCAL
descriptionPersistence unit/description
providerorg.hibernate.ejb.HibernatePersistence/provider
properties
property name=hibernate.dialect
value=org.hibernate.dialect.PostgreSQLDialect/
property name=javax.persistence.jdbc.driver
value=org.postgresql.Driver /
property name=javax.persistence.jdbc.url
value=jdbc:postgresql://localhost:5432/mydb /
property name=javax.persistence.jdbc.user value=user /
property name=javax.persistence.jdbc.password
value=password /
property name=hibernate.hbm2ddl.auto value=validate/
property name=hibernate.show_sql value=false /
property name=hibernate.format_sql value=false /
property name=prefer_sequence_per_entity value=true /
/properties
/persistence-unit
/persistence
[3] Entity code
package com.mypackage;
import java.sql.Timestamp;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Transient;
@Entity(name=my_table)
public class MyTable {
@SequenceGenerator(name=generatorMySeq, sequenceName=my_seq,
allocationSize=1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator =
generatorMySeq)
@Id
@Column(name = id)
private long id;
@Enumerated(EnumType.STRING)
@Column(name=gender_type, columnDefinition=GENDER_ENUM)
private GenderEnum gender;
// getters and setters
}
[4] My Java enumerated type
public enum GenderEnum {
male, female, unknown;
}
[5] JUnit test
public class Test_MyTable {
@Test
public void test_1() {
EntityManagerFactory emf =
Persistence.createEntityManagerFactory(MyPersistenceUnit);
EntityManager em = emf.createEntityManager();
MyTable myTable = new MyTable();
myTable.setGender(GenderEnum.male);
em.getTransaction().begin();
em.persist(ac);
em.getTransaction().commit();
em.close();
emf.close();
}
}
[6] Exception
The exception is:
Caused by: org.postgresql.util.PSQLException: ERROR: column “gender_type” is
of type GENDER_ENUM but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #7741: Two bugs when backing up databases with default privileges defined on public schema
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 - Create a new database called test_database with default settings - Run the following SQL: alter default privileges in schema public grant all on tables to my_group; alter default privileges in schema public grant all on functions to my_group; alter default privileges in schema public grant all on sequences to my_group; alter default privileges in schema public grant all on types to my_group; - Using pgAdmin III, backup the test_database database using the plain format and note the error. Here's the log: C:/Program Files/PostgreSQL/9.2/bin\pg_dump.exe --host localhost --port 5432 --username postgres --no-password --format plain --verbose --file D:\Databases\PostgreSQL Backups\test_database.backup test_database pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading extensions pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading table inheritance information pg_dump: reading rewrite rules pg_dump: finding extension members pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving database definition pg_dump: unknown object type (84) in default privileges Process returned exit code 1. - Again in pgAdmin III, right-click the public schema and choose Properties - Navigate to the Default Privileges tab and note how no default privileges show up, even though they are present -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #7738: Installer takes hours running icacls
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 drive where i've put the data directory, which is not the system drive. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] pg_restore
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 -v /home/postgres/backup.sql,but i get an error:pg_restore:[archiver] input file appears to be a text format dump.Please use psql Thanks in advance for your suggestions.
Re: [BUGS] Installing PG 7.3.4 on Linux 6
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 history book, you want something more current. on Linux 6 What is the output of?: uname -a -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] pg_restore
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, you need to run the script file in through psql. If it contains steps you don't want to execute, you will need to copy and edit the file to leave just the portions you want to run. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7733: support Retina display in pgAdmin
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 your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7741: Two bugs when backing up databases with default privileges defined on public schema
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! - Again in pgAdmin III, right-click the public schema and choose Properties - Navigate to the Default Privileges tab and note how no default privileges show up, even though they are present This may be a consequence of the other problem, but in case it isn't, you should report it on the pgadmin mailing list. pgsql-bugs generally just deals with bugs in the core Postgres distribution. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Migrate Posgresql 8.0.0 beta 5
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 with the Windows implementation which weren't solved until 8.2. We never recommend using a beta test version in production. http://www.postgresql.org/support/versioning/ The version to look at moving to now would be 9.1 or 9.2. 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. I'm not personally aware of any datatype being dropped. how i can upgrade this database to a newer one Install the new software in a different directory (or an a different machine) from the old 8.0.0 beta test software. Use pg_dump from the new software to dump the old database and load a new database. Test for issues before making it live in production. Do it soon; the version you are using is not meant for production, and it would not be surprising if it ate your data. Also, make sure you are taking frequent backups and keeping several generations of them. Future postings on the topic should be on the pgsql-general list; this list is for bug reports. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Installing PG 7.3.4 on Linux 6
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 find http://www.postgresql.org/community/lists/ useful - in particular click on the 'pgsql-novice' mailing list link, as 'No question is too simple for this list'! You might find http://wiki.postgresql.org/wiki/FAQ useful, PG 7.3.4 is no longer supported, the oldest supported version is 8.3.22. You would be well advised to install 8.4 or later, preferably at least 9.1. The most up-to-date version of pg is 9.2.2. Linux is a kernel, the latest version is *3.6.9 - '*Linux 6' is meaningless. More useful is the distribution, Fedora, Ubuntu, ... Usually Linux distibutions have some sort of package manager, that will install a reasonably current version of Postgres. Cheers, Gavin
Re: [BUGS] pg_restore
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 -p 5432 -U postgres -d payroll --data-only -v /home/postgres/backup.sql, but i get an error: pg_restore:[archiver] input file appears to be a text format dump.Please use psql pg_restore is only for binary dumps such as are generated by pg_dump -Fc plain text dumps are restored with psql -f filename.sql if you dumped just the data, then thats all it will restore (data only mean it won't create the tables and such), but you probably should truncate the existing tables first if there's old data in them. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7741: Two bugs when backing up databases with default privileges defined on public schema
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 the report! Ugh ... there were more creepy-crawlies under that rock than I expected. I've squashed a bunch of them: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6cb8c6043ee47ced46da131bc0705e9c4bdd8667 but I wouldn't really want to bet that I didn't miss anything. If you have the ability to apply patches locally, please apply that one and keep testing. If not, I'd recommend staying away from datatype privileges until 9.2.3 is out ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
