[ADMIN] Postgres encryption export.

Hi everyone, There is a question about Export Administration Regulations(EAR) of the United States. i) What is the ECCN (Export Control Classification Number) for PostgreSQL? (Ex. 5D002,etc) ii) Are there any export restrictions for PostgreSQL? Best Regards, -- Sent via pgsql-admin mailing

[ADMIN] Indexing + performance

Dear Friends, I have a table with 50 lakhs records, the table has more then 10 fields, i have primary key, i have select query with count(*) without any condition, it takes 17 seconds. I have another one query which will do joins with other small tables, it takes 47 seconds to give output,

[ADMIN] unuscribe

[ADMIN] Error with PG_MODULE_MAGIC macro

Hi List, We are under up gradation of pgsql 7.4.2 to latest version 8.2.25 on Solaris-9. While compiling the source, we found some error with encryption file. As per the pgsql admin team suggestions, we included the macro of PG_MODULE_MAGIC, in the code while creating the 2 functions. An error

Re: [ADMIN] Postgres port bindings changed after box restart

On Wed, Mar 05, 2008 at 10:07:14AM +1100, Daniel Punton wrote: > Our redhat server was restarted and postgres is showing different databases > on different ports? > Could someone explain how this might happen Different configuration files? > and where this information comes from (what conf for po

Re: [ADMIN] Postgres port bindings changed after box restart

>>> On Tue, Mar 4, 2008 at 5:07 PM, in message <[EMAIL PROTECTED]>, "Daniel Punton" <[EMAIL PROTECTED]> wrote: > Our redhat server was restarted and postgres is showing different databases > on different ports? > Could someone explain how this might happen > and where this information comes from

Re: [ADMIN] [DOCS] Documenting a DB schema

On Tue, Mar 04, 2008 at 12:02:27PM -0800, Shahaf Abileah wrote: > I'm looking for a systematic way to document the schema for the database > behind our website (www.redfin.com ), so that > the developers using this database have a better idea what all the > tables and colum

[ADMIN] optimizating postgresql

any documents or URL to do the optimizations of the postgres

Re: [ADMIN] optimizating postgresql

>>> On Wed, Mar 5, 2008 at 9:32 AM, in message <[EMAIL PROTECTED]>, "sathiya psql" <[EMAIL PROTECTED]> wrote: > any documents or URL to do the optimizations of the postgres http://www.postgresql.org/docs/8.3/interactive/performance-tips.html http://www.postgresql.org/docs/8.3/interactive

[ADMIN] Can't Download Postgresql-V8.2.4 for Redhat Enteprise-V4

Hello I am trying to download the postgresql version 8.2.4 for Redhat Enteprise version 4. However, I can’t download them. All I get is “The page cannot be displayed”. Can you please re-activate these links, thanks. Best regards, Christopher Postgresql Download Page: Top

Re: [ADMIN] Can't Download Postgresql-V8.2.4 for Redhat Enteprise-V4

Hi, On Tue, 2008-03-04 at 17:11 -0800, Christopher Ly wrote: > I am trying to download the postgresql version 8.2.4 for Redhat > Enteprise version 4. However, I can’t download them. 32-bit binaries: ftp://ftp-archives.postgresql.org/pub/binary/v8.2.4/linux/rpms/redhat/rhel-es-4 64-bit binaries:

[ADMIN] restarting postmaster

My system is Fedora Core 7 running postgresql 8.2.3-2. I can shutdown postgres and the postmaster with the single command "pg_ctl stop -m smart." According to the documentation I can restart the postmaster with "pg_ctl start." When I enter pg_ctl start, everything starts except the postmaster. Ch

Re: [ADMIN] restarting postmaster

"Marc Fromm" <[EMAIL PROTECTED]> writes: > My system is Fedora Core 7 running postgresql 8.2.3-2. > I can shutdown postgres and the postmaster with the single command > "pg_ctl stop -m smart." > According to the documentation I can restart the postmaster with "pg_ctl > start." When I enter pg_ctl

[ADMIN] Time Zone in Postgres

Hi, I've been working on a timezone issue. I am in Adelaide Australia and the daylight savings time this year has been changed. I am trying to figure out the file which is required to be changed. I've done the below research:1) Checked the postgresql.conf file and the timezone parameter i