Re: [GENERAL] Error in PostgreSQL Log

[Sachin Srivastava]

I have already tuned below parameters as

max_prepared_transactions = 500
max_connection = 2000



Regards,
SSR




On Sat, Apr 29, 2017 at 12:15 AM, Sachin Srivastava <ssr.teleat...@gmail.com
> wrote:

> Dear Team,
>
> Please suggest why we are getting the below error in our PostgreSQL DB log.
>
> We are using postgresql version = 9.2
>
>
> ERROR:  prepared transaction with identifier "131077_AP//
> CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA"
> does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//
> CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA'
> ERROR:  prepared transaction with identifier "131077_AP//Cqq6U+
> K0bPBZAmdRAAIpmTE=_AP//Cqq6U+K0bPBZAmdRAAIpoAAA" does
> not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//Cqq6U+
> K0bPBZAmdRAAIpmTE=_AP//Cqq6U+K0bPBZAmdRAAIpoAAA'
> ERROR:  prepared transaction with identifier "131077_AP//
> Cqq6UmqUdDpZAmc2AAJPFDE=_AP//Cqq6UmqUdDpZAmc2AAJPGgAA"
> does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//
> Cqq6UmqUdDpZAmc2AAJPFDE=_AP//Cqq6UmqUdDpZAmc2AAJPGgAA'
> ERROR:  prepared transaction with identifier "131077_AP//
> Cqq6QiDZF3BZAjkeABef2TE=_AP//Cqq6QiDZF3BZAjkeABef4QAA"
> does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//
> Cqq6QiDZF3BZAjkeABef2TE=_AP//Cqq6QiDZF3BZAjkeABef4QAA'
> ERROR:  prepared transaction with identifier "131077_AP//
> Cqq6QiDZF3BZAjkeABen1DE=_AP//Cqq6QiDZF3BZAjkeABen2AAA"
> does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//
> Cqq6QiDZF3BZAjkeABen1DE=_AP//Cqq6QiDZF3BZAjkeABen2AAA'
> ERROR:  prepared transaction with identifier "131077_AP//
> Cqq6abHV5e9ZAmJCAAN/7DE=_AP//Cqq6abHV5e9ZAmJCAAOAHwAA"
> does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//
> Cqq6abHV5e9ZAmJCAAN/7DE=_AP//Cqq6abHV5e9ZAmJCAAOAHwAA'
> ERROR:  prepared transaction with identifier "131077_AP//Cqq6U+
> K0bPBZAmdRAAJtczE=_AP//Cqq6U+K0bPBZAmdRAAJthQAA" does
> not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//Cqq6U+
> K0bPBZAmdRAAJtczE=_AP//Cqq6U+K0bPBZAmdRAAJthQAA'
> ERROR:  prepared transaction with identifier "131077_AP//
> CqqfIep65ipZAmdpAAKVDjE=_AP//CqqfIep65ipZAmdpAAKVFQAA"
> does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AP//
> CqqfIep65ipZAmdpAAKVDjE=_AP//CqqfIep65ipZAmdpAAKVFQAA'
> ERROR:  prepared transaction with identifier "131077_AP//
> CqqfIep65ipZAmdpAAK4bDE=_AP//CqqfIep65ipZAmdpAAK4cAAA"
> does not exist
> "postgresql-Fri.log" 313L, 30355C
>
> Regards,
> SSR
>
>

[GENERAL] Error in PostgreSQL Log

[Sachin Srivastava]

Dear Team,

Please suggest why we are getting the below error in our PostgreSQL DB log.

We are using postgresql version = 9.2


ERROR:  prepared transaction with identifier
"131077_AP//CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA'
ERROR:  prepared transaction with identifier
"131077_AP//Cqq6U+K0bPBZAmdRAAIpmTE=_AP//Cqq6U+K0bPBZAmdRAAIpoAAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//Cqq6U+K0bPBZAmdRAAIpmTE=_AP//Cqq6U+K0bPBZAmdRAAIpoAAA'
ERROR:  prepared transaction with identifier
"131077_AP//Cqq6UmqUdDpZAmc2AAJPFDE=_AP//Cqq6UmqUdDpZAmc2AAJPGgAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//Cqq6UmqUdDpZAmc2AAJPFDE=_AP//Cqq6UmqUdDpZAmc2AAJPGgAA'
ERROR:  prepared transaction with identifier
"131077_AP//Cqq6QiDZF3BZAjkeABef2TE=_AP//Cqq6QiDZF3BZAjkeABef4QAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//Cqq6QiDZF3BZAjkeABef2TE=_AP//Cqq6QiDZF3BZAjkeABef4QAA'
ERROR:  prepared transaction with identifier
"131077_AP//Cqq6QiDZF3BZAjkeABen1DE=_AP//Cqq6QiDZF3BZAjkeABen2AAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//Cqq6QiDZF3BZAjkeABen1DE=_AP//Cqq6QiDZF3BZAjkeABen2AAA'
ERROR:  prepared transaction with identifier
"131077_AP//Cqq6abHV5e9ZAmJCAAN/7DE=_AP//Cqq6abHV5e9ZAmJCAAOAHwAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//Cqq6abHV5e9ZAmJCAAN/7DE=_AP//Cqq6abHV5e9ZAmJCAAOAHwAA'
ERROR:  prepared transaction with identifier
"131077_AP//Cqq6U+K0bPBZAmdRAAJtczE=_AP//Cqq6U+K0bPBZAmdRAAJthQAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//Cqq6U+K0bPBZAmdRAAJtczE=_AP//Cqq6U+K0bPBZAmdRAAJthQAA'
ERROR:  prepared transaction with identifier
"131077_AP//CqqfIep65ipZAmdpAAKVDjE=_AP//CqqfIep65ipZAmdpAAKVFQAA"
does not exist
STATEMENT:  ROLLBACK PREPARED
'131077_AP//CqqfIep65ipZAmdpAAKVDjE=_AP//CqqfIep65ipZAmdpAAKVFQAA'
ERROR:  prepared transaction with identifier
"131077_AP//CqqfIep65ipZAmdpAAK4bDE=_AP//CqqfIep65ipZAmdpAAK4cAAA"
does not exist
"postgresql-Fri.log" 313L, 30355C

Regards,
SSR

Re: [GENERAL] No space left on device

[Sachin Srivastava]

Thanks Alvaro for your suggestion !!

Regards,
Sachin Srivastava
Mb.: 9811149139



On Sun, Feb 19, 2017 at 11:40 AM, Alvaro Aguayo Garcia-Rada <
aagu...@opensysperu.com> wrote:

> Cleaning pg_log should be enough to be able to start your postgres
> instance. However, it will let you with almost no space for your database
> to grow. If you have some tables with information you can delete, that can
> free up space.
>
> Unless most of your database information is "volatile"(case in which you
> should implement an automatic cleanup cron), the only remaining option is
> to get a larger disk for your vps.
>
> Regards,
>
> Alvaro Aguayo
> Jefe de Operaciones
> Open Comb Systems E.I.R.L.
>
> Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103  | RPC: (+51)
> 954183248
> Website: www.ocs.pe
>
> - Original Message -
> From: "Sachin Srivastava" <ssr.teleat...@gmail.com>
> To: "Alvaro Aguayo Garcia-Rada" <aagu...@opensysperu.com>
> Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" <
> pgsql-general@postgresql.org>
> Sent: Sunday, 19 February, 2017 1:03:09 AM
> Subject: Re: [GENERAL] No space left on device
>
>
> With correction: pg_log consumed 897 MB only
>
>
>
>
>
> Regards,
> Sachin Srivastava
> Mb.: 9811149139
>
>
>
>
>
> On Sun, Feb 19, 2017 at 11:32 AM, Sachin Srivastava <
> ssr.teleat...@gmail.com > wrote:
>
>
>
>
> I have checked pg_log only 890 GB space consumed and pg_log folder
> consumed 1.1 GB only. All the space consumed by the database file only.
>
>
>
>
>
>
> -bash-4.2$ du -h
> 0 ./pg_xlog/archive_status
> 1.1G ./pg_xlog
> 712K ./global
> 47M ./pg_clog
> 0 ./pg_commit_ts
> 0 ./pg_dynshmem
> 0 ./pg_notify
> 0 ./pg_serial
> 0 ./pg_snapshots
> 32K ./pg_subtrans
> 0 ./pg_twophase
> 296K ./pg_multixact/members
> 124K ./pg_multixact/offsets
> 420K ./pg_multixact
> 7.2M ./base/1
> 7.2M ./base/13289
> 7.2M ./base/13294
> 98G ./base/16393
> 0 ./base/pgsql_tmp
> 98G ./base
> 0 ./pg_replslot
> 0 ./pg_tblspc
> 0 ./pg_stat
> 216K ./pg_stat_tmp
> 0 ./pg_logical/snapshots
> 0 ./pg_logical/mappings
> 0 ./pg_logical
> 897M ./pg_log
> 100G .
> -bash-4.2$
>
>
>
>
>
>
> Regards,
> Sachin Srivastava
> Mb.: 9811149139
>
>
>
>
>
>
>
> On Sun, Feb 19, 2017 at 11:29 AM, Alvaro Aguayo Garcia-Rada <
> aagu...@opensysperu.com > wrote:
>
>
> Cleanup some space on that device. Maybe your "pg_log" folder has some
> space to free. If that doesn't helps, you may need to forcefully add more
> space. There's not really much alternatives there.
>
> Alvaro Aguayo
> Jefe de Operaciones
> Open Comb Systems E.I.R.L.
>
> Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51)
> 954183248
> Website: www.ocs.pe
>
>
>
> - Original Message -
> From: "Sachin Srivastava" < ssr.teleat...@gmail.com >
> To: " pgsql-general@postgresql.org >> PG-General Mailing List" <
> pgsql-general@postgresql.org >
> Sent: Sunday, 19 February, 2017 12:51:49 AM
> Subject: [GENERAL] No space left on device
>
>
>
> Dear Expert,
>
>
> My PostgreSQL database got down due to no space left on my mount point
> /dev/vdb1 where my data directory are available, please suggest what's the
> best solution to resolve this issue. I am also not able to start my
> database again due to no space available. And right now, we don't have any
> further space to add in this mount point.
>
>
>
>
> -bash-4.2$ df -h
> Filesystem Size Used Avail Use% Mounted on
> /dev/vda1 50G 11G 37G 24% /
> devtmpfs 3.9G 0 3.9G 0% /dev
> tmpfs 3.9G 0 3.9G 0% /dev/shm
> tmpfs 3.9G 57M 3.9G 2% /run
> tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
> /dev/vdb1 100G 100G 28K 100% /opt1
> tmpfs 799M 0 799M 0% /run/user/1002
>
>
>
>
>
>
> 2017-02-19 03:46:53.513 UTC [24101]: [36911-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.522 UTC [2240]: [157092-1] 
> host=192.168.60.103,user=agent2,db=pem
> ERROR: could not extend file "base/16393/112735.5": wrote only 4096 of 8192
> bytes at block 722454
> 2017-02-19 03:46:53.522 UTC [2240]: [157093-1] 
> host=192.168.60.103,user=agent2,db=pem
> HINT: Check free disk space.
> 2017-02-19 03:46:53.522 UTC [2240]: [157094-1] 
> host=192.168.60.103,user=agent2,db=pem
> CONTEXT: SQL statement "INSERT INTO pemhistory.table_frozenxid
> (recorded_time, server_id, database_name, schema_name,

Re: [GENERAL] No space left on device

[Sachin Srivastava]

With correction:  pg_log consumed 897 MB only

Regards,
Sachin Srivastava
Mb.: 9811149139



On Sun, Feb 19, 2017 at 11:32 AM, Sachin Srivastava <ssr.teleat...@gmail.com
> wrote:

> I have checked pg_log only 890 GB space consumed and pg_log folder
> consumed 1.1 GB only. All the space consumed by the database file only.
>
>
>
> -bash-4.2$ du -h
> 0   ./pg_xlog/archive_status
> 1.1G./pg_xlog
> 712K./global
> 47M ./pg_clog
> 0   ./pg_commit_ts
> 0   ./pg_dynshmem
> 0   ./pg_notify
> 0   ./pg_serial
> 0   ./pg_snapshots
> 32K ./pg_subtrans
> 0   ./pg_twophase
> 296K./pg_multixact/members
> 124K./pg_multixact/offsets
> 420K./pg_multixact
> 7.2M./base/1
> 7.2M./base/13289
> 7.2M./base/13294
> 98G ./base/16393
> 0   ./base/pgsql_tmp
> 98G ./base
> 0   ./pg_replslot
> 0   ./pg_tblspc
> 0   ./pg_stat
> 216K./pg_stat_tmp
> 0   ./pg_logical/snapshots
> 0   ./pg_logical/mappings
> 0   ./pg_logical
> 897M./pg_log
> 100G.
> -bash-4.2$
>
> Regards,
> Sachin Srivastava
> Mb.: 9811149139
>
>
>
> On Sun, Feb 19, 2017 at 11:29 AM, Alvaro Aguayo Garcia-Rada <
> aagu...@opensysperu.com> wrote:
>
>> Cleanup some space on that device. Maybe your "pg_log" folder has some
>> space to free. If that doesn't helps, you may need to forcefully add more
>> space. There's not really much alternatives there.
>>
>> Alvaro Aguayo
>> Jefe de Operaciones
>> Open Comb Systems E.I.R.L.
>>
>> Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103  | RPC: (+51)
>> 954183248
>> Website: www.ocs.pe
>>
>> - Original Message -
>> From: "Sachin Srivastava" <ssr.teleat...@gmail.com>
>> To: "pgsql-general@postgresql.org >> PG-General Mailing List" <
>> pgsql-general@postgresql.org>
>> Sent: Sunday, 19 February, 2017 12:51:49 AM
>> Subject: [GENERAL] No space left on device
>>
>>
>>
>> Dear Expert,
>>
>>
>> My PostgreSQL database got down due to no space left on my mount point
>> /dev/vdb1 where my data directory are available, please suggest what's the
>> best solution to resolve this issue. I am also not able to start my
>> database again due to no space available. And right now, we don't have any
>> further space to add in this mount point.
>>
>>
>>
>>
>> -bash-4.2$ df -h
>> Filesystem Size Used Avail Use% Mounted on
>> /dev/vda1 50G 11G 37G 24% /
>> devtmpfs 3.9G 0 3.9G 0% /dev
>> tmpfs 3.9G 0 3.9G 0% /dev/shm
>> tmpfs 3.9G 57M 3.9G 2% /run
>> tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
>> /dev/vdb1 100G 100G 28K 100% /opt1
>> tmpfs 799M 0 799M 0% /run/user/1002
>>
>>
>>
>>
>>
>>
>> 2017-02-19 03:46:53.513 UTC [24101]: [36911-1] host=,user=,db= LOG: could
>> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
>> on device
>> 2017-02-19 03:46:53.522 UTC [2240]: [157092-1]
>> host=192.168.60.103,user=agent2,db=pem ERROR: could not extend file
>> "base/16393/112735.5": wrote only 4096 of 8192 bytes at block 722454
>> 2017-02-19 03:46:53.522 UTC [2240]: [157093-1]
>> host=192.168.60.103,user=agent2,db=pem HINT: Check free disk space.
>> 2017-02-19 03:46:53.522 UTC [2240]: [157094-1]
>> host=192.168.60.103,user=agent2,db=pem CONTEXT: SQL statement "INSERT
>> INTO pemhistory.table_frozenxid (recorded_time, server_id, database_name,
>> schema_name, table_name, frozenxid) VALUES (NEW.recorded_time,
>> NEW.server_id, NEW.database_name, NEW.schema_name, NEW.table_name,
>> NEW.frozenxid)"
>> PL/pgSQL function pemdata.copy_table_frozenxid_to_history() line 4 at
>> SQL statement
>> 2017-02-19 03:46:53.522 UTC [2240]: [157095-1]
>> host=192.168.60.103,user=agent2,db=pem STATEMENT: UPDATE
>> pemdata.table_frozenxid SET "frozenxid" = '76483784', recorded_time = now()
>> WHERE "schema_name" = 't_0e2c170dc92d4d05bcf533b6e719cae4' AND
>> "table_name" = 'd20150809_x_c73db8eb0037481fa1f10371179fbf3e' AND
>> "server_id" = '4' AND "database_name" = 'cloud'
>> 2017-02-19 03:46:53.523 UTC [24101]: [36912-1] host=,user=,db= LOG: could
>> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
>> on device
>> 2017-02-19 03:46:53.523 UTC [24101]: [36913-1] host=,user=,db= LOG: could
>> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
>> on d

Re: [GENERAL] No space left on device

[Sachin Srivastava]

I have checked pg_log only 890 GB space consumed and pg_log folder consumed
1.1 GB only. All the space consumed by the database file only.



-bash-4.2$ du -h
0   ./pg_xlog/archive_status
1.1G./pg_xlog
712K./global
47M ./pg_clog
0   ./pg_commit_ts
0   ./pg_dynshmem
0   ./pg_notify
0   ./pg_serial
0   ./pg_snapshots
32K ./pg_subtrans
0   ./pg_twophase
296K./pg_multixact/members
124K./pg_multixact/offsets
420K./pg_multixact
7.2M./base/1
7.2M./base/13289
7.2M./base/13294
98G ./base/16393
0   ./base/pgsql_tmp
98G ./base
0   ./pg_replslot
0   ./pg_tblspc
0   ./pg_stat
216K./pg_stat_tmp
0   ./pg_logical/snapshots
0   ./pg_logical/mappings
0   ./pg_logical
897M./pg_log
100G.
-bash-4.2$

Regards,
Sachin Srivastava
Mb.: 9811149139



On Sun, Feb 19, 2017 at 11:29 AM, Alvaro Aguayo Garcia-Rada <
aagu...@opensysperu.com> wrote:

> Cleanup some space on that device. Maybe your "pg_log" folder has some
> space to free. If that doesn't helps, you may need to forcefully add more
> space. There's not really much alternatives there.
>
> Alvaro Aguayo
> Jefe de Operaciones
> Open Comb Systems E.I.R.L.
>
> Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103  | RPC: (+51)
> 954183248
> Website: www.ocs.pe
>
> - Original Message -
> From: "Sachin Srivastava" <ssr.teleat...@gmail.com>
> To: "pgsql-general@postgresql.org >> PG-General Mailing List" <
> pgsql-general@postgresql.org>
> Sent: Sunday, 19 February, 2017 12:51:49 AM
> Subject: [GENERAL] No space left on device
>
>
>
> Dear Expert,
>
>
> My PostgreSQL database got down due to no space left on my mount point
> /dev/vdb1 where my data directory are available, please suggest what's the
> best solution to resolve this issue. I am also not able to start my
> database again due to no space available. And right now, we don't have any
> further space to add in this mount point.
>
>
>
>
> -bash-4.2$ df -h
> Filesystem Size Used Avail Use% Mounted on
> /dev/vda1 50G 11G 37G 24% /
> devtmpfs 3.9G 0 3.9G 0% /dev
> tmpfs 3.9G 0 3.9G 0% /dev/shm
> tmpfs 3.9G 57M 3.9G 2% /run
> tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
> /dev/vdb1 100G 100G 28K 100% /opt1
> tmpfs 799M 0 799M 0% /run/user/1002
>
>
>
>
>
>
> 2017-02-19 03:46:53.513 UTC [24101]: [36911-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.522 UTC [2240]: [157092-1] 
> host=192.168.60.103,user=agent2,db=pem
> ERROR: could not extend file "base/16393/112735.5": wrote only 4096 of 8192
> bytes at block 722454
> 2017-02-19 03:46:53.522 UTC [2240]: [157093-1] 
> host=192.168.60.103,user=agent2,db=pem
> HINT: Check free disk space.
> 2017-02-19 03:46:53.522 UTC [2240]: [157094-1] 
> host=192.168.60.103,user=agent2,db=pem
> CONTEXT: SQL statement "INSERT INTO pemhistory.table_frozenxid
> (recorded_time, server_id, database_name, schema_name, table_name,
> frozenxid) VALUES (NEW.recorded_time, NEW.server_id, NEW.database_name,
> NEW.schema_name, NEW.table_name, NEW.frozenxid)"
> PL/pgSQL function pemdata.copy_table_frozenxid_to_history() line 4 at SQL
> statement
> 2017-02-19 03:46:53.522 UTC [2240]: [157095-1] 
> host=192.168.60.103,user=agent2,db=pem
> STATEMENT: UPDATE pemdata.table_frozenxid SET "frozenxid" = '76483784',
> recorded_time = now() WHERE "schema_name" = 't_
> 0e2c170dc92d4d05bcf533b6e719cae4' AND "table_name" = 'd20150809_x_
> c73db8eb0037481fa1f10371179fbf3e' AND "server_id" = '4' AND
> "database_name" = 'cloud'
> 2017-02-19 03:46:53.523 UTC [24101]: [36912-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.523 UTC [24101]: [36913-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.524 UTC [24101]: [36914-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.524 UTC [24101]: [36915-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.524 UTC [24101]: [36916-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
> on device
> 2017-02-19 03:46:53.525 UTC [24101]: [36917-1] host=,user=,db= LOG: could
> not open temporary statistics file "pg_stat_tmp/global

[GENERAL] No space left on device

[Sachin Srivastava]

Dear Expert,

My PostgreSQL database got down due to no space left on my mount point
/dev/vdb1  where my data directory are available, please suggest what's the
best solution to resolve this issue. I am also not able to start my
database again due to no space available. And right now, we don't have any
further space to add in this mount point.


-bash-4.2$ df -h
Filesystem  Size  Used Avail Use% Mounted on
/dev/vda150G   11G   37G  24% /
devtmpfs3.9G 0  3.9G   0% /dev
tmpfs   3.9G 0  3.9G   0% /dev/shm
tmpfs   3.9G   57M  3.9G   2% /run
tmpfs   3.9G 0  3.9G   0% /sys/fs/cgroup
/dev/vdb1   100G  100G   28K 100% /opt1
tmpfs   799M 0  799M   0% /run/user/1002



2017-02-19 03:46:53.513 UTC [24101]: [36911-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.522 UTC [2240]: [157092-1]
host=192.168.60.103,user=agent2,db=pem ERROR:  could not extend file
"base/16393/112735.5": wrote only 4096 of 8192 bytes at block 722454
2017-02-19 03:46:53.522 UTC [2240]: [157093-1]
host=192.168.60.103,user=agent2,db=pem HINT:  Check free disk space.
2017-02-19 03:46:53.522 UTC [2240]: [157094-1]
host=192.168.60.103,user=agent2,db=pem CONTEXT:  SQL statement "INSERT INTO
pemhistory.table_frozenxid (recorded_time, server_id, database_name,
schema_name, table_name, frozenxid) VALUES (NEW.recorded_time,
NEW.server_id, NEW.database_name, NEW.schema_name, NEW.table_name,
NEW.frozenxid)"
PL/pgSQL function pemdata.copy_table_frozenxid_to_history() line 4
at SQL statement
2017-02-19 03:46:53.522 UTC [2240]: [157095-1]
host=192.168.60.103,user=agent2,db=pem STATEMENT:  UPDATE
pemdata.table_frozenxid SET "frozenxid" = '76483784', recorded_time = now()
WHERE "schema_name" = 't_0e2c170dc92d4d05bcf533b6e719cae4' AND "table_name"
= 'd20150809_x_c73db8eb0037481fa1f10371179fbf3e' AND "server_id" = '4' AND
"database_name" = 'cloud'
2017-02-19 03:46:53.523 UTC [24101]: [36912-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.523 UTC [24101]: [36913-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.524 UTC [24101]: [36914-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.524 UTC [24101]: [36915-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.524 UTC [24101]: [36916-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.525 UTC [24101]: [36917-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.607 UTC [24101]: [36918-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.607 UTC [24101]: [36919-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.713 UTC [24101]: [36920-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.714 UTC [24101]: [36921-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.817 UTC [24101]: [36922-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.818 UTC [24101]: [36923-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.818 UTC [24101]: [36924-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.818 UTC [24101]: [36925-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.818 UTC [24101]: [36926-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.819 UTC [24101]: [36927-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.913 UTC [24101]: [36928-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.913 UTC [24101]: [36929-1] host=,user=,db= LOG:  could
not open temporary statistics file "pg_stat_tmp/global.tmp": No space left
on device
2017-02-19 03:46:53.982 UTC [24101]: [36930-1] host=,user=,db= LOG:  could
not open temporary statistics file 

[GENERAL] How SQL SELECT * statement works in Postgres?

[Sachin Srivastava]

Dear Team,

Kindly inform to me How PostgreSQL Processes SQL Statements internally?

How SQL SELECT * statement works in Postgres?



Regards,
SSR

[GENERAL] Multi Master Replication setup

[Sachin Srivastava]

Dear Concern,

Kindly inform to me how to setup multi master replication in Postgres.

Kindly provide the link of step by step setup of this or any video or setup
document regarding this.

Regards
Sachin

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

[Sachin Srivastava]

Dear Adrian,


I have initialized the database through below command through Postgres user
but in my "/u01/postgres9.4/" folder pg_log folder is not available, what
is the reason behind this.

---

-bash-4.2$ initdb -D /u01/postgres9.4/

The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
fixing permissions on existing directory /u01/postgres9.4 ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in /u01/postgres9.4/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
postgres -D /u01/postgres9.4
or
pg_ctl -D /u01/postgres9.4 -l logfile start
-bash-4.2$

-


[root@gdi-test postgres9.4]# pwd
/u01/postgres9.4
[root@gdi-test postgres9.4]# ls -ltr
total 108
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_twophase
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_tblspc
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_stat_tmp
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_stat
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_snapshots
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_serial
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_replslot
drwx-- 4 postgres postgres  4096 Jan 29 11:39 pg_multixact
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_dynshmem
-rw--- 1 postgres postgres 4 Jan 29 11:39 PG_VERSION
drwx-- 4 postgres postgres  4096 Jan 29 11:39 pg_logical
-rw--- 1 postgres postgres 21307 Jan 29 11:39 postgresql.conf
-rw--- 1 postgres postgres88 Jan 29 11:39 postgresql.auto.conf
-rw--- 1 postgres postgres  1636 Jan 29 11:39 pg_ident.conf
-rw--- 1 postgres postgres  4468 Jan 29 11:39 pg_hba.conf
drwx-- 3 postgres postgres  4096 Jan 29 11:39 pg_xlog
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_subtrans
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_clog
drwx-- 2 postgres postgres  4096 Jan 29 11:39 pg_notify
drwx-- 2 postgres postgres  4096 Jan 29 11:39 global
drwx-- 5 postgres postgres  4096 Jan 29 11:39 base
[root@gdi-test postgres9.4]#

---

Regards
SS



On Fri, Jan 29, 2016 at 11:33 AM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

> On 01/28/2016 08:45 PM, Sachin Srivastava wrote:
>
>> Hi,
>>
>> I have to install Postgres 9.4.5 On Centos 7.2, what is the best way to
>> install, please suggest:
>>
>>
>> Through ./configure and make
>>
>> OR
>>
>> Through below link:
>>
>>
>> https://wiki.postgresql.org/wiki/YUM_Installation#Configure_your_YUM_repository
>>
>>
>> Please provide, if any other installation document.
>>
>
> I would say using the Yum repo. If you do the compile from source you will
> need to make sure you have a development tool chain in place as well as
> --devel libraries for the various components.
>
>
>
>>
>> For  Postgres 9.1 version, I did postgres installation through run file
>> like  (postgresql-9.1.2-1-linux-x64.run), for 9.4 version there is no
>> run file right now.
>>
>>
>> Regards
>> SS
>>
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

[Sachin Srivastava]

Dear John,

Thanks for update !!!

Is it not possible If my storage is mounted on /u01 and I will create the
directory  within "u01/"  /postgres9.4/data. And now I want to initialize
my data within this directory ("/u01/postgres9.4/data").

There is any specific reason to use only this by default directory
"/var/lib/pgsql/9.4/data".

And if I want to keep (("/u01/postgres9.4/data) this directory then what
should be the command of initdb because command giving the error.

(-bash-4.2$ /usr/pgsql-9.4/bin/postgresql94-setup initdb -D
/u01/postgres9.4/data/


#cd

Filesystem   Size  Used Avail Use% Mounted on
/dev/mapper/centos-root  116G  664M  109G   1% /
devtmpfs 1.8G 0  1.8G   0% /dev
tmpfs1.8G 0  1.8G   0% /dev/shm
tmpfs1.8G  8.8M  1.8G   1% /run
tmpfs1.8G 0  1.8G   0% /sys/fs/cgroup
/dev/mapper/centos-usr20G  3.2G   16G  17% /usr
/dev/sda1477M  273M  175M  62% /boot
/dev/mapper/centos-var20G  907M   18G   5% /var
*/dev/mapper/centos-u01   296G  2.4G  279G   1% /u01*

cd /u01
mkdir -p /postgres9.4/data

Regards
SS


On Fri, Jan 29, 2016 at 12:34 PM, John R Pierce <pie...@hogranch.com> wrote:

> On 1/28/2016 10:24 PM, Sachin Srivastava wrote:
>
>> I have initialized the database through below command through Postgres
>> user but in my "/u01/postgres9.4/" folder pg_log folder is not available,
>> what is the reason behind this.
>>
>> ---
>>
>> -bash-4.2$ initdb -D /u01/postgres9.4/
>>
>
>
> the yum installed version defaults to putting the data directory in
> /var/lib/pgsql/9.4/data ... There's a bunch of reasons to stick with this,
> not the least thats where selinux is configured to expect it to be.
>
> I would recommend mounting a database filesystem as /var/lib/pgsql first,
> then doing the following as root...
>
> /usr/pgsql-9.4/bin/postgresql94-setup initdb
> systemctl enable postgresql-9.4.service
> systemctl start postgresql-9.4.service
>
> the server is now running, and will autostart when you reboot.
>
> see
> http://people.planetpostgresql.org/devrim/index.php?/archives/80-Installing-and-configuring-PostgreSQL-9.3-and-9.4-on-RHEL-7.html
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

[Sachin Srivastava]

Here selinux is already disabled on server and I am installing postgres on
Centos 7.2.


On Fri, Jan 29, 2016 at 1:12 PM, John R Pierce <pie...@hogranch.com> wrote:

> On 1/28/2016 11:21 PM, Sachin Srivastava wrote:
>
>>
>> Is it not possible If my storage is mounted on /u01 and I will create the
>> directory  within "u01/"  /postgres9.4/data. And now I want to initialize
>> my data within this directory ("/u01/postgres9.4/data").
>>
>> There is any specific reason to use only this by default directory
>> "/var/lib/pgsql/9.4/data".
>>
>
> you will need to mess with selinux tags to get it to cooperate.
>
>
>> And if I want to keep (("/u01/postgres9.4/data) this directory then what
>> should be the command of initdb because command giving the error.
>>
>
> create file /etc/sysconfig/pgsql/postgresql-9.4 and add the line
> PGDATA=/u01/postgres9.4/data then run the postgreql94-setup initdb, it
> will pick up this setting and use it, as will the systemd service scripts.
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

[GENERAL] Postgres 9.4.5 Installation on Centos 7.3

[Sachin Srivastava]

Hi,

I have to install Postgres 9.4.5 On Centos 7.2, what is the best way to
install, please suggest:


Through ./configure and make

OR

Through below link:

https://wiki.postgresql.org/wiki/YUM_Installation#Configure_your_YUM_repository


Please provide, if any other installation document.


For  Postgres 9.1 version, I did postgres installation through run file
like  (postgresql-9.1.2-1-linux-x64.run), for 9.4 version there is no run
file right now.


Regards
SS

Re: [GENERAL] Variable not found

[Sachin Srivastava]

Dear Adrian,

So, how the effective way to search this because I have around 1300 tables.

Regards,
SS

On Thu, Jan 21, 2016 at 8:48 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

> On 01/20/2016 07:35 PM, Sachin Srivastava wrote:
>
>> Dear Folks,
>>
>> I have a question about global variables in Oracle pl/sql package. Where
>> are these variables when package is converted to schema from Oracle to
>> Postgres through Ora2PG Tool?
>>
>>
>> For example, package > g_compliance_id. This package is converted to schema
>> ssj4_compliance_pkg, but I cannot find where is the variable
>> g_compliance_id. It must be somewhere because there is no error in
>> functions which reference this variable. Please suggest where I will
>> fount it, any idea?
>>
>
> Best guess it is stored in a table in the schema.
>
>
>>
>> Regards,
>>
>> SS
>>
>>
>>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

[GENERAL] Variable not found

[Sachin Srivastava]

Dear Folks,

I have a question about global variables in Oracle pl/sql package. Where
are these variables when package is converted to schema from Oracle to
Postgres through Ora2PG Tool?


For example, package 

Re: [GENERAL] Syntax error for Function

[Sachin Srivastava]

Dear Adiran,

Thanks for your help !!

First I want to say it's not giving the error for this ""
languaget...@repos.birchstreet.net", so there is any need to do the change
as suggested by you.

Second you suggested " exit with cur1; " - *You are right after putting the
semi column my code is working fine.*

There is also one query I have changed this line"*langCursor cur1%rowtype;"
as below:*

langCursor RECORD; --cur1%rowtype;

Please read my code once again and suggest I did correct these change or
not because this is suggested by one of my friend and first I am getting
the error for this line.

I am the new one for plsql code that's why I am taking the expert advice.


Thanks
SS

On Wed, Jan 20, 2016 at 8:30 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

> On 01/20/2016 06:32 AM, Sachin Srivastava wrote:
>
>> Dear Thom,
>>
>> Please find the complete code as below and suggest now.
>>
>
> I would suggest spending some time here:
>
> http://www.postgresql.org/docs/9.4/interactive/plpgsql.html
>
> in particular:
>
>
> http://www.postgresql.org/docs/9.4/interactive/plpgsql-control-structures.html#PLPGSQL-CONTROL-STRUCTURES-LOOPS
>
> and here:
>
> http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html
>
> Comments in-line
>
>
>> --
>>
>> -- Function: gen_budget_for_next_year(bigint, bigint, bigint)
>> -- DROP FUNCTION gen_budget_for_next_year(bigint, bigint, bigint);
>> CREATE OR REPLACE FUNCTION gen_budget_for_next_year(
>>  subid bigint,
>>  compid bigint,
>>  formonth bigint)
>>RETURNS void AS
>> $BODY$
>> DECLARE
>> --Version:
>> --2015.01 PM T15422-10- Generate budget period for coming years.
>> 05/01/2015
>> cur1 CURSOR FOR SELECT distinct(language_id) from
>> "languaget...@repos.birchstreet.net
>>
>
> Have you tried the above. I know quoting it got you pass the syntax error,
> but I am pretty sure it not going to do what it did in Oracle.
>
> <mailto:languaget...@repos.birchstreet.net>";
>> sFound bigint := 0;
>> recCount bigint :=0;
>> period varchar(100);
>> firstDate varchar(100);
>> lastDate varchar(100);
>> curMonth varchar(100);
>> langCursor RECORD; --cur1%rowtype;
>>
>> BEGIN
>>loop
>>open cur1;
>>IF NOT FOUND THEN EXIT; END IF; -- apply on recCount >= forMonth;
>>  select to_char(TO_DATE(LOCALTIMESTAMP) + recCount*'1
>> month'::interval,'MM') into period  ;
>>  select to_date(period||'01','MMDD') into firstDate  ;
>>  select TO_DATE(LOCALTIMESTAMP) + recCount*'1 month'::interval
>> into lastDate  ;
>>  select to_char(TO_DATE(LOCALTIMESTAMP) + recCount*'1
>> month'::interval, ' MM MONTH') into curMonth ;
>>  recCount :=recCount+1;
>>loop
>>fetch cur1 into langCursor;
>>exit when cur1
>>
>
> From loop link above, this needs to be
>
> exit when cur1;
>
>  select Count(0) into sFound  from budget_period t where
>> t.subscriber_id =subID
>>  and t.period_number = period and
>> t.language_id=langCursor.Language_Id;
>>  if(sFound = 0)then
>>  insert into budget_period (subscriber_id, company_id,
>> period_number, period_name,
>>  period_length_code, first_day, last_day,creation_date,
>> creation_user, update_date, update_user, language_id)
>>  values(subID, compID, period,  curMonth,  'MONTH',
>>  firstDate, lastDate, LOCALTIMESTAMP,
>> 'Admin',LOCALTIMESTAMP, 'Admin', langCursor.Language_Id);
>>  end if;
>>end loop;
>>close cur1;
>>end loop;
>>
>> commit;
>> END;
>> $BODY$
>>LANGUAGE plpgsql VOLATILE SECURITY DEFINER
>>COST 100;
>> ALTER FUNCTION gen_budget_for_next_year(bigint, bigint, bigint)
>>OWNER TO postgres;
>>
>> 
>>
>> On Wed, Jan 20, 2016 at 6:05 PM, Thom Brown <t...@linux.com
>> <mailto:t...@linux.com>> wrote:
>>
>> On 20 January 2016 at 12:15, Sachin Srivastava
>> <ssr.teleat...@gmail.com <mailto:ssr.teleat...@gmail.com>> wrote:
>>  > I am unable to find out the syntax error in below code, please
>> suggest?
>>  >
>>  >
>>  >
>>  > ERROR:  syntax error at or near "select"
>>  > LINE 44: select Count(0) into sFound  from
>> budget_per

[GENERAL] Error in Update and Set statement

[Sachin Srivastava]

Dear Folks,

How to handle the below error, please suggest. I have migrated my database
from oracle to postgres through Ora2PG then I am getting this error for
function.

If I am writing the code for every column which are within set (column
name1, column name2, etc) then it's running successfully but if there are
so many columns with set then how can I handle this because in below code
there are 7 column with set statement and we have to write very big code
for this. Please suggest how to handle this situation.



ERROR:  syntax error at or near "SELECT"
LINE 2: ...LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY) =(SELECT LIN...
 ^
** Error **


ERROR: syntax error at or near "SELECT"
SQL state: 42601
Character: 123

Code as below:

---

update ppo_master_detail set (LINE_STATUS,LINE_TYPE,PROMISE_DATE,
  LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY) =(SELECT LINE_STATUS,
  LINE_TYPE,PROMISE_DATE,LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY
  from ppo_master_detail where subscriber_id = 65 and
row_number=supplierdetail.row_number
  and po_number=supplierdetail.po_number and
company_id=supplierdetail.company_id )
  where po_number =PONum.po_number and company_id=PONum.company_id and
subscriber_id = 65 and row_number=supplierdetail.row_number;
  --iRowCounter:=iRowCounter+1;

Re: [GENERAL] Error in Update and Set statement

[Sachin Srivastava]

Boss !!

I am using postgres 9.4, so how to handle this.

On Wed, Jan 20, 2016 at 4:11 PM, Pavel Stehule <pavel.steh...@gmail.com>
wrote:

> Hi
>
> 2016-01-20 11:36 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>
>> Dear Folks,
>>
>> How to handle the below error, please suggest. I have migrated my
>> database from oracle to postgres through Ora2PG then I am getting this
>> error for function.
>>
>> If I am writing the code for every column which are within set (column
>> name1, column name2, etc) then it's running successfully but if there are
>> so many columns with set then how can I handle this because in below code
>> there are 7 column with set statement and we have to write very big code
>> for this. Please suggest how to handle this situation.
>>
>>
>>
>> ERROR:  syntax error at or near "SELECT"
>> LINE 2: ...LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY) =(SELECT LIN...
>>  ^
>> ** Error **
>>
>>
>> ERROR: syntax error at or near "SELECT"
>> SQL state: 42601
>> Character: 123
>>
>> Code as below:
>>
>> ---
>>
>> update ppo_master_detail set (LINE_STATUS,LINE_TYPE,PROMISE_DATE,
>>   LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY) =(SELECT
>> LINE_STATUS,
>>
>> LINE_TYPE,PROMISE_DATE,LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY
>>   from ppo_master_detail where subscriber_id = 65 and
>> row_number=supplierdetail.row_number
>>   and po_number=supplierdetail.po_number and
>> company_id=supplierdetail.company_id )
>>   where po_number =PONum.po_number and company_id=PONum.company_id
>> and subscriber_id = 65 and row_number=supplierdetail.row_number;
>>   --iRowCounter:=iRowCounter+1;
>>
>>
> This Oracle's syntax is supported from 9.5.
>
> Regards
>
> Pavel
>
>
>> 
>>
>
>

[GENERAL] ERROR for '@' for function

[Sachin Srivastava]

How to handle this below situation, I am getting error for function, my
Postgres version is 9.4
 is

ERROR:  syntax error at or near "@"
LINE 67:   autonumbersett...@repos.birchstreet.net
^
** Error **
ERROR: syntax error at or near "@"
SQL state: 42601
Character: 3274




BEGIN
  select NEXT_NUMBER into STRICT  id from
  autonumbersett...@repos.birchstreet.net
  --pbeach_repos8.AUTONUMBERSETTING
  where subscriber_id=subscriber and AUTO_NUMBER_ID=348 and company_id=
buyer;
   exception
  when no_data_found then
   insert into
smerror_log(error_log_id,subscriber_id,company_id,error_message,system_message,
   method_name,creation_date,creation_user,update_date,update_user)
 values (nextval('smerror_log_sequence'),subscriber,buyer,'Auto Number
not found',null,
   'PunchoutProfile'  ,LOCALTIMESTAMP,'Admin',LOCALTIMESTAMP,'Admin');
   commit;
  return;
  end;

---

[GENERAL] Syntax error for Function

[Sachin Srivastava]

I am unable to find out the syntax error in below code, please suggest?



ERROR:  syntax error at or near "select"
LINE 44: select Count(0) into sFound  from budget_period ...
 ^
** Error **
ERROR: syntax error at or near "select"
SQL state: 42601
Character: 1190

Code as below:
-

select Count(0) into sFound  from budget_period t where t.subscriber_id
=subID
and t.period_number = period and
t.language_id=langCursor.Language_Id;
if(sFound = 0)then
insert into budget_period (subscriber_id, company_id,
period_number, period_name,
period_length_code, first_day, last_day,creation_date,
creation_user, update_date, update_user, language_id)
values(subID, compID, period,  curMonth,  'MONTH',
firstDate, lastDate, LOCALTIMESTAMP,
'Admin',LOCALTIMESTAMP, 'Admin', langCursor.Language_Id);
end if;

Re: [GENERAL] ERROR for '@' for function

[Sachin Srivastava]

Thanks Thomas !!!

Now, it's working fine.

On Wed, Jan 20, 2016 at 5:18 PM, Thomas Kellerer <spam_ea...@gmx.net> wrote:

> Sachin Srivastava schrieb am 20.01.2016 um 12:42:
> > How to handle this below situation, I am getting error for function, my
> Postgres version is 9.4
> >  is
> >
> > ERROR:  syntax error at or near "@"
> > LINE 67:   autonumbersett...@repos.birchstreet.net  autonumbersett...@repos.birchstreet.net>
> > ^
> > ** Error **
> > ERROR: syntax error at or near "@"
> > SQL state: 42601
> > Character: 3274
> >
>
> Well, autonumbersett...@repos.birchstreet.net is an invalid identifier.
> A "@" is not allowed as part of a table name.
>
> You need to enclose that in double quotes:
>
> SELECT ...
> FROM "autonumbersett...@repos.birchstreet.net"
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Syntax error for Function

[Sachin Srivastava]

Dear Thom,

Please find the complete code as below and suggest now.

--

-- Function: gen_budget_for_next_year(bigint, bigint, bigint)
-- DROP FUNCTION gen_budget_for_next_year(bigint, bigint, bigint);
CREATE OR REPLACE FUNCTION gen_budget_for_next_year(
subid bigint,
compid bigint,
formonth bigint)
  RETURNS void AS
$BODY$
DECLARE
--Version:
--2015.01 PM T15422-10- Generate budget period for coming years. 05/01/2015
cur1 CURSOR FOR SELECT distinct(language_id) from "
languaget...@repos.birchstreet.net";
sFound bigint := 0;
recCount bigint :=0;
period varchar(100);
firstDate varchar(100);
lastDate varchar(100);
curMonth varchar(100);
langCursor RECORD; --cur1%rowtype;

BEGIN
  loop
  open cur1;
  IF NOT FOUND THEN EXIT; END IF; -- apply on recCount >= forMonth;

select to_char(TO_DATE(LOCALTIMESTAMP) + recCount*'1
month'::interval,'MM') into period  ;
select to_date(period||'01','MMDD') into firstDate  ;
select TO_DATE(LOCALTIMESTAMP) + recCount*'1 month'::interval into
lastDate  ;
select to_char(TO_DATE(LOCALTIMESTAMP) + recCount*'1
month'::interval, ' MM MONTH') into curMonth ;
recCount :=recCount+1;
  loop
  fetch cur1 into langCursor;
  exit when cur1
select Count(0) into sFound  from budget_period t where
t.subscriber_id =subID
and t.period_number = period and
t.language_id=langCursor.Language_Id;
if(sFound = 0)then
insert into budget_period (subscriber_id, company_id,
period_number, period_name,
period_length_code, first_day, last_day,creation_date,
creation_user, update_date, update_user, language_id)
values(subID, compID, period,  curMonth,  'MONTH',
firstDate, lastDate, LOCALTIMESTAMP,
'Admin',LOCALTIMESTAMP, 'Admin', langCursor.Language_Id);
end if;
  end loop;
  close cur1;
  end loop;

commit;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER
  COST 100;
ALTER FUNCTION gen_budget_for_next_year(bigint, bigint, bigint)
  OWNER TO postgres;



On Wed, Jan 20, 2016 at 6:05 PM, Thom Brown <t...@linux.com> wrote:

> On 20 January 2016 at 12:15, Sachin Srivastava <ssr.teleat...@gmail.com>
> wrote:
> > I am unable to find out the syntax error in below code, please suggest?
> >
> >
> >
> > ERROR:  syntax error at or near "select"
> > LINE 44: select Count(0) into sFound  from budget_period ...
> >  ^
> > ** Error **
> > ERROR: syntax error at or near "select"
> > SQL state: 42601
> > Character: 1190
> >
> > Code as below:
> > -
> >
> > select Count(0) into sFound  from budget_period t where t.subscriber_id
> > =subID
> > and t.period_number = period and
> > t.language_id=langCursor.Language_Id;
> > if(sFound = 0)then
> > insert into budget_period (subscriber_id, company_id,
> > period_number, period_name,
> > period_length_code, first_day, last_day,creation_date,
> > creation_user, update_date, update_user, language_id)
> > values(subID, compID, period,  curMonth,  'MONTH',
> > firstDate, lastDate, LOCALTIMESTAMP,
> 'Admin',LOCALTIMESTAMP,
> > 'Admin', langCursor.Language_Id);
> > end if;
> >
> > 
>
> Well, it says that the problem occurs on line 44, so what's on the
> previous lines it's receiving?  Are you sending an unterminated query
> prior to that?
>
> Thom
>

[GENERAL] Function error

[Sachin Srivastava]

Dear Team,

I am getting the below error for function, please see the bold line in
"Function code", please suggest what I will do to correct this code.

 ---

ERROR:  syntax error at or near "*"
LINE 35: SELECT * from logError(msg text) is
^
CONTEXT:  invalid type name "* from logError(msg text) is

BEGIN
insert into SMERROR_LOG
(error_message,  error_log_id, method_name, subscriber_id, company_id,
creation_date, creation_user, update_date, update_user)
   values(msg,  nextval('smerror_log_sequence'),
'Gen_Budget_Periods_ALL_ForYear',subscriberID, companyID, LOCALTIMESTAMP,
'Admin', LOCALTIMESTAMP, 'Admin')"
** Error **

ERROR: syntax error at or near "*"
SQL state: 42601
Character: 1276
Context: invalid type name "* from logError(msg text) is

BEGIN
insert into SMERROR_LOG
(error_message,  error_log_id, method_name, subscriber_id, company_id,
creation_date, creation_user, update_date, update_user)
   values(msg,  nextval('smerror_log_sequence'),
'Gen_Budget_Periods_ALL_ForYear',subscriberID, companyID, LOCALTIMESTAMP,
'Admin', LOCALTIMESTAMP, 'Admin')"

--


*Function Code as below:*


--


-- Function: cp_property_room_count_trans(bigint, bigint, text)

-- DROP FUNCTION cp_property_room_count_trans(bigint, bigint, text);

CREATE OR REPLACE FUNCTION cp_property_room_count_trans(
subscriberid bigint,
incompanyid bigint,
loginname text)
  RETURNS void AS
$BODY$
DECLARE


  CRS_1 CURSOR FOR SELECT distinct company_id from CP_ROOM_COUNT_STAGING
where subscriber_id=subscriberID and (process_flag is null or
process_flag=0)  order by company_id;

  --Version:
  -- 05/16/07 (Bea) transformed data from CP_ROOM_COUNT_STAGING
  --   into CP_ROOM_TYPE_COUNT and CP_PROPERTY_PHASE tables
  -- 06/08/07 (Bea) insert value for CP_ROOM_TYPE_COUNT.room_budget_home_amt
  --  If phaseID is new, validate that these as required fields
:CORP_PHASE_ID, PHASE_DESCRIPTION or PHASE_START_DATE
  --   Will set process_flag=2 if fail the validation.
  --  CP_PROPERTY_PHASE.PHASE_1_CODE field must be populated per
business rule 15327
  --

  RW_1 RECORD; --CRS_1 %ROWTYPE;
  err_msg_1 varchar(100);
  v_errorMessage_1 varchar(4000);
  sucessfulRecCount bigint :=0;
  failedRecCount bigint :=0;








*  --  SELECT
logError(v_errorMesg text, procedureName text, subscriberID bigint,
companyID bigint, supplierSku text, loginName text) is  BEGIN insert
into SMERROR_LOG (error_message, method_name, system_message,
error_log_id, subscriber_id, company_id, creation_date, creation_user,
update_date, update_user)  values(v_errorMesg, procedureName,
supplierSku, nextval('smerror_log_sequence'), subscriberID, companyID,
LOCALTIMESTAMP, loginName, LOCALTIMESTAMP, 'V7Admin');end;*

*  --*

  FUNCTION Invoke_InsertPropertyRCProcess(subID in number, compID in
number, loginName in varchar2) is

  CRS CURSOR FOR
 SELECT st.*, st.rowid, ph.project_code from
CP_ROOM_COUNT_STAGING st, CP_PROJECT_PHASE ph
 where st.SUBSCRIBER_ID =subID and st.company_id=compID and
(st.process_flag is null or st.process_flag=0)
 and ph.SUBSCRIBER_ID(+)= st.SUBSCRIBER_ID AND ph.PHASE_ID(+)=
st.CORP_PHASE_ID order by st.subscriber_id, st.company_id, st.phase_id;

 RW CRS%ROWTYPE;
 err_msg varchar2(100);
 v_errorMessage varchar2(4000);
 v_errorCountExp number :=0;
 MAX_ERR_WRITTEN constant number :=10;
 recCount number := 0;

 checkCount number;
 startRowCounter number :=0;
 isValidated boolean :=true;


 begin
   logError('Begin Invoke_InsertPropertyRCProcess subID:'|| subID || '
and compID:'||compID,'Invoke_InsertPropertyRCProcess', subID, compID,null,
loginName);

   -- the row_number counter starting number
   select max(Row_number) into startRowCounter from CP_ROOM_TYPE_COUNT
   where subscriber_id=subID and company_id=compID;

   if(startRowCounter is null) then
   startRowCounter :=0;
   end if;

   open CRS;
   loop
  begin -- the begin inside the loop
 fetch CRS into RW;
 IF NOT FOUND THEN EXIT; END IF; -- apply on CRS
   recCount := recCount+1;
   startRowCounter := startRowCounter+1;

   --check to if phase_id already existed in CP_PROPERTY_PHASE
if not insert
   select  count(1)  into checkCount from CP_PROPERTY_PHASE
   where subscriber_id=subID and company_id=compID and
PHASE_ID=RW.PHASE_ID;

   isValidated := true;
--check to see if pass validation.
   if(checkCount =0 and (RW.phase_start_date is null or

Re: [GENERAL] Function error

[Sachin Srivastava]

Dear Albe,

Thanks for your support !!!

In my function the problem is that global variables defined inside the
function. These variables are visible to functions defined inside a
function. If we move these inner functions to outside of the main function,
they will lose the visibility of the global variables. So I think that's
why we have to correct this functions rather then creating it as
individual.

We have migrated our data from Oracle to Postgres through ORA2PG Tool after
that we are getting this error for this function.

Dear Adrian,

I have also used the PERFORM option but still it's not running.

Regards,
Sachin



On Thu, Jan 14, 2016 at 12:37 AM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

> On 01/13/2016 01:18 AM, Sachin Srivastava wrote:
> >
> > Dear Team,
> >
> > I am getting the below error for function, please see the bold line in
> > "Function code", please suggest what I will do to correct this code.
> >
> >   ---
> >
> > ERROR:  syntax error at or near "*"
> > LINE 35: SELECT * from logError(msg text) is
> >  ^
> > CONTEXT:  invalid type name "* from logError(msg text) is
> >
>
> >
> > *_Function Code as below:_*
> >
> >
> >
> --
> >
> >
> > -- Function: cp_property_room_count_trans(bigint, bigint, text)
> >
> > -- DROP FUNCTION cp_property_room_count_trans(bigint, bigint, text);
> >
> > CREATE OR REPLACE FUNCTION cp_property_room_count_trans(
> >  subscriberid bigint,
> >  incompanyid bigint,
> >  loginname text)
> >RETURNS void AS
> > $BODY$
> > DECLARE
> >
> >
> >CRS_1 CURSOR FOR SELECT distinct company_id from
> > CP_ROOM_COUNT_STAGING where subscriber_id=subscriberID and (process_flag
> > is null or process_flag=0)  order by company_id;
> >
> >--Version:
> >-- 05/16/07 (Bea) transformed data from CP_ROOM_COUNT_STAGING
> >--   into CP_ROOM_TYPE_COUNT and CP_PROPERTY_PHASE tables
> >-- 06/08/07 (Bea) insert value for
> > CP_ROOM_TYPE_COUNT.room_budget_home_amt
> >--  If phaseID is new, validate that these as required
> > fields  :CORP_PHASE_ID, PHASE_DESCRIPTION or PHASE_START_DATE
> >--   Will set process_flag=2 if fail the validation.
> >--  CP_PROPERTY_PHASE.PHASE_1_CODE field must be populated
> > per business rule 15327
> >--
> >
> >RW_1 RECORD; --CRS_1 %ROWTYPE;
> >err_msg_1 varchar(100);
> >v_errorMessage_1 varchar(4000);
> >sucessfulRecCount bigint :=0;
> >failedRecCount bigint :=0;
> >
> > *  --
> >SELECT logError(v_errorMesg text, procedureName text, subscriberID
> > bigint, companyID bigint, supplierSku text, loginName text) is
>
> I have not even tried to go through all of this function, but the above is
> a problem in and of itself.
>
> If you want to do something that returns no result then you need to use
> PERFORM:
>
>
> http://www.postgresql.org/docs/9.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-NORESULT
>
> That stills the question of what ..'loginName text) is' is supposed to be
> doing?
>
> If you are trying to SELECT the result of logError into a  variable then
> you need to use INTO:
>
>
> http://www.postgresql.org/docs/9.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW
>
> If you are trying to do something else, then as Albe said, you need to let
> us know what that is?
>
>
> >
> > BEGIN
> >   insert into SMERROR_LOG
> >   (error_message, method_name, system_message, error_log_id,
> > subscriber_id, company_id, creation_date, creation_user, update_date,
> > update_user)
> >   values(v_errorMesg, procedureName, supplierSku,
> > nextval('smerror_log_sequence'), subscriberID, companyID,
> > LOCALTIMESTAMP, loginName, LOCALTIMESTAMP, 'V7Admin');
> >end;*
>
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

[GENERAL] Giving error for function

[Sachin Srivastava]

Hi,

I am getting the below error while I am running the below function
"add_po_doc_hist", for "c_company" cursor, please suggest what is wrong
with code.



ERROR:  relation "c_company" does not exist

CONTEXT:  compilation of PL/pgSQL function "add_po_doc_hist" near line 11

** Error **



ERROR: relation "c_company" does not exist

SQL state: 42P01

Context: compilation of PL/pgSQL function "add_po_doc_hist" near line 11





 
-

-- Function: add_po_doc_hist(bigint)



-- DROP FUNCTION add_po_doc_hist(bigint);



CREATE OR REPLACE FUNCTION add_po_doc_hist(subscriberid bigint)

  RETURNS void AS

$BODY$

DECLARE



--Select All Companies for the subscriber entered

c_company CURSOR FOR

SELECT company_id

from PSM_COMPANY_PROFILE

where is_BUYER = 1

  and subscriber_id=subscriberID;



v_company c_company%ROWTYPE;

counter bigint :=1;



BEGIN



open c_company;

loop

fetch c_company into v_company;

IF NOT FOUND THEN EXIT; END IF; -- apply on
c_company



--insert in PDOC_CHANGE_HIST_HEADER

insert into PDOC_CHANGE_HIST_HEADER

(SUBSCRIBER_ID, COMPANY_ID,
DOCUMENT_ID,

  DESCRIPTION, COMMENTS,

  CREATION_DATE, CREATION_USER, UPDATE_DATE, UPDATE_USER )

values(subscriberID, v_company.company_id,
15197,

'Buyer PO History', '',

LOCALTIMESTAMP, 'AppAdmin', LOCALTIMESTAMP, 'AppAdmin' );



--First Row insert in
PDOC_CHANGE_HIST_DETAIL

insert into PDOC_CHANGE_HIST_DETAIL

(SUBSCRIBER_ID, COMPANY_ID,
DOCUMENT_ID, ROW_NUMBER,

  TABLE_NAME, TABLE_COLUMN_NAME, FIELD_ID,

  CREATION_DATE, CREATION_USER, UPDATE_DATE, UPDATE_USER )

values(subscriberID, v_company.company_id,
15197, 1,

'PPO_MASTER_HEADER', 'SUPPLIER_CONTACT_ID', 15385,

LOCALTIMESTAMP, 'AppAdmin', LOCALTIMESTAMP, 'AppAdmin' );



--Second Row insert in PDOC_CHANGE_HIST_DETAIL

insert into PDOC_CHANGE_HIST_DETAIL

(SUBSCRIBER_ID, COMPANY_ID,
DOCUMENT_ID, ROW_NUMBER,

  TABLE_NAME, TABLE_COLUMN_NAME, FIELD_ID,

  CREATION_DATE, CREATION_USER, UPDATE_DATE, UPDATE_USER )

values(subscriberID, v_company.company_id,
15197, 2,

'PPO_MASTER_HEADER', 'STATUS', 15192,

LOCALTIMESTAMP, 'AppAdmin', LOCALTIMESTAMP, 'AppAdmin' );



   --Third Row insert in PDOC_CHANGE_HIST_DETAIL

insert into PDOC_CHANGE_HIST_DETAIL

(SUBSCRIBER_ID, COMPANY_ID,
DOCUMENT_ID, ROW_NUMBER,

  TABLE_NAME, TABLE_COLUMN_NAME, FIELD_ID,

  CREATION_DATE, CREATION_USER, UPDATE_DATE, UPDATE_USER )

values(subscriberID, v_company.company_id,
15197, 3,

'PPO_MASTER_HEADER', 'APPROVAL_PERSON_ID', 20883,

LOCALTIMESTAMP, 'AppAdmin', LOCALTIMESTAMP, 'AppAdmin' );



counter := counter +1;

/*if it is more than 1000 record then
commit and reset the counter value*/

if( counter = 1000) then

commit;

counter :=1;

end if;

end loop;

commit;

close c_company;



END;

$BODY$

  LANGUAGE plpgsql VOLATILE SECURITY DEFINER

  COST 100;

ALTER FUNCTION add_po_doc_hist(bigint)

  OWNER TO postgres;



--


Regards,

Sachin

Re: [GENERAL] Function error

[Sachin Srivastava]

Hi,

I am also getting "syntax error for below function (just some lines of
function where I am getting syntax error), please suggest why?


  -- Image path
AND mk1.subscriber_id(+)=pcat_catalog_item.subscriber_id
AND cs1.subscriber_id(+)=pcat_catalog_item.subscriber_id
AND cs1.company_id(+)=pcat_catalog_item.company_id
AND
pcat_catalog_dup_detail.dest_subscriber_id(+)=pcat_item_categorization.subscriber_id
AND
pcat_catalog_dup_detail.dest_supplier_company_id(+)=pcat_item_categorization.item_company_id
AND
pcat_catalog_dup_detail.dest_catalog_code(+)=pcat_item_categorization.catalog_code
AND mk2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
AND cs2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
AND cs2.company_id(+)=pcat_catalog_dup_detail.company_id;

--


ERROR:  syntax error at or near ")"
LINE 216: AND mk1.subscriber_id(+)=pcat_catalog_item.subscribe...
 ^
** Error **
ERROR: syntax error at or near ")"
SQL state: 42601
Character: 10018

Regards
SS

Re: [GENERAL] Function error

[Sachin Srivastava]

Hi,

Also there is any command to see the invalid and valid function in postgres
database.

Regards,
SS

On Fri, Jan 8, 2016 at 1:18 PM, Sachin Srivastava <ssr.teleat...@gmail.com>
wrote:

> Thanks Charles !!!
>
> On Fri, Jan 8, 2016 at 1:15 PM, Sachin Srivastava <ssr.teleat...@gmail.com
> > wrote:
>
>> Thanks Pavel !!!
>>
>> On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule <pavel.steh...@gmail.com>
>> wrote:
>>
>>> Hi
>>>
>>>
>>>
>>> 2016-01-08 8:24 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>>>
>>>> Dear Concern,
>>>>
>>>>
>>>>
>>>> I am creating below function *“create_catexp_ss_master()” *and getting
>>>> error as below, I have already created dependent function firstly
>>>> successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but
>>>> still getting error, please suggest why?
>>>>
>>>>
>>>>
>>>> ERROR:  syntax error at or near "create_catexp_ss_1"
>>>>
>>>> LINE 38:  create_catexp_ss_1;
>>>>
>>>>   ^
>>>>
>>>> ** Error **
>>>>
>>>>
>>>>
>>>> ERROR: syntax error at or near "create_catexp_ss_1"
>>>>
>>>> SQL state: 42601
>>>>
>>>> Character: 1104
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> -- Function: create_catexp_ss_master()
>>>>
>>>>
>>>>
>>>> -- DROP FUNCTION create_catexp_ss_master();
>>>>
>>>>
>>>>
>>>> CREATE OR REPLACE FUNCTION create_catexp_ss_master()
>>>>
>>>>   RETURNS void AS
>>>>
>>>> $BODY$
>>>>
>>>> DECLARE
>>>>
>>>>
>>>>
>>>> -- Build snapshot tables for catalog itme exposure.
>>>>
>>>>
>>>>
>>>> -- Versions:
>>>>
>>>> -- 2013.1 hxu T11464 - Two Table Catalog Snap Shot Process. 02/27/13
>>>>
>>>> -- 2013.02 hxu T11899 - Remove the Single Supplier check box from
>>>> Screen and from the Code. 05/23/13
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> v_count_before bigint;
>>>>
>>>> v_count_after bigint;
>>>>
>>>> v_start_time timestamp;
>>>>
>>>> v_err_msg varchar(1000);
>>>>
>>>> v_set_name varchar(10);
>>>>
>>>>
>>>>
>>>>
>>>> BEGIN
>>>>
>>>> v_set_name:=ssj4_snapshot_pkg.get_inactive_ss_set_name;
>>>>
>>>> SELECT LOCALTIMESTAMP INTO v_start_time ;
>>>>
>>>>
>>>>
>>>> if v_set_name='A' then
>>>>
>>>> SELECT count(1) INTO v_count_before
>>>> FROM pcat_exp_supp_buyer_ss_a;
>>>>
>>>> else
>>>>
>>>> SELECT count(1) INTO v_count_before
>>>> FROM pcat_exp_supp_buyer_ss_b;
>>>>
>>>> end if;
>>>>
>>>>
>>>>
>>>> -- Remove old data.
>>>>
>>>> EXECUTE 'truncate table
>>>> pcat_exp_supp_buyer_ss_'||v_set_name;
>>>>
>>>> EXECUTE 'truncate table
>>>> pcat_exp_supp_cat_buyer_ss_'||v_set_name;
>>>>
>>>
>>> Attention - this is potentially serious security bug
>>>
>>> EXECUTE 'TRUNCATE TABLE ' || quote_ident(pcat_exp_supp_cat_buyer_ss_ ||
>>> v_set_name);
>>>
>>>
>>>>
>>>>
>>>> -- Exposure for single supplier without category
>>>> filtering
>>>>
>>>> create_catexp_ss_1;
>>>>
>>>
>>> you have to call this function via PERFORM statement
>>>
>>>PERFORM create_catexp_ss_1();
>>>
>>>
>>>>
>>>>
>>>> -- Exposure for single supplier with category filtering
>>>>
>>>>
>>>> create_catexp_ss_2;
>>>>
>>>>
>>>>
>>>> if v_set_name='A' then
>>>>
>>>> SELECT count(1) INTO v_count_after
>>>> FROM pcat_exp_supp_buyer_ss_a;
>>>>
>>>> else
>>>>
>>>> SELECT count(1) INTO v_count_after
>>>> FROM pcat_exp_supp_buyer_ss_b;
>>>>
>>>> end if;
>>>>
>>>>
>>>>
>>>> -- Log
>>>>
>>>> create_ss_log('Catalog Exposure', v_start_time,
>>>> 'pcat_exp_supp_buyer_ss_'||v_set_name,
>>>>
>>>> v_count_before, v_count_after, null);
>>>>
>>>>
>>>>
>>>> exception-- log error
>>>>
>>>> when others then
>>>>
>>>> v_err_msg := SQLERRM;
>>>>
>>>> create_ss_log('Catalog Exposure - Error',
>>>> v_start_time, 'pcat_exp_supp_buyer_ss_'||v_set_name,
>>>>
>>>> v_count_before,
>>>> v_count_after, v_err_msg);
>>>>
>>>>
>>>>
>>>> END;
>>>>
>>>> $BODY$
>>>>
>>>>   LANGUAGE plpgsql VOLATILE SECURITY DEFINER
>>>>
>>>>   COST 100;
>>>>
>>>> ALTER FUNCTION create_catexp_ss_master()
>>>>
>>>>   OWNER TO postgres;
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Regards,
>>>> SS
>>>>
>>>>
>>> Regards
>>>
>>> Pavel Stehule
>>>
>>
>>
>

Re: [GENERAL] Function error

[Sachin Srivastava]

Because I have migrated the database from Oracle to Postgres through ORA2PG.

So how I will change it, please suggest.

On Fri, Jan 8, 2016 at 2:54 PM, Pavel Stehule <pavel.steh...@gmail.com>
wrote:

>
>
> 2016-01-08 10:08 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>
>> Hi,
>>
>> I am also getting "syntax error for below function (just some lines of
>> function where I am getting syntax error), please suggest why?
>>
>
> Using Oracle's outer join syntax, not ANSI SQL syntax
>
> Regards
>
> Pavel
>
>
>> 
>>
>>   -- Image path
>> AND mk1.subscriber_id(+)=pcat_catalog_item.subscriber_id
>> AND cs1.subscriber_id(+)=pcat_catalog_item.subscriber_id
>> AND cs1.company_id(+)=pcat_catalog_item.company_id
>> AND
>> pcat_catalog_dup_detail.dest_subscriber_id(+)=pcat_item_categorization.subscriber_id
>> AND
>> pcat_catalog_dup_detail.dest_supplier_company_id(+)=pcat_item_categorization.item_company_id
>> AND
>> pcat_catalog_dup_detail.dest_catalog_code(+)=pcat_item_categorization.catalog_code
>> AND mk2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
>> AND cs2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
>> AND cs2.company_id(+)=pcat_catalog_dup_detail.company_id;
>>
>> --
>>
>>
>> ERROR:  syntax error at or near ")"
>> LINE 216: AND mk1.subscriber_id(+)=pcat_catalog_item.subscribe...
>>  ^
>> ** Error **
>> ERROR: syntax error at or near ")"
>> SQL state: 42601
>> Character: 10018
>>
>> Regards
>> SS
>>
>>
>

Re: [GENERAL] Function error

[Sachin Srivastava]

Thanks Pavel for your help !!!

On Fri, Jan 8, 2016 at 3:28 PM, Pavel Stehule <pavel.steh...@gmail.com>
wrote:

>
>
> 2016-01-08 10:52 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>
>> Because I have migrated the database from Oracle to Postgres through
>> ORA2PG.
>>
>> So how I will change it, please suggest.
>>
>
>
> http://stackoverflow.com/questions/2269156/converting-from-oracle-join-to-postgres-join
>
>
>> On Fri, Jan 8, 2016 at 2:54 PM, Pavel Stehule <pavel.steh...@gmail.com>
>> wrote:
>>
>>>
>>>
>>> 2016-01-08 10:08 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>>>
>>>> Hi,
>>>>
>>>> I am also getting "syntax error for below function (just some lines of
>>>> function where I am getting syntax error), please suggest why?
>>>>
>>>
>>> Using Oracle's outer join syntax, not ANSI SQL syntax
>>>
>>> Regards
>>>
>>> Pavel
>>>
>>>
>>>> 
>>>>
>>>>   -- Image path
>>>> AND mk1.subscriber_id(+)=pcat_catalog_item.subscriber_id
>>>> AND cs1.subscriber_id(+)=pcat_catalog_item.subscriber_id
>>>> AND cs1.company_id(+)=pcat_catalog_item.company_id
>>>> AND
>>>> pcat_catalog_dup_detail.dest_subscriber_id(+)=pcat_item_categorization.subscriber_id
>>>> AND
>>>> pcat_catalog_dup_detail.dest_supplier_company_id(+)=pcat_item_categorization.item_company_id
>>>> AND
>>>> pcat_catalog_dup_detail.dest_catalog_code(+)=pcat_item_categorization.catalog_code
>>>> AND mk2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
>>>> AND cs2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
>>>> AND cs2.company_id(+)=pcat_catalog_dup_detail.company_id;
>>>>
>>>> --
>>>>
>>>>
>>>> ERROR:  syntax error at or near ")"
>>>> LINE 216: AND
>>>> mk1.subscriber_id(+)=pcat_catalog_item.subscribe...
>>>>  ^
>>>> ** Error **
>>>> ERROR: syntax error at or near ")"
>>>> SQL state: 42601
>>>> Character: 10018
>>>>
>>>> Regards
>>>> SS
>>>>
>>>>
>>>
>>
>

Re: [GENERAL] RAM of Postgres Server

[Sachin Srivastava]

Dear David G. and Gavin,

Please find the details as below:


* Q. What type of queries to be run on postgres database server? *

All types. Databases will be general OLTP.

*Q. Size of commonly accessed tables, indexes, ... ?*

Various. Anywhere from a few MB to over 100GB.



*Q. Database size for current and for future for all databases: *

Various. Anywhere from 100 – 1000GB and always growing.



*Q. Total Connection limit from the database through users and Application
on daily basis for all the database:*

Probably 4000+



*Q.  CPU Core: *

Prod databases will have 32 cores of CPU and 128 GB of RAM.


If you want any other information then inform to me.


Regards,

SS




On Thu, Jan 7, 2016 at 8:51 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:

> On Thu, Jan 7, 2016 at 12:32 AM, Sachin Srivastava <
> ssr.teleat...@gmail.com> wrote:
>
>> Dear David,
>>
>>
>>
>>
>>
>> Q: RAM holds data that is recently accessed - how much of that will you
>> have?
>>
>>
>>
>> Ans: Kindly confirm, as per your question “RAM holds data that is
>> recently accessed” :  How we figured out that how much data we will
>> have. Is it depends of Total WAL files (total "checkpoint_segment" I have
>> given 32), am I correct or thinking wrong, please clarify to me.
>>
>>
>>
>> Right now we have 10 GB RAM for first database server and 3 GB RAM for
>> another database server.
>>
>>
> Using WAL to measure your active dataset is not going to work.  WAL
> activity occurs when you WRITE data while in many cases the data in RAM is
> data that was written to the WAL a long time ago.
>
>
>>
>>
>>
>>
>> Q: Cores help service concurrent requests - how many of those will you
>> have?  How fast will they complete?
>>
>>
>>
>> Ans: It’s means, if we have more core then we can do our work fast. Like
>> from 9.3 onwards for pg_dump as example, if machines having multiple cores
>> as the load can be shared among separate threads.
>>
>>
>>
>> So if possible to us then more core should be available on database
>> server for better performance, please clarify the benefit of more core to
>> me.
>>
>>
>>
>> Right now we have 1 core for first database server and 2 core for another
>> database server.
>>
>>
>>
>
> ​PostgreSQL is process-oriented and presently only uses a single process
> to service a single connection.  Application software can upon up multiple
> connections -  which is what pg_dump does.  More rypically you'd have
> something like a web server where all of the incoming requests are funneled
> through a connection pool which then opens a number of connections to the
> database which it then shares among those requests.
>
> If you want advice you are going to have to give considerably more detail
> of your application and database usage patterns than you have.
>
> David J.
>

Re: [GENERAL] RAM of Postgres Server

[Sachin Srivastava]

Dear John,

We are looking at more like 500-600 connections simultaneously in 1 day
and I want to say we get 1 to 12000 connections a day per db.

Regards
SS

On Fri, Jan 8, 2016 at 10:49 AM, John R Pierce <pie...@hogranch.com> wrote:

> On 1/7/2016 8:21 PM, Sachin Srivastava wrote:
>
> *Q. Total Connection limit from the database through users and Application
> on daily basis for all the database:*
>
> Probably 4000+
>
>
> I hope you mean 4000 sessions/day, and not 4000 concurrent connections.
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>

Re: [GENERAL] Function error

[Sachin Srivastava]

Thanks Pavel !!!

On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule <pavel.steh...@gmail.com>
wrote:

> Hi
>
>
>
> 2016-01-08 8:24 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>
>> Dear Concern,
>>
>>
>>
>> I am creating below function *“create_catexp_ss_master()” *and getting
>> error as below, I have already created dependent function firstly
>> successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but still
>> getting error, please suggest why?
>>
>>
>>
>> ERROR:  syntax error at or near "create_catexp_ss_1"
>>
>> LINE 38:  create_catexp_ss_1;
>>
>>   ^
>>
>> ** Error **
>>
>>
>>
>> ERROR: syntax error at or near "create_catexp_ss_1"
>>
>> SQL state: 42601
>>
>> Character: 1104
>>
>>
>>
>>
>>
>>
>>
>> -- Function: create_catexp_ss_master()
>>
>>
>>
>> -- DROP FUNCTION create_catexp_ss_master();
>>
>>
>>
>> CREATE OR REPLACE FUNCTION create_catexp_ss_master()
>>
>>   RETURNS void AS
>>
>> $BODY$
>>
>> DECLARE
>>
>>
>>
>> -- Build snapshot tables for catalog itme exposure.
>>
>>
>>
>> -- Versions:
>>
>> -- 2013.1 hxu T11464 - Two Table Catalog Snap Shot Process. 02/27/13
>>
>> -- 2013.02 hxu T11899 - Remove the Single Supplier check box from Screen
>> and from the Code. 05/23/13
>>
>> --
>>
>>
>>
>> v_count_before bigint;
>>
>> v_count_after bigint;
>>
>> v_start_time timestamp;
>>
>> v_err_msg varchar(1000);
>>
>> v_set_name varchar(10);
>>
>>
>>
>>
>> BEGIN
>>
>> v_set_name:=ssj4_snapshot_pkg.get_inactive_ss_set_name;
>>
>> SELECT LOCALTIMESTAMP INTO v_start_time ;
>>
>>
>>
>> if v_set_name='A' then
>>
>> SELECT count(1) INTO v_count_before FROM
>> pcat_exp_supp_buyer_ss_a;
>>
>> else
>>
>> SELECT count(1) INTO v_count_before FROM
>> pcat_exp_supp_buyer_ss_b;
>>
>> end if;
>>
>>
>>
>> -- Remove old data.
>>
>> EXECUTE 'truncate table
>> pcat_exp_supp_buyer_ss_'||v_set_name;
>>
>> EXECUTE 'truncate table
>> pcat_exp_supp_cat_buyer_ss_'||v_set_name;
>>
>
> Attention - this is potentially serious security bug
>
> EXECUTE 'TRUNCATE TABLE ' || quote_ident(pcat_exp_supp_cat_buyer_ss_ ||
> v_set_name);
>
>
>>
>>
>> -- Exposure for single supplier without category
>> filtering
>>
>> create_catexp_ss_1;
>>
>
> you have to call this function via PERFORM statement
>
>PERFORM create_catexp_ss_1();
>
>
>>
>>
>> -- Exposure for single supplier with category filtering
>>
>>
>> create_catexp_ss_2;
>>
>>
>>
>> if v_set_name='A' then
>>
>> SELECT count(1) INTO v_count_after FROM
>> pcat_exp_supp_buyer_ss_a;
>>
>> else
>>
>> SELECT count(1) INTO v_count_after FROM
>> pcat_exp_supp_buyer_ss_b;
>>
>> end if;
>>
>>
>>
>> -- Log
>>
>> create_ss_log('Catalog Exposure', v_start_time,
>> 'pcat_exp_supp_buyer_ss_'||v_set_name,
>>
>> v_count_before, v_count_after, null);
>>
>>
>>
>> exception-- log error
>>
>> when others then
>>
>> v_err_msg := SQLERRM;
>>
>> create_ss_log('Catalog Exposure - Error', v_start_time,
>> 'pcat_exp_supp_buyer_ss_'||v_set_name,
>>
>> v_count_before,
>> v_count_after, v_err_msg);
>>
>>
>>
>> END;
>>
>> $BODY$
>>
>>   LANGUAGE plpgsql VOLATILE SECURITY DEFINER
>>
>>   COST 100;
>>
>> ALTER FUNCTION create_catexp_ss_master()
>>
>>   OWNER TO postgres;
>>
>>
>>
>>
>>
>>
>> Regards,
>> SS
>>
>>
> Regards
>
> Pavel Stehule
>

Re: [GENERAL] Function error

[Sachin Srivastava]

Thanks Charles !!!

On Fri, Jan 8, 2016 at 1:15 PM, Sachin Srivastava <ssr.teleat...@gmail.com>
wrote:

> Thanks Pavel !!!
>
> On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule <pavel.steh...@gmail.com>
> wrote:
>
>> Hi
>>
>>
>>
>> 2016-01-08 8:24 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
>>
>>> Dear Concern,
>>>
>>>
>>>
>>> I am creating below function *“create_catexp_ss_master()” *and getting
>>> error as below, I have already created dependent function firstly
>>> successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but
>>> still getting error, please suggest why?
>>>
>>>
>>>
>>> ERROR:  syntax error at or near "create_catexp_ss_1"
>>>
>>> LINE 38:  create_catexp_ss_1;
>>>
>>>   ^
>>>
>>> ** Error **
>>>
>>>
>>>
>>> ERROR: syntax error at or near "create_catexp_ss_1"
>>>
>>> SQL state: 42601
>>>
>>> Character: 1104
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> -- Function: create_catexp_ss_master()
>>>
>>>
>>>
>>> -- DROP FUNCTION create_catexp_ss_master();
>>>
>>>
>>>
>>> CREATE OR REPLACE FUNCTION create_catexp_ss_master()
>>>
>>>   RETURNS void AS
>>>
>>> $BODY$
>>>
>>> DECLARE
>>>
>>>
>>>
>>> -- Build snapshot tables for catalog itme exposure.
>>>
>>>
>>>
>>> -- Versions:
>>>
>>> -- 2013.1 hxu T11464 - Two Table Catalog Snap Shot Process. 02/27/13
>>>
>>> -- 2013.02 hxu T11899 - Remove the Single Supplier check box from Screen
>>> and from the Code. 05/23/13
>>>
>>> --
>>>
>>>
>>>
>>> v_count_before bigint;
>>>
>>> v_count_after bigint;
>>>
>>> v_start_time timestamp;
>>>
>>> v_err_msg varchar(1000);
>>>
>>> v_set_name varchar(10);
>>>
>>>
>>>
>>>
>>> BEGIN
>>>
>>> v_set_name:=ssj4_snapshot_pkg.get_inactive_ss_set_name;
>>>
>>> SELECT LOCALTIMESTAMP INTO v_start_time ;
>>>
>>>
>>>
>>> if v_set_name='A' then
>>>
>>> SELECT count(1) INTO v_count_before
>>> FROM pcat_exp_supp_buyer_ss_a;
>>>
>>> else
>>>
>>> SELECT count(1) INTO v_count_before
>>> FROM pcat_exp_supp_buyer_ss_b;
>>>
>>> end if;
>>>
>>>
>>>
>>> -- Remove old data.
>>>
>>> EXECUTE 'truncate table
>>> pcat_exp_supp_buyer_ss_'||v_set_name;
>>>
>>> EXECUTE 'truncate table
>>> pcat_exp_supp_cat_buyer_ss_'||v_set_name;
>>>
>>
>> Attention - this is potentially serious security bug
>>
>> EXECUTE 'TRUNCATE TABLE ' || quote_ident(pcat_exp_supp_cat_buyer_ss_ ||
>> v_set_name);
>>
>>
>>>
>>>
>>> -- Exposure for single supplier without category
>>> filtering
>>>
>>> create_catexp_ss_1;
>>>
>>
>> you have to call this function via PERFORM statement
>>
>>PERFORM create_catexp_ss_1();
>>
>>
>>>
>>>
>>> -- Exposure for single supplier with category filtering
>>>
>>>
>>> create_catexp_ss_2;
>>>
>>>
>>>
>>> if v_set_name='A' then
>>>
>>> SELECT count(1) INTO v_count_after FROM
>>> pcat_exp_supp_buyer_ss_a;
>>>
>>> else
>>>
>>> SELECT count(1) INTO v_count_after FROM
>>> pcat_exp_supp_buyer_ss_b;
>>>
>>> end if;
>>>
>>>
>>>
>>> -- Log
>>>
>>> create_ss_log('Catalog Exposure', v_start_time,
>>> 'pcat_exp_supp_buyer_ss_'||v_set_name,
>>>
>>> v_count_before, v_count_after, null);
>>>
>>>
>>>
>>> exception-- log error
>>>
>>> when others then
>>>
>>> v_err_msg := SQLERRM;
>>>
>>> create_ss_log('Catalog Exposure - Error', v_start_time,
>>> 'pcat_exp_supp_buyer_ss_'||v_set_name,
>>>
>>> v_count_before,
>>> v_count_after, v_err_msg);
>>>
>>>
>>>
>>> END;
>>>
>>> $BODY$
>>>
>>>   LANGUAGE plpgsql VOLATILE SECURITY DEFINER
>>>
>>>   COST 100;
>>>
>>> ALTER FUNCTION create_catexp_ss_master()
>>>
>>>   OWNER TO postgres;
>>>
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>> SS
>>>
>>>
>> Regards
>>
>> Pavel Stehule
>>
>
>

[GENERAL] Function error

[Sachin Srivastava]

Dear Concern,



I am creating below function *“create_catexp_ss_master()” *and getting
error as below, I have already created dependent function firstly
successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but still
getting error, please suggest why?



ERROR:  syntax error at or near "create_catexp_ss_1"

LINE 38:  create_catexp_ss_1;

  ^

** Error **



ERROR: syntax error at or near "create_catexp_ss_1"

SQL state: 42601

Character: 1104







-- Function: create_catexp_ss_master()



-- DROP FUNCTION create_catexp_ss_master();



CREATE OR REPLACE FUNCTION create_catexp_ss_master()

  RETURNS void AS

$BODY$

DECLARE



-- Build snapshot tables for catalog itme exposure.



-- Versions:

-- 2013.1 hxu T11464 - Two Table Catalog Snap Shot Process. 02/27/13

-- 2013.02 hxu T11899 - Remove the Single Supplier check box from Screen
and from the Code. 05/23/13

--



v_count_before bigint;

v_count_after bigint;

v_start_time timestamp;

v_err_msg varchar(1000);

v_set_name varchar(10);




BEGIN

v_set_name:=ssj4_snapshot_pkg.get_inactive_ss_set_name;

SELECT LOCALTIMESTAMP INTO v_start_time ;



if v_set_name='A' then

SELECT count(1) INTO v_count_before FROM
pcat_exp_supp_buyer_ss_a;

else

SELECT count(1) INTO v_count_before FROM
pcat_exp_supp_buyer_ss_b;

end if;



-- Remove old data.

EXECUTE 'truncate table
pcat_exp_supp_buyer_ss_'||v_set_name;

EXECUTE 'truncate table
pcat_exp_supp_cat_buyer_ss_'||v_set_name;



-- Exposure for single supplier without category
filtering


create_catexp_ss_1;



-- Exposure for single supplier with category filtering


create_catexp_ss_2;



if v_set_name='A' then

SELECT count(1) INTO v_count_after FROM
pcat_exp_supp_buyer_ss_a;

else

SELECT count(1) INTO v_count_after FROM
pcat_exp_supp_buyer_ss_b;

end if;



-- Log

create_ss_log('Catalog Exposure', v_start_time,
'pcat_exp_supp_buyer_ss_'||v_set_name,

v_count_before, v_count_after, null);



exception-- log error

when others then

v_err_msg := SQLERRM;

create_ss_log('Catalog Exposure - Error', v_start_time,
'pcat_exp_supp_buyer_ss_'||v_set_name,

v_count_before,
v_count_after, v_err_msg);



END;

$BODY$

  LANGUAGE plpgsql VOLATILE SECURITY DEFINER

  COST 100;

ALTER FUNCTION create_catexp_ss_master()

  OWNER TO postgres;






Regards,
SS

[GENERAL] RAM of Postgres Server

[Sachin Srivastava]

Dear Team,

Please suggest, how much RAM and core should be define for New Postgres
database server, if we will use Postgres 9.3 and above.

If suppose my postgres database size will be near about 300 to 500 GB for
future.

There is any document regarding this server configuration, suggest ?

Regards,
SS

Re: [GENERAL] RAM of Postgres Server

[Sachin Srivastava]

Dear David,





Q: RAM holds data that is recently accessed - how much of that will you
have?



Ans: Kindly confirm, as per your question “RAM holds data that is recently
accessed” :  How we figured out that how much data we will have. Is it
depends of Total WAL files (total "checkpoint_segment" I have given 32), am
I correct or thinking wrong, please clarify to me.



Right now we have 10 GB RAM for first database server and 3 GB RAM for
another database server.





Q: Cores help service concurrent requests - how many of those will you
have?  How fast will they complete?



Ans: It’s means, if we have more core then we can do our work fast. Like
from 9.3 onwards for pg_dump as example, if machines having multiple cores
as the load can be shared among separate threads.



So if possible to us then more core should be available on database server
for better performance, please clarify the benefit of more core to me.



Right now we have 1 core for first database server and 2 core for another
database server.







Regards,

Sachin

On Thu, Jan 7, 2016 at 11:25 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:

> On Wed, Jan 6, 2016 at 10:39 PM, Sachin Srivastava <
> ssr.teleat...@gmail.com> wrote:
>
>> Dear Team,
>>
>> Please suggest, how much RAM and core should be define for New Postgres
>> database server, if we will use Postgres 9.3 and above.
>>
>> If suppose my postgres database size will be near about 300 to 500 GB for
>> future.
>>
>> There is any document regarding this server configuration, suggest ?
>>
>>
>>
> ​Total size is meaningless because, for instance, consider if of that
> 500GB, 499GB of it​
>
> ​is archive data that is rarely if ever accessed.
>
> RAM holds data that is recently accessed - how much of that will you have?
> Cores help service concurrent requests - how many of those will you have?
> How fast will they complete?
> ​
> ​David J.
>
>

[GENERAL] Function in PostgreSQL

[Sachin Srivastava]

Hi,



Do you know if it is possible to create a function in postgres that has
errors in the syntax of the creation sql? It would help our conversion
process if we could get all of our various functions present in postgres
even if they aren’t in 100% working shape. Is there any way to ignore
errors on object creation?


Please suggest?



Regards,

SS

[GENERAL] Postgresql Dump Question

[Sachin Srivastava]

Hi Team,

If anybody have PostgreSQL Dump questions like Oracle dump question for
preparation of PostgreSQL certification. kindly provide, if someone have.

Regards,
SS

[GENERAL] SQL conversion tool

[Sachin Srivastava]

Hi,

Please inform which is the best tool for SQL conversion because I have to
migration Oracle database into PostgreSQL.

Regards,
SS

[GENERAL] DB_link connection

[Sachin Srivastava]

Hi,

Any one can help me how we can install "dblink_connect" in PostgreSQL9.4 on
linux platform. If Possible, please provide the steps.

Regards,
Sachin Srivastava
9811149139

[GENERAL] How to reduce pg_dump backup time

[Sachin Srivastava]

Dear Team,



I am using PostgreSQL 9.1 on Redhat Linux on my Production environment. My
database size is 680 GB and it take 7 hour for completion the pg_dump
backup.



I want that my pg_dump backup should be fast and take less time.



In PostgresQL 9.3 there is “ -j *njobs” *option is available for fast
pg_dump backup.



There is any way, that I will use *“ **-j njobs”** option *in “PostgreSQL
9.1 “ so that my backup is completed in less time or any other way in
”PostgreSQL 9.1” to take the backup fast. Kindly suggest?





*[root]# lsb_release –a*



LSB Version:
:base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: RedHatEnterpriseServer

Description:Red Hat Enterprise Linux Server release 6.7 (Santiago)

Release:6.7

Codename:   Santiago



*[root@CPPMOMA_DB01 even]# psql*

Password:

psql.bin (9.1.2)

Type "help" for help.



postgres=# select version();

version

---

 PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-46), 64-bit

(1 row)



postgres=#









*Regards,*
Sachin Srivastava

Re: [GENERAL] pg_basebackup problem for Streaming replication

[Sachin Srivastava]

Dear All,

Kindly suggest to me why this problem is coming.

Regards,
Sachin

On Thu, Sep 3, 2015 at 12:09 PM, Sachin Srivastava <ssr.teleat...@gmail.com>
wrote:

> Dear Experts,
>
>
> One problem, I am facing that when I am using *pg_basebackup* (on Standby
> Server) it’s copying only some files and directories not all like pg_notify
> folder etc. That’s why when I am restarting the database on "Standby
> Server" after "pg_basebackup" then it’s showing an error below. If you have
> an idea why these files/folders(through pg_basebackup) are not copying
> completely then tell to me.
>
>
>
> *“2015-09-03 16:58:30 IST FATAL:  could not open directory "pg_notify": No
> such file or directory”*
>
>
>
> *Pg_basebackup command as below:*
>
>
>
> *pg_basebackup -D /opt/PostgreSQL/9.1/data/ -v -Fp -l Testbackup -h
> 172.17.43.84 -U replication >& backup.log*
>
>
>
> *Data directory of Standby server after taking the pg_basebackup through
> above command*
>
>
>
> [root@INN14U-DW1353 data]# pwd
>
> /opt/PostgreSQL/9.1/data
>
> [root@INN14U-DW1353 data]# ls -ltr
>
> total 100
>
> -rwx--. 1 postgres postgres   173 Sep  3 16:55 backup_label
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_log
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 global
>
> drwx--. 5 postgres postgres  4096 Sep  3 16:55 base
>
> -rwx--. 1 postgres postgres 19158 Sep  3 16:55 postgresql.conf_backup
>
> -rwx--. 1 postgres postgres 19231 Sep  3 16:55 postgresql.conf
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_xlog
>
> -rwx--. 1 postgres postgres 4 Sep  3 16:55 PG_VERSION
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_twophase
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_tblspc
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_subtrans
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_stat_tmp
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_serial
>
> drwx--. 4 postgres postgres  4096 Sep  3 16:55 pg_multixact
>
> -rwx--. 1 postgres postgres  4406 Sep  3 16:55 pg_hba.conf
>
> drwx--. 2 postgres postgres  4096 Sep  3 16:55 main
>
>
>
> *Data directory of “Primary Server”*
>
>
>
>
>
> -bash-4.1$ pwd
>
> /opt/PostgreSQL/9.1/data
>
> -bash-4.1$ ls -ltr
>
> total 124
>
> -rw--- 1 postgres postgres 4 Aug 24 11:25 PG_VERSION
>
> drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_twophase
>
> drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_tblspc
>
> drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_subtrans
>
> drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_serial
>
> drwx-- 4 postgres postgres  4096 Aug 24 11:25 pg_multixact
>
> -rw--- 1 postgres postgres  1636 Aug 24 11:25 pg_ident.conf
>
> drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_clog
>
> drwx-- 5 postgres postgres  4096 Aug 24 11:25 base
>
> -rw-r--r-- 1 root root 19158 Aug 28 10:26 postgresql.conf_backup
>
> -rw--- 1 root root  4222 Aug 28 10:37 pg_hba.conf_backup
>
> drwx-- 2 postgres postgres  4096 Aug 31 13:19 main
>
> -rw-rw-r-- 1 postgres postgres 19231 Sep  2 18:42 postgresql.conf
>
> -rw--- 1 postgres postgres  4406 Sep  3 11:13 pg_hba.conf
>
> -rw--- 1 postgres postgres73 Sep  3 11:13 postmaster.pid
>
> -rw--- 1 postgres postgres65 Sep  3 11:13 postmaster.opts
>
> drwx-- 2 postgres postgres  4096 Sep  3 11:13 pg_notify
>
> drwxr-xr-x 2 postgres postgres  4096 Sep  3 11:13 pg_log
>
> drwx-- 2 postgres postgres  4096 Sep  3 11:14 global
>
> drwx-- 3 postgres postgres  4096 Sep  3 11:25 pg_xlog
>
> drwx-- 2 postgres postgres  4096 Sep  3 11:42 pg_stat_tmp
>
> -bash-4.1$
>
>
> And one more thing when I am checking the pg_basebackup log then it's also
> showing below error, why?
>
>
> [root@INN14U-DW1353 ~]# cat backup.log
>
>
> pg_basebackup: could not get WAL end position from server
>
>
> Regards,
>
> Sachin
>
>

[GENERAL] pg_basebackup problem for Streaming replication

[Sachin Srivastava]

Dear Experts,


One problem, I am facing that when I am using *pg_basebackup* (on Standby
Server) it’s copying only some files and directories not all like pg_notify
folder etc. That’s why when I am restarting the database on "Standby
Server" after "pg_basebackup" then it’s showing an error below. If you have
an idea why these files/folders(through pg_basebackup) are not copying
completely then tell to me.



*“2015-09-03 16:58:30 IST FATAL:  could not open directory "pg_notify": No
such file or directory”*



*Pg_basebackup command as below:*



*pg_basebackup -D /opt/PostgreSQL/9.1/data/ -v -Fp -l Testbackup -h
172.17.43.84 -U replication >& backup.log*



*Data directory of Standby server after taking the pg_basebackup through
above command*



[root@INN14U-DW1353 data]# pwd

/opt/PostgreSQL/9.1/data

[root@INN14U-DW1353 data]# ls -ltr

total 100

-rwx--. 1 postgres postgres   173 Sep  3 16:55 backup_label

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_log

drwx--. 2 postgres postgres  4096 Sep  3 16:55 global

drwx--. 5 postgres postgres  4096 Sep  3 16:55 base

-rwx--. 1 postgres postgres 19158 Sep  3 16:55 postgresql.conf_backup

-rwx--. 1 postgres postgres 19231 Sep  3 16:55 postgresql.conf

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_xlog

-rwx--. 1 postgres postgres 4 Sep  3 16:55 PG_VERSION

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_twophase

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_tblspc

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_subtrans

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_stat_tmp

drwx--. 2 postgres postgres  4096 Sep  3 16:55 pg_serial

drwx--. 4 postgres postgres  4096 Sep  3 16:55 pg_multixact

-rwx--. 1 postgres postgres  4406 Sep  3 16:55 pg_hba.conf

drwx--. 2 postgres postgres  4096 Sep  3 16:55 main



*Data directory of “Primary Server”*





-bash-4.1$ pwd

/opt/PostgreSQL/9.1/data

-bash-4.1$ ls -ltr

total 124

-rw--- 1 postgres postgres 4 Aug 24 11:25 PG_VERSION

drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_twophase

drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_tblspc

drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_subtrans

drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_serial

drwx-- 4 postgres postgres  4096 Aug 24 11:25 pg_multixact

-rw--- 1 postgres postgres  1636 Aug 24 11:25 pg_ident.conf

drwx-- 2 postgres postgres  4096 Aug 24 11:25 pg_clog

drwx-- 5 postgres postgres  4096 Aug 24 11:25 base

-rw-r--r-- 1 root root 19158 Aug 28 10:26 postgresql.conf_backup

-rw--- 1 root root  4222 Aug 28 10:37 pg_hba.conf_backup

drwx-- 2 postgres postgres  4096 Aug 31 13:19 main

-rw-rw-r-- 1 postgres postgres 19231 Sep  2 18:42 postgresql.conf

-rw--- 1 postgres postgres  4406 Sep  3 11:13 pg_hba.conf

-rw--- 1 postgres postgres73 Sep  3 11:13 postmaster.pid

-rw--- 1 postgres postgres65 Sep  3 11:13 postmaster.opts

drwx-- 2 postgres postgres  4096 Sep  3 11:13 pg_notify

drwxr-xr-x 2 postgres postgres  4096 Sep  3 11:13 pg_log

drwx-- 2 postgres postgres  4096 Sep  3 11:14 global

drwx-- 3 postgres postgres  4096 Sep  3 11:25 pg_xlog

drwx-- 2 postgres postgres  4096 Sep  3 11:42 pg_stat_tmp

-bash-4.1$


And one more thing when I am checking the pg_basebackup log then it's also
showing below error, why?


[root@INN14U-DW1353 ~]# cat backup.log


pg_basebackup: could not get WAL end position from server


Regards,

Sachin

[GENERAL] How to tune my new server

[Sachin Srivastava]

Hi,

If my system RAM is 50 GB then how can I tune my database server without
using the Thumb rule of postgresql.conf parameter like:

Shared_buffer: 25% of the RAM
temp_buffers: should be default
work_mem: AvRAM/2 * Max_connections
etc...

There is any another way or any other rule or Tool which can recommend me
to tune my database.

Regards,
Sachin

Re: [GENERAL] PostgreSQL - The Best Overall Database

[Sachin Srivastava]

Congrats to all PostgreSQL DBA’s for this achievement..


HERE ARE THE WINNERS OF THE 2015 DBTA READERS' CHOICE AWARDS FOR BEST DATABASE 
(OVERALL):
Winner:
PostgreSQLhttp://www.postgresql.org/
http://www.postgresql.org/
Finalists:
Oracle Databasehttp://www.oracle.com/

Microsoft SQL Serverhttp://www.microsoft.com/


Regards,
Sachin Srivastava
Consultant (Oracle/PostgreSQL) | Technical Support Group | DNO – T  N Tom Tom 
Cyient | www.cyient.comhttp://www.cyient.com/

Mobile: +91 981 114 9139 | 
sachin.srivast...@cyient.commailto:sachin.srivast...@cyient.com
Direct: +91 120 669 1078 | Board: +91 120 669  2000 - 10



From: pgsql-general-ow...@postgresql.org 
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson
Sent: 13 August, 2015 6:34 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostgreSQL - The Best Overall Database


This should put a smile on all PostgreSQL DBA's faces.

The Best Overall 
Databasehttp://www.dbta.com/Editorial/Trends-and-Applications/Best-Database-Overall%C2%AD-105362.aspx

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you. 
[http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif]



DISCLAIMER:

This email may contain confidential information and is intended only for the 
use of the specific individual(s) to which it is addressed. If you are not the 
intended recipient of this email, you are hereby notified that any unauthorized 
use, dissemination or copying of this email or the information contained in it 
or attached to it is strictly prohibited. If you received this message in 
error, please immediately notify the sender at Cyient and delete the original 
message.

[GENERAL] How to restore

[Sachin Srivastava]

Dear Team,

If I have taken any backup successfully through pg_dump? How can I restore
this pg_dump(Sql file) without use of pg_restore.

There is any command line option or through psql, kindly inform to me.

Regards,
Sachin

[GENERAL] Getting error IST FATAL: the database system is in recovery mode

[Sachin Srivastava]

Dear Team,

I am getting the below error in my database pg_log file and also I am
unable to open the database.



IST FATAL:  the database system is in recovery mode

I am using postgresql version 9.1 on Centos 6.6. Kindly suggest why this
problem is coming.

Regards,
Sachin

[GENERAL] Memory Utilization Issue

[Sachin Srivastava]

Dear Concern,


Always my server memory utilization is remain 99%. I have 4 DB server and
RAM of the server is (32 GB, 64 GB, 64 GB and 132 GB*). In every server
always we are getting the memory utilization  99%. *Kindly suggest why
this problem is and which parameter will resolve this problem.

I am using PostgreSQL 9.1.2 and PostGIS 1.5 version on every Red hat Linux
server. Kindly find the TOP result, ulimit -a  result,
(kernel.shmax, kernel.shmall, kernel.sem value) and pg_setting result
of one server as below. If you require any other information then inform to
me.





[root@CPPMOMA_DB01 ~]# top

top - 12:08:08 up 15 days, 15:45,  5 users,  load average: 1.05, 1.19, 1.35

Tasks: 605 total,   1 running, 604 sleeping,   0 stopped,   0 zombie

Cpu(s):  6.9%us,  2.1%sy,  0.0%ni, 78.3%id, 12.7%wa,  0.0%hi,  0.1%si,
0.0%st
Mem:  32832364k total, 32621168k used,   211196k free,77572k buffers


[root@CPPMOMA_DB01 ~]# ulimit -a
core file size  (blocks, -c) 0
data seg size   (kbytes, -d) unlimited
scheduling priority (-e) 0
file size   (blocks, -f) unlimited
pending signals (-i) 256323
max locked memory   (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files  (-n) 4096
pipe size(512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority  (-r) 0
stack size  (kbytes, -s) 10240
cpu time   (seconds, -t) unlimited
max user processes  (-u) 256323
virtual memory  (kbytes, -v) unlimited
file locks  (-x) unlimited
[root@CPPMOMA_DB01 ~]#


kernel.shmmax = 32212254720

kernel.shmall = 1073741824

kernel.sem = 250 32000 100 384


postgres=# SELECT name, source, setting FROM pg_settings WHERE source !=
'default' AND source != 'override' ORDER by 2, 1;

name|source| setting

+--+--

 application_name   | client   | psql.bin

 client_encoding| client   | UTF8

 archive_command| configuration file   | cp %p
/dbkup/momacpp_213_live/%f

 archive_mode   | configuration file   | on

 autovacuum | configuration file   | on

 autovacuum_max_workers | configuration file   | 3

 checkpoint_segments| configuration file   | 200

 checkpoint_timeout | configuration file   | 300

 checkpoint_warning | configuration file   | 30

 DateStyle  | configuration file   | ISO, MDY

 default_text_search_config | configuration file   | pg_catalog.english

 effective_cache_size   | configuration file   | 524288

 lc_messages| configuration file   | en_US.UTF-8

 lc_monetary| configuration file   | en_US.UTF-8

 lc_numeric | configuration file   | en_US.UTF-8

 lc_time| configuration file   | en_US.UTF-8

 listen_addresses   | configuration file   | *

 log_destination| configuration file   | stderr

 log_directory  | configuration file   | pg_log

 logging_collector  | configuration file   | on

 log_line_prefix| configuration file   | %t

 log_rotation_age   | configuration file   | 1440

 maintenance_work_mem   | configuration file   | 1638400

 max_connections| configuration file   | 2000

 max_files_per_process  | configuration file   | 2000

 max_wal_senders| configuration file   | 5

 port   | configuration file   | 5432

 shared_buffers | configuration file   | 1572864

 temp_buffers   | configuration file   | 4096

 wal_level  | configuration file   | archive

 work_mem   | configuration file   | 32768

 log_timezone   | environment variable | Asia/Kolkata

 max_stack_depth| environment variable | 2048

 TimeZone   | environment variable | Asia/Kolkata

(34 rows)



postgres=#






Regards,

*Sachin Srivastava*
Assistant Technical Lead(Oracle/PostgreSQL)| TSG
*Cyient* | www.cyient.com

Re: [GENERAL]

[Sachin Srivastava]

Hi Michael,

So, as per your suggestion I'll update my database from 9.1.2 to 9.1.15.

Kindly confirm, which year  this 9.1.2 was released and when 9.1.15 was
released.


And easily I can upgrade this and what are the steps to upgrade, kindly
confirm?


Regards,
Sachin

On Fri, May 15, 2015 at 5:16 PM, Sachin Srivastava ssr.teleat...@gmail.com
wrote:

 Hi,



 How can I fast my daily pg_dump backup. Can I use parallel option(Which is
 introduced in Postgres 9.3) with Postgres 9.1. There is any way I can use
 this is for 9.1 database.





 My database size is 820 GB and it’s taking 7 hours to complete.



 *Postgres Version: 9.1.2*

 *PogtGIS: 1.5*











 Regards,

 *Sachin Srivastava*
 Assistant Technical Lead(Oracle/PostgreSQL)| TSG
 *Cyient* | www.cyient.com

[GENERAL] pg_xlog Concern

[Sachin Srivastava]

Hi,





I have done below changes in my postgresql.conf.



*Checkpoint_segments= 200*

and

*checkpoint_timeout= 5min*





I am also doing archiving and below changes in my postgresql.conf.



*Wal_level=archive*

*archive_command= cp %p /dbkup/momacpp_213_live/%f*

*archive_mode=on*



Achieving is going smoothly in /*dbkup/momacpp_213_live* folder.





But currently my pg_xlog size is 60 GB and there are 3740 WAL file in this
folder and in Last week this was 400 GB(pg_xlog folder) and WAL file were
approx. 3. Due to archiving pg_xlog folder size is decreasing now but
it’s taking one week to come in normal size.





*I have 2 Question*:



*First:* When I have given *checkpoint segments=200 (As per my knowledge
WAL file should be generated 200*2+3=403 only)* but why it’s generating too
much file. MY each WAL file is 16 MB.



*Second:* Why pg_xlog size is increasing too much it should be only (403*16
MB = 6448 MB) and if Production team is not entering data in bulk and if
normal production is going then it’s size remain same as per logic.





How I handle this case (pg_xlog folder size) when Production people
entering the data in bulk, kindly suggest.  I am missing something in my
postgresql.conf and somewhere else.





*Note:* On daily basis Production team is entering the data in bulk
(approx. 30-50 GB) in the database and there are only 2 databases on this
server.









Regards,

*Sachin Srivastava*
Assistant Technical Lead(Oracle/PostgreSQL)| TSG
*Cyient* | www.cyient.com

[GENERAL] template_postgis issue

[Sachin Srivastava]

Dear Concern,

When I am installing PostgreSQL version 9.1 with PostGIS 1.5 then it's
creating template_postgis database by default.

But when I am installing below PostgreSQL version 9.3 with PostGIS 2.1.7

postgresql-9.3.6-2-windows-x64
postgis-bundle-pg93x64-setup-2.1.7-1

And PostgreSQL version 9.4 with PostGIS 2.1.7

postgresql-9.4.1-3-windows-x64
postgis-bundle-pg94x64-setup-2.1.7-1

It's not creating template_postgis by default. Kindly confirm what's
the problem is.

Note: I am installing these on Windows 7 machine (64 bit)

Regards,
Sachin


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL]

[Sachin Srivastava]

Hi,



How can I fast my daily pg_dump backup. Can I use parallel option(Which is
introduced in Postgres 9.3) with Postgres 9.1. There is any way I can use
this is for 9.1 database.





My database size is 820 GB and it’s taking 7 hours to complete.



*Postgres Version: 9.1.2*

*PogtGIS: 1.5*











Regards,

*Sachin Srivastava*
Assistant Technical Lead(Oracle/PostgreSQL)| TSG
*Cyient* | www.cyient.com

[GENERAL] Block Corruption issue..

[Sachin Srivastava]

Dear Concner,

Could you help us solving  the below error which we are getting during taking 
pg_dump.

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  invalid page header in block 
14521215 of relation pg_tblspc/18140340/PG_9.1_201105231/18140346/18140757
pg_dump: The command was: COPY evidence.partline (feature_id, version, 
base_type_id, domain_class_id, domain_subclass_id, status_id, deleted, 
modification_time, has_children, is_evidence, data_immediate, data_lazy, 
parent_line_id, start_point_id, end_point_id, start_offset, end_offset, 
geometry) TO stdout;




Regards,
Sachin Srivastava



DISCLAIMER:

This email may contain confidential information and is intended only for the 
use of the specific individual(s) to which it is addressed. If you are not the 
intended recipient of this email, you are hereby notified that any unauthorized 
use, dissemination or copying of this email or the information contained in it 
or attached to it is strictly prohibited. If you received this message in 
error, please immediately notify the sender at Cyient and delete the original 
message.

Re: [GENERAL] how long to wait on 9.2 bitrock installer?

[Sachin Srivastava]

The reboot might have purged the installation log.

On Thu, Sep 13, 2012 at 11:22 AM, Dann Corbit dcor...@connx.com wrote:

  I should mention also that the new PostgreSQL instance is working fine.
 I am looking forward to testing it.

 ** **

 *From:* Dann Corbit
 *Sent:* Wednesday, September 12, 2012 10:50 PM
 *To:* 'Sachin Srivastava'
 *Cc:* pgsql-general@postgresql.org
 *Subject:* RE: [GENERAL] how long to wait on 9.2 bitrock installer?

 ** **

 C:\Users\dcorbit\AppData\Local\Tempdir /s install-postgresql.log

 Volume in drive C has no label.

 Volume Serial Number is 7460-E8CF

 File Not Found

 ** **

 I did perform a reboot, because of several Windowsupdate installed
 things.  I don’t know if that caused the file to go away or not.

 ** **

 *From:* Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com]
 *Sent:* Wednesday, September 12, 2012 10:47 PM
 *To:* Dann Corbit
 *Cc:* pgsql-general@postgresql.org
 *Subject:* Re: [GENERAL] how long to wait on 9.2 bitrock installer?

 ** **

 If possible, can you share the installation log?
 (%TEMP%\install-postgresql.log)

 On Thu, Sep 13, 2012 at 11:12 AM, Dann Corbit dcor...@connx.com wrote:**
 **

 I just let it sit.  3.5 hours later, it completed.

  

 *From:* pgsql-general-ow...@postgresql.org [mailto:
 pgsql-general-ow...@postgresql.org] *On Behalf Of *Dann Corbit
 *Sent:* Wednesday, September 12, 2012 1:24 PM
 *To:* pgsql-general@postgresql.org
 *Subject:* [GENERAL] how long to wait on 9.2 bitrock installer?

  

 I have several versions of PostgreSQL already installed on this machine.
 We need to test compatibility with PostgreSQL database systems with our
 products.

 I tried to install 9.2 64 bit using the one click installer from this
 location:

 http://www.enterprisedb.com/products/pgdownload.do#windows

  

 I did use an unused port of 5439 as 5432-5438 are already in use by other
 instances of PostgreSQL.

  

 I am stalled here for more than one hour:

 

  

 Is there any chance that the installer is still doing something useful, or
 do I need to kill the process and wait until the installer gets stabilized?
 

  

  

 System info:

  

 Operating System new – server roles System Model

 Windows Server 2008 R2 Standard (x64) Service Pack 1 (build 7601)

 Install Language: English (United States)

 System Locale: English (United States)

 Installed: 5/17/2011 9:19:36 AM

  

 Server Roles:

 Application Server

 Web Server (IIS)

 File Services

 Hyper-V   Dell Inc. Precision WorkStation T3500
 

 System Service Tag: 4QV4FP1 (support for this PC)

 Chassis Serial Number: 4QV4FP1

 Enclosure Type: Tower

 Processor a Main Circuit Board b

 3.20 gigahertz Intel Xeon

 64 kilobyte primary memory cache

 256 kilobyte secondary memory cache

 8192 kilobyte tertiary memory cache

 64-bit ready

 Multi-core (4 total)

 Not hyper-threaded   Board: Dell Inc. 09KPNV A00

 Serial Number: ..CN7082111680FL.

 Bus Clock: 4800 megahertz

 BIOS: Dell Inc. A10 01/21/2011

 new USB Storage Use in past 30 Days (mouse over last used for details)
new Hosted Virtual Machines (mouse over name
 for details)

 Last Used

 Generic Flash HS-CF -- drive 2, s/n 26020128B005, rev 4.44
 8/21/2012 4:04:38 PM

 Generic Flash HS-COMBO -- drive 3, s/n 26020128B005, rev 4.44
 8/21/2012 4:04:38 PM

 CENTON DS Pro -- drive 1, s/n C0603681, rev 8.07  8/21/2012
 4:04:37 PM

 

 NameLast UsedStatus

 DCORBITxp 4/16/2012 8:13:43 PMStopped

 Drives new – drive encryption   Memory Modules c,d

 1000.21 Gigabytes Usable Hard Drive Capacity

 210.02 Gigabytes Hard Drive Free Space

  

 PLDS DVD-ROM DH-16D5S [Optical drive]

  

 ARRAY0 [Hard drive] -- drive 0, Not SMART

 CENTON DS Pro USB Device [Hard drive] (66.26 GB) -- drive 1

 Generic Flash HS-CF USB Device [Hard drive] -- drive 2

 Generic Flash HS-COMBO USB Device [Hard drive] -- drive 3
 12286 Megabytes Usable Installed Memory

  

 Slot 'DIMM 1 ' has 2048 MB (serial number 83631A8F)

 Slot 'DIMM 2 ' has 2048 MB (serial number 83631A8D)

 Slot 'DIMM 3 ' has 2048 MB (serial number 83631A8B)

 Slot 'DIMM 4 ' has 2048 MB (serial number 83631A87)

 Slot 'DIMM 5 ' has 2048 MB (serial number 83631A85)

 Slot 'DIMM 6 ' has 2048 MB (serial number 83631A83)

 Local Drive Volumes new – volume encryption

 

 

 c: (NTFS on drive 0) 1000.21 GB

Re: [GENERAL] how long to wait on 9.2 bitrock installer?

[Sachin Srivastava]

If possible, can you share the installation log?
(%TEMP%\install-postgresql.log)

On Thu, Sep 13, 2012 at 11:12 AM, Dann Corbit dcor...@connx.com wrote:

  I just let it sit.  3.5 hours later, it completed.

 ** **

 *From:* pgsql-general-ow...@postgresql.org [mailto:
 pgsql-general-ow...@postgresql.org] *On Behalf Of *Dann Corbit
 *Sent:* Wednesday, September 12, 2012 1:24 PM
 *To:* pgsql-general@postgresql.org
 *Subject:* [GENERAL] how long to wait on 9.2 bitrock installer?

 ** **

 I have several versions of PostgreSQL already installed on this machine.
 We need to test compatibility with PostgreSQL database systems with our
 products.

 I tried to install 9.2 64 bit using the one click installer from this
 location:

 http://www.enterprisedb.com/products/pgdownload.do#windows

 ** **

 I did use an unused port of 5439 as 5432-5438 are already in use by other
 instances of PostgreSQL.

 ** **

 I am stalled here for more than one hour:

 

 ** **

 Is there any chance that the installer is still doing something useful, or
 do I need to kill the process and wait until the installer gets stabilized?
 

 ** **

 ** **

 System info:

 ** **

 Operating System new – server roles System Model

 Windows Server 2008 R2 Standard (x64) Service Pack 1 (build 7601)

 Install Language: English (United States)

 System Locale: English (United States)

 Installed: 5/17/2011 9:19:36 AM

 ** **

 Server Roles:

 Application Server

 Web Server (IIS)

 File Services

 Hyper-V   Dell Inc. Precision WorkStation T3500
 

 System Service Tag: 4QV4FP1 (support for this PC)

 Chassis Serial Number: 4QV4FP1

 Enclosure Type: Tower

 Processor a Main Circuit Board b

 3.20 gigahertz Intel Xeon

 64 kilobyte primary memory cache

 256 kilobyte secondary memory cache

 8192 kilobyte tertiary memory cache

 64-bit ready

 Multi-core (4 total)

 Not hyper-threaded   Board: Dell Inc. 09KPNV A00

 Serial Number: ..CN7082111680FL.

 Bus Clock: 4800 megahertz

 BIOS: Dell Inc. A10 01/21/2011

 new USB Storage Use in past 30 Days (mouse over last used for details)
new Hosted Virtual Machines (mouse over name
 for details)

 Last Used

 Generic Flash HS-CF -- drive 2, s/n 26020128B005, rev 4.44
 8/21/2012 4:04:38 PM

 Generic Flash HS-COMBO -- drive 3, s/n 26020128B005, rev 4.44
 8/21/2012 4:04:38 PM

 CENTON DS Pro -- drive 1, s/n C0603681, rev 8.07  8/21/2012
 4:04:37 PM

 

 NameLast UsedStatus

 DCORBITxp 4/16/2012 8:13:43 PMStopped

 Drives new – drive encryption   Memory Modules c,d

 1000.21 Gigabytes Usable Hard Drive Capacity

 210.02 Gigabytes Hard Drive Free Space

 ** **

 PLDS DVD-ROM DH-16D5S [Optical drive]

 ** **

 ARRAY0 [Hard drive] -- drive 0, Not SMART

 CENTON DS Pro USB Device [Hard drive] (66.26 GB) -- drive 1

 Generic Flash HS-CF USB Device [Hard drive] -- drive 2

 Generic Flash HS-COMBO USB Device [Hard drive] -- drive 3
 12286 Megabytes Usable Installed Memory

 ** **

 Slot 'DIMM 1 ' has 2048 MB (serial number 83631A8F)

 Slot 'DIMM 2 ' has 2048 MB (serial number 83631A8D)

 Slot 'DIMM 3 ' has 2048 MB (serial number 83631A8B)

 Slot 'DIMM 4 ' has 2048 MB (serial number 83631A87)

 Slot 'DIMM 5 ' has 2048 MB (serial number 83631A85)

 Slot 'DIMM 6 ' has 2048 MB (serial number 83631A83)

 Local Drive Volumes new – volume encryption

 

 

 c: (NTFS on drive 0) 1000.21 GB  210.02 GB free
  

 Network Drives

 ** **




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India
image001.png

Re: [GENERAL] Cannot Run EnterpriseDB Postgresql Installation

[Sachin Srivastava]

Hello,

Can we get a screenshot? Also you can check for any partial installation
logs in your %TEMP% as install-postgresql.log or
bitrock_installer_.log. Check the %TEMP% of the Administrator as well
(If you dont see any logs in the %TEMP% of the logged in user)



On Thu, Aug 23, 2012 at 8:01 PM, javad M mjavad...@gmail.com wrote:

 Hi, i just formatted my machine and installed fresh win7 x64. Also
 installed VS2012 since i do .net developement. In backend i use postgresql
 so downloaded latest postgresql 9.1.5 installation. But, i am not able to
 install. Upon executing file postgresql-9.1.5-1-windows.exe it asks for
 UAC and i say yes then i get a black window and another window named
 console with (Downloads) 1 %  written in it. I have installed old version
 before and also on many clients but this is first time i am encountering
 this issue. There are also no logs anywhere. Please help, as my development
 is fully stranded because of this issue.




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] installation problem with postgres password

[Sachin Srivastava]

You can use an already existing account by specifying --serviceaccount CLI
option.  So you can:

i) Create a new account and then use it.
ii) Use an already existing account.

See if this helps.

On Wed, Jul 18, 2012 at 11:07 AM, KOTa kota.a...@gmail.com wrote:

 yes, many other programs.
 although none of them needed to create an account

 On Wed, Jul 18, 2012 at 6:19 AM, Adrian Klaver adrian.kla...@gmail.com
 wrote:
  On 07/17/2012 03:29 AM, KOTa wrote:
 
  so nobody can help? :(
 
 
  If I followed correctly the problem is:
  1) You are on Windows 7 Home
  2) You have an admin account and Guest account.
  3) You are using the One-Click Installer
  4) Using either account the install fails when it asks for the superuser
  password with the following message.
 
  The password specified does not meet the local or domain policy.
  Check the minimum length, password complexity and password history
  requirements.
 
  My question
  1) Have you installed any other program successfully on this machine?
 
 
  --
  Adrian Klaver
  adrian.kla...@gmail.com
 
 




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] installation problem with postgres password

[Sachin Srivastava]

Could you see anything wrong in the installation log?
(%TEMP%\install-postgresql.log)

On Thu, Jul 12, 2012 at 11:04 AM, KOTa kota.a...@gmail.com wrote:

 postgres user does not exist yet, its a fresh new installation of
 windows 7 Home. New HP laptop.
 there is only my account (admin) and Guest

 i saw on internet someone had similar problem and this was resolved by
 removing HP protection tools tha was messing with policies, but i
 already removed it before.

 On Thu, Jul 12, 2012 at 8:02 AM, raghu ram raghuchenn...@gmail.com
 wrote:
 
 
  On Thu, Jul 12, 2012 at 8:35 AM, KOTa kota.a...@gmail.com wrote:
 
  that is what i though, but i tried many different combinations for
  password, and at least 1 of them should satisfy policy requirements.
  also my windows user password, which is accepted by OS and thus
  satisfies the requirements resulted in same message
 
  i did try to see what policy is active, but i am using win 7 Home
  Premium and i could find a way for this version to see/change
  policies.
  the only thing i found is by running net accounts from command
  prompt. which shows the following:
 
  http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599
 
  and those are very simple password policy which all combinations i used
  satisfy
 
 
  Could you please try to reset the postgres user password in window7
 before
  reinstalling the PostgreSQL. Below link gives more information of
 reseting
  password in windows7
 
  http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
 
  Thanks  Regards,
 
  Raghu Ram
 
  EnterpriseDB Corporation
 
  Blog:http://raghurc.blogspot.in/
 
 
 

 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] question about installation

[Sachin Srivastava]

On Wed, Jul 11, 2012 at 6:28 PM, martin soethof
martinsoet...@hotmail.comwrote:

  Hello
 I have the following situation.
 I used a postgres installer that can choose seperate paths for the normal
 postgres and the data folder.
 I used this because i wanted to share a database on an external hard drive
 between 2 computers.
 I installed it on PC #1, the normal postgres files are on my D drive, the
 data folder and its components are on the portable F drive..
 Tomorrow i will be sitting behind PC #2, how should i install it..
 If i do install it the same way, won't that overwrite the existing data
 folder on the F drive and thus result in loss of data or a corrupt database.
 Or will postgres-installation simply notice i already have a data folder
 there and ask if i want to share this?
 Could you please guide me through the path of how to install postgresql on
 the 2nd computer, so that both computers share their data in the same
 folder..
 I used postgresql 8.4


The installer will not over-write any settings in your data folder and
continue as usual. Its an option where you can give a pre-existing data
folder to a new installation.


 Regards,
 Martin




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

[Sachin Srivastava]

[CCed the list]

On Tue, Jun 12, 2012 at 12:33 PM, Sachin Srivastava 
sachin.srivast...@enterprisedb.com wrote:


 On Tue, Jun 12, 2012 at 12:31 PM, Craig Ringer ring...@ringerc.id.auwrote:

 On 06/11/2012 08:36 PM, Marc Watson wrote:


 *De :*Craig Ringer [mailto:ring...@ringerc.id.au]



 Is there any chance you can get the version of the currently installed
 MSVC++ redistributible(s) on your computer? They're listed in programs and
 features in the control panel.

 I originally had version 10.0.40219 installed in both 32 and 64 bit,
  which gave me the error. I uninstalled these versions just to get around
 the 9.2 beta2 install, which installed 10.0.30319.01.


 OK, so that confirms it. The Pg installer needs to have an updated redist
 bundled when the final version is released, and needs to treate error 5100
 as success.


 I have updated the redist and modified the installer to not treat 5100 as
 error (we already handle 3010 return code properly).

 I am in the process of testing the changes.



 --
 Craig Ringer




 --
 Regards,
 Sachin Srivastava
 EnterpriseDB, India




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] Cannot find installers for 9.2 Beta

[Sachin Srivastava]

Here's the link :
http://www.enterprisedb.com/products-services-training/pgdevdownload


On Tue, May 15, 2012 at 8:01 AM, Basil Bourque basil.l...@me.com wrote:

 Today’s announcement of 9.2 beta said installers were available…
 —
 Get PostgreSQL 9.2 beta, including binaries and installers for Windows,
 Linux and Mac from our download page: http://www.postgresql.org/download
 —

 But I cannot find any installers at all for the beta. Specifically I’d
 like Mac ones, but I don’t see any.

 Can someone point me in the right direction?

 —Basil Bourque



 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general




-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] Does Stackbuilder need username/pwd for the proxy?

[Sachin Srivastava]

On Jan 20, 2012, at 6:56 PM, maripa...@tiscali.it wrote:

 I am a new user, and, as some people already highlighted before me, 
 after having installed Postgres 9.1, the stackbuider is not able to 
 connect to the URL www.postgresql.org/applications-v2.xml. I can reach 
 that page by the browser, however.
 My PC is running windows XP SP2 and it connects to internet through a 
 proxy, which address I have inserted under the  proxy server tab  in 
 the Stack builder main window. 
 I am wondering if the problem could be in the fact that my proxy 
 requires a Username (with domain: something like: domain\username) and 
 a password. They are  specified in the Control panel - Advanced - 
 Password management tab, and I think the browser reads them from there. 
 However for other software (ESRI ARCGIS  Desktop) I had to explicitly 
 specify the username and pwd required by the proxy in a special option. 
 Could this be the case for postGRES too? 
 Thank you

Stackbuilder currently doesn't support authenticated proxies.

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Having Issue Getting the Postgresql Service to Start

[Sachin Srivastava]

On Dec 12, 2011, at 9:00 PM, Sogard, Michael (DPS) wrote:

 We are running Postgresql 9.0 64-bit on a Windows Server 2003 machine. 
 Whenever we try to start the postgresql-x64-9.0 service, we eventually get 
 the error “The postgresql-x64-9.0 service on Local Computer started and 
 stopped.” The user account trying to start the service has administrator 
 rights on both the server and the Postrgesql folders. Does anyone have any 
 clues as to why this is happening? Thanks!

Anything in the windows event logs? How did you register the service?

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] password

[Sachin Srivastava]

Hello,

Installation of postgresql requires you to enter a password for the user 
'postgres'.

 i) If the user 'postgres' is not there, it will create it and set the password 
to whatever you have provided,
 ii) If the user 'postgres' is already existing, then you have to give its 
password to move further in the installation.

You can use any account other that 'postgres' by giving CLI option 
'---serviceaccount username'. See --help for more details.

In case you dont remember the password you set for user 'postgres' then you can 
change the same via Right Click My Computer--Manage- Users.. 

You said it rejects the password.  When ? 

And windows user are most welcome here.


On Feb 21, 2011, at 7:40 AM, Roedy Green wrote:

 I gave Postgre a password during install.  However, it always rejects
 it. I tried uninstalling, deleting all files, and reinstalling. Same
 thing.  It complains about user roedy (my windows id). It seems to
 me the default user is supposed to be postgres not Roedy.  Perhaps
 that is the source of the problem. I can't find anything relevant in
 the docs.
 
 The docs talk about installing on Unix by compiling C source.  I have
 Windows 7 64 bit. I get the feeling Windows users are unwelcome.
 -- 
 Roedy Green Canadian Mind Products
 http://mindprod.com
 Refactor early. If you procrastinate, you will have
 even more code to adjust based on the faulty design.
 .
 
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

[Sachin Srivastava]

The postgres account created on your OS is locked account (without any 
password) for security reasons. The password asked during installation is your 
database superuser password (used to connect to database).
Thus on your MAC you can login to postgres account as sudo su postgres.


On Feb 13, 2011, at 11:27 PM, Maximilian Tyrtania wrote:

 Just upgraded my 8.4.2 installation to 9.0.3 on Mac OS 10.6 using the 
 Enterprise one-click installer. Everything went smoothly, except:
 
 The installer asked me for the postgres password, but PG wouldn't accept it 
 later on. I'm pretty sure i didn't mistype it. Have seen this a number of 
 times on different machines. Had to change the password via the passwd 
 utility. Anyone else seen this? 
 
 Maximilian Tyrtania Software-Entwicklung
 Dessauer Str. 6-7
 10969 Berlin
 http://www.contactking.de
 
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

[Sachin Srivastava]

On Feb 14, 2011, at 4:42 AM, Basil Bourque wrote:

 To be clear about the 2 passwords involved with Postgres on your Mac:
 
 • The installer asks for your usual Mac admin account password, to get 
 permission for 2 operations: (1) to install stuff on your computer and (2) to 
 create a special Unix user account named (by default) 'postgres'.
 
 The actual disk files that make up your databases, the files containing your 
 data, are stored in a folder owned by that 'postgres' user rather than your 
 normal Mac user account. The reason is security: If your usual user account 
 is compromised, at least your data files remain behind the wall of that other 
 user.
 
 • The installer prompts you to create a password for that 'postgres' user. 
Just to be clear here, the password is not for the OS user 'postgres' but 
database superuser 'postgres'.
 
 Make it a good password (long, use digits etc. to avoid being simply 
 dictionary words).
 
 When you run the 'pgAdmin' app, it will prompt you for that 'postgres' 
 password to connect to the database server as that 'postgres' user.
 
 --Basil Bourque
 
 On Feb 13, 2011, at 10:46, Sachin Srivastava wrote:
 
 The postgres account created on your OS is locked account (without any 
 password) for security reasons. The password asked during installation is 
 your database superuser password (used to connect to database).
 Thus on your MAC you can login to postgres account as sudo su postgres.
 
 
 On Feb 13, 2011, at 11:27 PM, Maximilian Tyrtania wrote:
 
 Just upgraded my 8.4.2 installation to 9.0.3 on Mac OS 10.6 using the 
 Enterprise one-click installer. Everything went smoothly, except:
 
 The installer asked me for the postgres password, but PG wouldn't accept it 
 later on. I'm pretty sure i didn't mistype it. Have seen this a number of 
 times on different machines. Had to change the password via the passwd 
 utility. Anyone else seen this? 
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] plperl.dll on windows with postgresql 9.0

[Sachin Srivastava]

I can find the plperl.dll in the lib folder of my installation (Windows 7 32 
bit).
How did you installed the postgresql-9.0.3? 

On Feb 6, 2011, at 10:38 PM, Robert Fitzpatrick wrote:

 I am upgrading a Windows install for a client of mine from 8.2.x to
 9.0.3 and understand the pginstaller does not provide plperl for this
 version. ActivePerl 5.8 was already installed and after uninstalling 8.2
 and installing 9.0.3, there is no plperl.dll in the lib folder. I
 thought this was due to the older version, so I uninstall Postgres and
 ActivePerl, restarted, downloaded and installed latest ActivePerl 5.12,
 restarted and re-installed Postgres to still not find the dll. How do I
 get the lib to install? I did a google and find perhaps 5.12 does not
 work (at least during beta)?
 
 http://postgresql.1045698.n5.nabble.com/BUG-5601-cannot-create-language-plperl-td2264970.html
 
 Can someone help with how to get plperl module installed or confirm the
 version required? I am installing on Windows 2003 server. Unfortunately
 I never installed Postgres on Windows prior to the pginstaller. Is there
 a plperl package that I need to install similar to Unix?
 
 Thanks.
 --
 Robert rob...@webtent.org
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Installation Issue of PostgresPlus-9.0

[Sachin Srivastava]

Install termcap (http://ftp.gnu.org/gnu/termcap/)

Add --enable-install-termcap configure option while running configure.


On Feb 2, 2011, at 3:29 PM, Adarsh Sharma wrote:

 I add one more thing after researching i find that this a bug and the 
 solution is to install libtermcap library solves this problem.
 
 I followed the below steps :
 sudo apt-get install gcc
 sudo apt-get install libgcc1
 sudo apt-get install g++
 sudo apt-get install cpp
 sudo apt-get install ncurses-base
 sudo apt-get install ncurses-bin
 sudo apt-get install ncurses-term
 sudo apt-get install libncurses5
 
 (and most importantly)
 sudo apt-get install libncurses5-dev
 
 
 But still I face the same issue.
 
 Any comments.
 
 
 
 
 
 Adarsh Sharma wrote:
 Dear all,
 
 I am trying to install postgresplus on a Ubuntu10.4 based system.
 I  got a problem after installation when i issued the below command :
 
 root@S10-MySQL:/opt/PostgresPlus/9.0SS# bin/psql -Upostgres
 Password for user postgres:
 psql (9.0.2)
 Type help for help.
 
 Cannot read termcap database;
 using dumb terminal settings.
 Aborted
 root@S10-MySQL:/opt/PostgresPlus/9.0SS# ls -ls
 
 I followed the same steps as in PostgrePlus-8.4 but don't know how it occurs.
 Please help me to find the reason.
 My startup.log says :
 
 2011-02-02 09:02:17 GMT LOG:  could not recognize system time zone
 2011-02-02 09:02:17 GMT DETAIL:  The PostgreSQL time zone will be set to 
 Etc/GMT-5.
 2011-02-02 09:02:17 GMT HINT:  You can specify the correct timezone in 
 postgresql.conf.
 2011-02-02 09:05:47 GMT LOG:  could not recognize system time zone
 2011-02-02 09:05:47 GMT DETAIL:  The PostgreSQL time zone will be set to 
 Etc/GMT-5.
 2011-02-02 09:05:47 GMT HINT:  You can specify the correct timezone in 
 postgresql.conf.
 
 
 
 
 
 Thanks  Regards
 Adarsh Sharma
 
 
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] How to install in windows 2000

[Sachin Srivastava]

Installing any of 9.0 or 8.3 what exact error you get? Can you attach the 
installation log file (%TEMP%\install-postgresql.log)?

On Nov 18, 2010, at 8:19 PM, Andrus wrote:

 Installing from enterprisedb site from msi packages in Windows 2000:
 
 Installing 9.0 latest returns error about missing entry point.
 Intalling 8.3 latest  does not create db cluster. Running createdb shows 
 error message that postgres is not running.
 
 How to install postgresql ( 8.1 or above) in Windows 2000 in easy way?
 It is for use only in the same computer.
 
 Andrus. 
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Help with Stack Builder

[Sachin Srivastava]

Can you open the specified URL in the browser?

On Nov 12, 2010, at 4:24 PM, ray wrote:

 I just downloaded 9.0 onto my laptop and desktop Windows XP
 machines. .Nether one could run the stack builder.  Windows would
 fault any time I tried to run it.  I tried inputing the proxy server
 but that did not
 help.  This was at work where there is a proxy server.  I tried this
 at homw wiith the laptop but got the same error:
 Could not open the specified URL.
 
 ray
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Run postgresql\9.0\data on a RAID-1 disk on my Local Area Network (LAN)

[Sachin Srivastava]

Hello,

From the logs it seems, the initdb was successful, However, the database
server failed to start afterwards. Can you manually start the database
service? If yes try installing PostGIS from stackbuilder after that.
If no, then whats the error message you are getting?


2010/11/9 Anders Söderman anders.soder...@gisassistans.se

  Hello

 I´ve tried many times to install in different ways. Hopefully I removed all
 files from previous installations before trying again.
 I don´t know if the logs are useful. I´ve tried to understand what the log
 says without result.
 I think, right now, that I should do an PostgreSQL/PostGIS installation
 using all default values and then try to change the postgresql\9.0\data 
 folder
 to the RAID-1 LAN-disk. Thanks Anders Söderman Stockholm Sweden
  --

 *From:* pgsql-general-ow...@postgresql.org [mailto:
 pgsql-general-ow...@postgresql.org] *On Behalf Of *Sachin Srivastava
 *Sent:* den 8 november 2010 08:56

 *To:* Anders Söderman
 *Cc:* pgsql-general@postgresql.org
 *Subject:* Re: [GENERAL] Run postgresql\9.0\data on a RAID-1 disk on my
 Local Area Network (LAN)



 Hello,

 On Nov 7, 2010, at 1:22 PM, Anders Söderman wrote:



  Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL
 to store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2
  environment.

 In the Setup Wizard I accept C:\Program\PostgreSQL\9.0

 and I change C:\Program\PostgreSQL\9.0\data to either
  //R1/aa_db/PostgreSQL\9.0\data or P:\PostgreSQL\9.0\data where   P:\  =
  //R1/aa_db/   on the computer from which I´m installing Postgresql.

 R1 is the name of the Netgear disk och aa_db the Share/folder I want to
 store the PostgreSQL data in.



 I have tried every possible combination I can think of. Sometimes the
 installation seems to work, but in pgAdmin “Connected?” says “No”. If I try
 to install PostGIS afterwards I crashes during the EnterpriseDB Stackbuilder
 installation.
 After several hours I can´t find any useful information in the manual or on
 the FORUMs.
 If anybody could give me a hint where I should look I would be so happy.
 Regards Anders Söderman Stockholm Sweden



 What exactly is the error message you get while installing PostgreSQL? Can
 you attach the installation log (%TEMP%\install-postgresql.log) or
 (%TEMP%\bitrock_installer_some number.log).

 --

 Regards,

 Sachin Srivastava

 EnterpriseDB http://www.enterprisedb.com, the Enterprise 
 PostgreSQLhttp://www.enterprisedb.com
  company.






-- 
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: [GENERAL] Run postgresql\9.0\data on a RAID-1 disk on my Local Area Network (LAN)

[Sachin Srivastava]

Hello,
On Nov 7, 2010, at 1:22 PM, Anders Söderman wrote:

 Hello – I´m trying to install PostgreSQL and PostGIS ”asking” PostgreSQL to 
 store data on my new Netgear NAS Duo LAN-disk in a Windows XP sp2  
 environment. 
 
 In the Setup Wizard I accept C:\Program\PostgreSQL\9.0
 and I change C:\Program\PostgreSQL\9.0\data to either  
 //R1/aa_db/PostgreSQL\9.0\data or P:\PostgreSQL\9.0\data where   P:\  =  
 //R1/aa_db/   on the computer from which I´m installing Postgresql.
 R1 is the name of the Netgear disk och aa_db the Share/folder I want to store 
 the PostgreSQL data in.
  
 I have tried every possible combination I can think of. Sometimes the 
 installation seems to work, but in pgAdmin “Connected?” says “No”. If I try 
 to install PostGIS afterwards I crashes during the EnterpriseDB Stackbuilder 
 installation. 
 After several hours I can´t find any useful information in the manual or on 
 the FORUMs. 
 If anybody could give me a hint where I should look I would be so happy. 
 Regards Anders Söderman Stockholm Sweden
What exactly is the error message you get while installing PostgreSQL? Can you 
attach the installation log (%TEMP%\install-postgresql.log) or 
(%TEMP%\bitrock_installer_some number.log).
  
  
  
  

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] PostgreSQL server not starting.

[Sachin Srivastava]

Can you send the installation log (%TEMP%\install-postgresql.log)?

In case, Have you used the uninstaller to uninstall the previous instance or 
manually removed the directories?

On Sep 30, 2010, at 12:53 PM, Vishnu S. wrote:

 Hi,
  
  
 I have uninstalled the PostgreSQL 8.4 and removed the related directories 
 from the system. Again I have installed the PostgreSQL 8.4 on the same 
 folder. Now the PostgreSQL server is not starting. When I tried to start the 
 postgreSQL service from the Windows Service manager, the following message is 
 shown.
  
 “The PostgreSQL Server 8.4 service on Local Computer started and then 
 stopped.  Some services stop automatically if they have no work to do, for 
 example, the Performance Logs and Alerts service”.
  
 Host :- localhost
 Port :- 5432
 Database :- postgres
  
  
  
  
 Thanks  Regards,
 Vishnu S
  

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] PostgreSQL server not starting.

[Sachin Srivastava]

[Please keep the thread on the mailing list]

From the logs,  the initdb is successful but there were some error while 
creating the postgres service. I believe you are not using the latest 8.4.4 
installer as that installer has some detailed logging which is helpful in 
realizing where exactly is the problem.

Though since you have the initdb successful, you can manually create the 
service using pg_ctl command (See: 
http://www.postgresql.org/docs/8.4/static/app-pg-ctl.html)

On Sep 30, 2010, at 2:10 PM, Vishnu S. wrote:

 Hi,
  
 Please find the attached PostgreSQL installation log file.
 I have used Uninstaller to uninstall the PostgreSQL and then the data 
 directory is removed manually.
  
  
  
  
 Thanks  Regards,
 Vishnu S
  
 From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] 
 Sent: Thursday, September 30, 2010 1:41 PM
 To: Vishnu S.
 Cc: pgsql-general@postgresql.org
 Subject: Re: PostgreSQL server not starting.
  
 Can you send the installation log (%TEMP%\install-postgresql.log)?
  
 In case, Have you used the uninstaller to uninstall the previous instance or 
 manually removed the directories?
  
 On Sep 30, 2010, at 12:53 PM, Vishnu S. wrote:
 
 
 Hi,
  
  
 I have uninstalled the PostgreSQL 8.4 and removed the related directories 
 from the system. Again I have installed the PostgreSQL 8.4 on the same 
 folder. Now the PostgreSQL server is not starting. When I tried to start the 
 postgreSQL service from the Windows Service manager, the following message is 
 shown.
  
 “The PostgreSQL Server 8.4 service on Local Computer started and then 
 stopped.  Some services stop automatically if they have no work to do, for 
 example, the Performance Logs and Alerts service”.
  
 Host :- localhost
 Port :- 5432
 Database :- postgres
  
  
  
  
 Thanks  Regards,
 Vishnu S
  
  
 --
 Regards,
 Sachin Srivastava
 EnterpriseDB, the Enterprise Postgres company.
  
 install-postgresql.log

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] Slony-I installation Help

[Sachin Srivastava]

What are the values of:

HKEY_CURRENT_USER\Software\PostgreSQL\StackBuilder\HTTP Proxy Host and
HKEY_CURRENT_USER\Software\PostgreSQL\StackBuilder\HTTP Proxy Port ?

Can you make sure whether both of them matches with the correct values?

On Sep 29, 2010, at 10:27 AM, Vishnu S. wrote:

 Hi,
  
 Yes, using some proxy. The XML file mentioned in the URL can be opened in 
 browser. Even after setting the proxy values mentioned in the IE 
 (Tools-Internet Options  -Connections-LAN settings), the same message box 
 is shown.
  
 image001.png
  
  
 Thanks  Regards,
 Vishnu S
  
 From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] 
 Sent: Tuesday, September 28, 2010 11:15 AM
 To: Vishnu S.
 Cc: pgsql-general@postgresql.org
 Subject: Re: [GENERAL] Slony-I installation Help
  
 [Please keep the thread on the mailing list]
  
 For the stackbuilder, are you behind any proxy? Can you open the url 
 mentioned in the error message via your browser? You can set the appropriate 
 proxy values on the first page of stackbuilder.
  
 Slony-I Path will be where your slony binaries reside.
  
 On Sep 28, 2010, at 9:24 AM, Vishnu S. wrote:
 
 
 Hi,
  
 When I tried to install Stackbuilder the following error message is shown. 
 How can I recover from this?
  
 image001.png
  
 I have already set the Slony-I path as “C:\Program 
 Files\PostgreSQL\8.4\share”. Is this path is correct?
  
  
  
 Thanks  Regards,
 Vishnu S
  
 From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] 
 Sent: Monday, September 27, 2010 7:47 PM
 To: Vishnu S.
 Cc: pgsql-general@postgresql.org
 Subject: Re: [GENERAL] Slony-I installation Help
  
 Hello,
  
 If you have used EnterpriseDB's One Click Installer to install PostgreSQL 
 8.4, then you can use Stackbuilder to install Slony for PG 8.4.
  
 For making Slony work with pgAdmin, you need to put the Slony-I path in the 
 options file of pgAdmin. Open File Menu -- Options -- [In General Tab] Set 
 Slony-I path.
  
  
 On Sep 27, 2010, at 3:54 PM, Vishnu S. wrote:
 
 
 
 Hi,
 I have downloaded slony-I(slony-I-2.0.2R-pg84.zip)  from  the site 
 http://developer.pgadmin.org/~hiroshi/Slony-I/. But when I tried to create a 
 new  Replication cluster using PgAdmin(After doing all other steps mentioned 
 in http://www.pgadmin.org/docs/1.8/slony-example.html ) the ‘OK’ button in 
 the Dialog is in disabled state. Also a message  ‘Slony-I creation scripts 
 not available;only joining possible’. When I tried to join the cluster ,it 
 also get failed because no cluster is created at all.
 Please provide the address from which a Complete Installation package for 
 Slony-I, compatible with the PostgreSQL 8.4 will be available.
 Please note that I am using Windows XP.
  
  
  
 Thanks  Regards,
 Vishnu S
  
  
 --
 Regards,
 Sachin Srivastava
 EnterpriseDB, the Enterprise Postgres company.
  
  
 --
 Regards,
 Sachin Srivastava
 EnterpriseDB, the Enterprise Postgres company.
  

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] Slony-I installation Help

[Sachin Srivastava]

Hello,

If you have used EnterpriseDB's One Click Installer to install PostgreSQL 8.4, 
then you can use Stackbuilder to install Slony for PG 8.4.

For making Slony work with pgAdmin, you need to put the Slony-I path in the 
options file of pgAdmin. Open File Menu -- Options -- [In General Tab] Set 
Slony-I path.


On Sep 27, 2010, at 3:54 PM, Vishnu S. wrote:

 Hi,
 I have downloaded slony-I(slony-I-2.0.2R-pg84.zip)  from  the site 
 http://developer.pgadmin.org/~hiroshi/Slony-I/. But when I tried to create a 
 new  Replication cluster using PgAdmin(After doing all other steps mentioned 
 in http://www.pgadmin.org/docs/1.8/slony-example.html ) the ‘OK’ button in 
 the Dialog is in disabled state. Also a message  ‘Slony-I creation scripts 
 not available;only joining possible’. When I tried to join the cluster ,it 
 also get failed because no cluster is created at all.
 Please provide the address from which a Complete Installation package for 
 Slony-I, compatible with the PostgreSQL 8.4 will be available.
 Please note that I am using Windows XP.
  
  
  
 Thanks  Regards,
 Vishnu S
  

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] Slony-I installation Help

[Sachin Srivastava]

[Please keep the thread on the mailing list]

For the stackbuilder, are you behind any proxy? Can you open the url mentioned 
in the error message via your browser? You can set the appropriate proxy values 
on the first page of stackbuilder.

Slony-I Path will be where your slony binaries reside.

On Sep 28, 2010, at 9:24 AM, Vishnu S. wrote:

 Hi,
  
 When I tried to install Stackbuilder the following error message is shown. 
 How can I recover from this?
  
 image001.png
  
 I have already set the Slony-I path as “C:\Program 
 Files\PostgreSQL\8.4\share”. Is this path is correct?
  
  
  
 Thanks  Regards,
 Vishnu S
  
 From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] 
 Sent: Monday, September 27, 2010 7:47 PM
 To: Vishnu S.
 Cc: pgsql-general@postgresql.org
 Subject: Re: [GENERAL] Slony-I installation Help
  
 Hello,
  
 If you have used EnterpriseDB's One Click Installer to install PostgreSQL 
 8.4, then you can use Stackbuilder to install Slony for PG 8.4.
  
 For making Slony work with pgAdmin, you need to put the Slony-I path in the 
 options file of pgAdmin. Open File Menu -- Options -- [In General Tab] Set 
 Slony-I path.
  
  
 On Sep 27, 2010, at 3:54 PM, Vishnu S. wrote:
 
 
 Hi,
 I have downloaded slony-I(slony-I-2.0.2R-pg84.zip)  from  the site 
 http://developer.pgadmin.org/~hiroshi/Slony-I/. But when I tried to create a 
 new  Replication cluster using PgAdmin(After doing all other steps mentioned 
 in http://www.pgadmin.org/docs/1.8/slony-example.html ) the ‘OK’ button in 
 the Dialog is in disabled state. Also a message  ‘Slony-I creation scripts 
 not available;only joining possible’. When I tried to join the cluster ,it 
 also get failed because no cluster is created at all.
 Please provide the address from which a Complete Installation package for 
 Slony-I, compatible with the PostgreSQL 8.4 will be available.
 Please note that I am using Windows XP.
  
  
  
 Thanks  Regards,
 Vishnu S
  
  
 --
 Regards,
 Sachin Srivastava
 EnterpriseDB, the Enterprise Postgres company.
  

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] Windows 2003 server installation issue

[Sachin Srivastava]

On 8/18/10 7:42 AM, Vikram Patil wrote:

Joshua,

  Thanks for reply. But I tried 8.4.4 and it still doesn't work with local 
administrator account on windows 2003 . I don't want to create additional 
postgres user to start service on windows rather I want to use my currently 
logged in user. User can be administrator or non-administrator.
See --serviceaccount and --servicepassword CLI options to the installer, 
you can provide any existing user with its corresponding password as the 
postgres service owner.



I am getting an error code 5 in event viewer when I try to use administrator 
as service user.Before attempting that I used initdb to create
Data directory with same user

Thanks  Regards,
Vikram



-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Saturday, August 14, 2010 9:32 AM
To: Vikram Patil
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows 2003 server installation issue

On Fri, 2010-08-13 at 23:49 -0700, Vikram Patil wrote:
   

Hello Folks,



I am facing an issue starting postgresql using windows service when
my user belongs to Administrator group.



I applied patch from following thread to 8.4.1 source code and it
seems to be working with every windows operating system except Windows
2003 .

 

There is a reason the community provides binary packages. The idea that
you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4.


Sincerely,

Joshua D. Drake


   



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] postgres-8.4SS, pg_dump from macosx-10.6 has ssl handshake error 26% in

[Sachin Srivastava]

the latest enterprisedb standard server is only 8.4.1 (New! 13-Oct-09) :-)
   
By using the StackBuilder Plus application, you can upgrade your server 
to 8.4.4.
   


--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Silent installer in Windows

[Sachin Srivastava]

Use CLI option,  --unattendedmodeui none

On 6/15/10 1:17 PM, M. Bashir Al-Noimi wrote:

Sorry for disturbing.
I want to run One-Click completely silent, how I can do it?

PS
I run the following but it always shows installing progress dialog:
postgresql-8.4.4-1-windows --install_runtimes 0 --servicepassword root 
--unattendedmodeui minimal --mode unattended --prefix c:\pg-8.4 
--datadir c:\pgData --superpassword admin


On Mon, Jun 14, 2010 at 9:55 PM, Sachin Srivastava 
sachin.srivast...@enterprisedb.com 
mailto:sachin.srivast...@enterprisedb.com wrote:


In the One-Click Installer for PostgreSQL use the CLI option,
--mode unattended for more options see --help.


On 6/15/10 12:45 AM, M. Bashir Al-Noimi wrote:


Hi folks,


I want to install ps silentely in Windows how I can do it? what's
needed arguments?


Sorry I'm still a newbie


Ps

I read pginstaller doc about silent installing
http://pginstaller.projects.postgresql.org/silent.html but I
noticed that pginstaller no longer available as mentioned in its
home page.

-- 
Best Regards

Muhammad Bashir Al-Noimi
My Blog:http://mbnoimi.net
   




   



-- 
Regards,

Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise
Postgres http://www.enterprisedb.com company.




--
Best Regards
Muhammad Bashir Al-Noimi
My Blog: http://mbnoimi.net




--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Silent installer in Windows

[Sachin Srivastava]

In the One-Click Installer for PostgreSQL use the CLI option, --mode 
unattended for more options see --help.


On 6/15/10 12:45 AM, M. Bashir Al-Noimi wrote:


Hi folks,


I want to install ps silentely in Windows how I can do it? what's 
needed arguments?



Sorry I'm still a newbie


Ps

I read pginstaller doc about silent installing 
http://pginstaller.projects.postgresql.org/silent.html but I noticed 
that pginstaller no longer available as mentioned in its home page.


--
Best Regards
Muhammad Bashir Al-Noimi
My Blog:http://mbnoimi.net
   




   



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Unable to install pg in Win (MVR error)

[Sachin Srivastava]

When you run the installer without specifying "--install_runtimes 0",
What is the error code returned by the MS VC++ Runtime installer. You
can check that in the log file
(%TEMP%\bitrock_installer_somenumber.log). 

On 6/15/10 2:17 AM, M. Bashir Al-Noimi wrote:

  
On 14/06/2010 08:43 , Dave Page wrote:
  

On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir
Al-Noimi ad...@mbnoimi.net wrote:

  
  Hi All,
  
  
  As shown in the
following screenshot I couldn't install pg in Windows because it
couldn't install Microsoft VC++ Runtime!
  
  
  How I can fix
this
issue?
  



If you already have the right version (VC++ 2005 SP1) of the
runtimes installed, you could run the installer with the option:


--install_runtimes 0


to skip the runtime installation. 

  
I tried to run pg installer with "--install_runtimes 0" but I got
warning message tell me that database cluster failed does this problem
related to wrong MVR?
  
if yes how I can fix this issue? do I need to remove installed MVR (I
didn't find it in Add or Remove Programs list)?
  
  
  
PS.
After finishing the installer I noticed that pg services didn't start
at all although I successfully installed pg on another PC!
  
  -- 
Best Regards
Muhammad Bashir Al-Noimi
My Blog: http://mbnoimi.net
  
  


  



-- 
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] uppdate from postgersql 8.3.7 to 8.4.4

[Sachin Srivastava]

On 5/25/10 3:08 PM, Malm Paul wrote:

Hi,
I'm trying to update postgresql ver 8.7.3 to 8.4.4
The One-Click installer will not upgrade 8.3.7 to 8.4.4 rather it will 
create a parallel 8.4.4 installation as both have different major versions.
At the end of the installation when trying to styart the database 
server I get the following error meassage: Problem running 
post-install step. Installation may not complete correctly. Failed to 
start the database server
And when I try to start the server manually I get the following 
console print out:

Start DoCmd(net postgresql-8.4)...
System error 1069 has occured.
The service did not start due to a logon failure.
Failed to start the database server.

Please attach %TEMP%\install-postgresql.log, which will help to analyze 
things more clearly.

I've checked the 8.4\Data folder and it is empty.
Is ther anyone who has a solution for this?
Kind regards,
Paul



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] can't install postgres 8.4 on windows 2003 server

[Sachin Srivastava]

Hi,

What happens if you register the service with pg_ctl directly as:

Path to PGHOME\bin\pg_ctl.exe  register -N ServiceName -U Username 
-P Password -D Path to DataDirectory -w



On 5/24/10 11:58 PM, ritas wrote:

Thanks Sachin for your response. I have attached the install-postgresql.log.
Also, if it helps, I have the following error in my event viewer: pg_ctl:
could not register service postgresql-8.4: error code 0
The postgres service is not listed under services.

Thanks.

http://old.nabble.com/file/p28660078/install-postgresql.log
install-postgresql.log

Sachin Srivastava-2 wrote:
   

On 5/24/10 7:52 PM, ritas wrote:
 

Hi,

When I try to install postgres 8.4 on windows server 2003, I get the
following error: A non-fatal error occurred whilst loading database
modules. Please check the installation logs in
C:/docssetttings/user/local
settings/temp for details. The log file doesn't have any error, but it
looks like it stopped in the middle. Also, it doesn't install the
postgres
service. I have attached the log file. Any help would be greatly
appreciated. Thanks.

http://old.nabble.com/file/p28657511/bitrock_installer_1004serverlog.log
bitrock_installer_1004serverlog.log

   

There must be a log file with name install-postgresql.log in the %TEMP%
directory.

--
Regards,
Sachin Srivastava
EnterpriseDBhttp://www.enterprisedb.com, the Enterprise Postgres
http://www.enterprisedb.com  company.


 
   



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] can't install postgres 8.4 on windows 2003 server

[Sachin Srivastava]

On 5/24/10 7:52 PM, ritas wrote:

Hi,

When I try to install postgres 8.4 on windows server 2003, I get the
following error: A non-fatal error occurred whilst loading database
modules. Please check the installation logs in C:/docssetttings/user/local
settings/temp for details. The log file doesn't have any error, but it
looks like it stopped in the middle. Also, it doesn't install the postgres
service. I have attached the log file. Any help would be greatly
appreciated. Thanks.

http://old.nabble.com/file/p28657511/bitrock_installer_1004serverlog.log
bitrock_installer_1004serverlog.log
   
There must be a log file with name install-postgresql.log in the %TEMP% 
directory.


--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] 1-Click installer problems

[Sachin Srivastava]

There is a CLI option --serviceaccount username which a user can use 
to make any user the owner of postgres service and data files.


Also, if you choose 'postgres' as the service account and the 'postgres' 
user doesn't exist. The installer will create postgres as a 'locked' 
user account. Thats the reason you dont see 'postgres' listed as any 
other normal user. These steps were taken to enhance the security of the 
data folder.


Again, anytime a user is free to use any account as the service account 
and not use 'postgres'.


On 4/2/10 12:37 PM, John Gage wrote:

Then I don't understand why the installer doesn't do the same thing.

Or, in the alternative, why it doesn't ask you what you want these 
parameters to be.


I would say that, typically, someone installing postgres does it, 
conceivably, as root or, more likely, as a user.


What he or she doesn't do is install it as user 'postgres'.

Yet, that is what the one-click installer does.  I do not believe that 
this is intuitive.  What is more, gratuitiously adding a user to the 
system doesn't seem to make a whole lot of sense.


In addition, all other one-click installations on the Mac either don't 
ask for root privileges, because they don't need them, or ask for 
them, but still install under the current user.  Some installations 
will even ask whether you want the application usable by all users of 
the machine or just you.


But none, repeat none, create a new user.

What is more, through standard unix commands such as who or cat 
/etc/passwd, I cannot find the user 'postgres' on my machine...even 
though he is the owner of the Postgres data files...on my machine.


There's the rub.  'postgres' owns files...my files...on my machine, 
yet he is not on my machine.  Not good.


I should add that I am an accolyte of Postgres and am only raising 
this (possible) issue in the most positive spirit I am capable of.  In 
addition, I think that the people on this list are superb, and the 
responses are unbelievably helpful and accurate.


John


On Apr 2, 2010, at 8:29 AM, John R Pierce wrote:


John Gage wrote:

The 8.4.2 documentation says:

The default user name is your Unix user name, as is the default 
database name.


when you as a user connect to the database server the commands like 
psql, pg_dump, etc all use your unix username as the default for the 
database username, and your username as teh default for the database 
name, unless you specify a different user and/or database on hte 
command line.









--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] 1-Click installer problems

[Sachin Srivastava]

Thats what i get:

edbs-MacBook:~ sachin$ hdiutil attach postgresql-8.4.3-1-osx.dmg
expected   CRC32 $F9B026D4
/dev/disk1  Apple_partition_scheme
/dev/disk1s1Apple_partition_map
/dev/disk1s2Apple_HFS  
/Volumes/PostgreSQL 8.4.3-1
edbs-MacBook:~ sachin$ sudo /Volumes/PostgreSQL\ 
8.4.3-1/postgresql-8.4.3-1-osx.app/Contents/MacOS/installbuilder.sh --help

Password:
PostgreSQL 8.4
Usage:

 --help Display the list of valid options

 --version  Display product information

 --optionfile optionfile  Installation option file
Default:

 --unattendedmodeui unattendedmodeui Unattended Mode UI
Default: none
Allowed: none minimal minimalWithDialogs

 --debuglevel debuglevel  Debug information level of verbosity
Default: 2
Allowed: 0 1 2 3 4

 --mode mode  Installation mode
Default: qt
Allowed: qt osx text unattended

 --debugtrace debugtrace  Debug filename
Default:

 --installer-language installer-language Language selection
Default:
Allowed: en es

 --extract-only extract-only
Default: 0

 --superaccount superaccount  Sets the user name of the database 
superuser. Defaults to 'postgres'.

Default: postgres

 --servicename servicenameservicename.description
Default: postgresql-8.4

 --serviceaccount serviceaccount Sets the operating system user 
account that owns the server process. Defaults to 'postgres'.

Default: postgres

 --create_shortcuts create_shortcuts Specifies whether or not menu 
shortcuts should be created.

Default: 1

 --prefix prefix  Installation Directory
Default: /Library/PostgreSQL/8.4

 --datadir datadirData Directory
Default: /Library/PostgreSQL/8.4/data

 --superpassword superpassword Password
Default:

 --serverport serverport  Port
Default: 5432

 --locale locale  Locale
Default:

 --install_plpgsql install_plpgsql Install pl/pgsql in template1 
database?

Default: 1


On 4/2/10 1:14 PM, John Gage wrote:
There is a CLI option where?  Forgive my ignorance, please.  Does it 
appear in the one-click installer?


John


On Apr 2, 2010, at 9:19 AM, Sachin Srivastava wrote:

There is a CLI option --serviceaccount username which a user can 
use to make any user the owner of postgres service and data files.


Also, if you choose 'postgres' as the service account and the 
'postgres' user doesn't exist. The installer will create postgres as 
a 'locked' user account. Thats the reason you dont see 'postgres' 
listed as any other normal user. These steps were taken to enhance 
the security of the data folder.


Again, anytime a user is free to use any account as the service 
account and not use 'postgres'.


On 4/2/10 12:37 PM, John Gage wrote:

Then I don't understand why the installer doesn't do the same thing.

Or, in the alternative, why it doesn't ask you what you want these 
parameters to be.


I would say that, typically, someone installing postgres does it, 
conceivably, as root or, more likely, as a user.


What he or she doesn't do is install it as user 'postgres'.

Yet, that is what the one-click installer does.  I do not believe 
that this is intuitive.  What is more, gratuitiously adding a user 
to the system doesn't seem to make a whole lot of sense.


In addition, all other one-click installations on the Mac either 
don't ask for root privileges, because they don't need them, or ask 
for them, but still install under the current user.  Some 
installations will even ask whether you want the application usable 
by all users of the machine or just you.


But none, repeat none, create a new user.

What is more, through standard unix commands such as who or cat 
/etc/passwd, I cannot find the user 'postgres' on my machine...even 
though he is the owner of the Postgres data files...on my machine.


There's the rub.  'postgres' owns files...my files...on my machine, 
yet he is not on my machine.  Not good.


I should add that I am an accolyte of Postgres and am only raising 
this (possible) issue in the most positive spirit I am capable of.  
In addition, I think that the people on this list are superb, and 
the responses are unbelievably helpful and accurate.


John


On Apr 2, 2010, at 8:29 AM, John R Pierce wrote:


John Gage wrote:

The 8.4.2 documentation

Re: [GENERAL] 1-Click installer problems

[Sachin Srivastava]

Yes you need to re-install.. (uninstall and install again).
You can point the new installation to the old data directory if you want..

On 4/2/10 4:25 PM, John Gage wrote:

I am incredibly interested in this.

In the first place, I did not load postgres from the command line as 
you do here.  I double-clicked.  I also do not remember seeing the 
usage options.


That being said, now that I have downloaded and installed the system, 
how can I change:




 --serviceaccount serviceaccount Sets the operating system user 
account that owns the server process. Defaults to 'postgres'.

Default: postgres


Or, in fact, must I re-install to change this?  It looks like I have 
to re-install.


Thank you very much for responding to my questions.  I truly 
appreciate it.  Your support is welcome and superb.


John





On Apr 2, 2010, at 9:52 AM, Sachin Srivastava wrote:


Thats what i get:

edbs-MacBook:~ sachin$ hdiutil attach postgresql-8.4.3-1-osx.dmg
expected   CRC32 $F9B026D4
/dev/disk1  Apple_partition_scheme
/dev/disk1s1Apple_partition_map
/dev/disk1s2Apple_HFS  
/Volumes/PostgreSQL 8.4.3-1
edbs-MacBook:~ sachin$ sudo /Volumes/PostgreSQL\ 
8.4.3-1/postgresql-8.4.3-1-osx.app/Contents/MacOS/installbuilder.sh 
--help

Password:
PostgreSQL 8.4
Usage:

 --help Display the list of valid options

 --version  Display product information

 --optionfile optionfile  Installation option file
Default:

 --unattendedmodeui unattendedmodeui Unattended Mode UI
Default: none
Allowed: none minimal minimalWithDialogs

 --debuglevel debuglevel  Debug information level of verbosity
Default: 2
Allowed: 0 1 2 3 4

 --mode mode  Installation mode
Default: qt
Allowed: qt osx text unattended

 --debugtrace debugtrace  Debug filename
Default:

 --installer-language installer-language Language selection
Default:
Allowed: en es

 --extract-only extract-only
Default: 0

 --superaccount superaccount  Sets the user name of the database 
superuser. Defaults to 'postgres'.

Default: postgres

 --servicename servicenameservicename.description
Default: postgresql-8.4

 --serviceaccount serviceaccount Sets the operating system user 
account that owns the server process. Defaults to 'postgres'.

Default: postgres

 --create_shortcuts create_shortcuts Specifies whether or not menu 
shortcuts should be created.

Default: 1

 --prefix prefix  Installation Directory
Default: /Library/PostgreSQL/8.4

 --datadir datadirData Directory
Default: /Library/PostgreSQL/8.4/data

 --superpassword superpassword Password
Default:

 --serverport serverport  Port
Default: 5432

 --locale locale  Locale
Default:

 --install_plpgsql install_plpgsql Install pl/pgsql in template1 
database?

Default: 1


On 4/2/10 1:14 PM, John Gage wrote:
There is a CLI option where?  Forgive my ignorance, please.  Does it 
appear in the one-click installer?


John


On Apr 2, 2010, at 9:19 AM, Sachin Srivastava wrote:

There is a CLI option --serviceaccount username which a user can 
use to make any user the owner of postgres service and data files.


Also, if you choose 'postgres' as the service account and the 
'postgres' user doesn't exist. The installer will create postgres 
as a 'locked' user account. Thats the reason you dont see 
'postgres' listed as any other normal user. These steps were taken 
to enhance the security of the data folder.


Again, anytime a user is free to use any account as the service 
account and not use 'postgres'.


On 4/2/10 12:37 PM, John Gage wrote:

Then I don't understand why the installer doesn't do the same thing.

Or, in the alternative, why it doesn't ask you what you want these 
parameters to be.


I would say that, typically, someone installing postgres does it, 
conceivably, as root or, more likely, as a user.


What he or she doesn't do is install it as user 'postgres'.

Yet, that is what the one-click installer does.  I do not believe 
that this is intuitive.  What is more, gratuitiously adding a user 
to the system doesn't seem to make a whole lot of sense.


In addition, all other one-click installations on the Mac either 
don't ask for root privileges, because they don't

Re: [GENERAL] 1-Click installer problems

[Sachin Srivastava]

If you really want to help and make the installer a better experience, i 
asked for helping me out debug the issue
Run the initcluster.vbs and let us know at what line number you are 
getting the 'Object Required' error message.


But all you replied was : -  I need step by step procedure to install 
it on Vista or Windows 7, I dont want bits and pieces stuff..


And then you expect us to help out. If you really care then help out, 
there is just no point saying, that was working and that's not again and 
again.




If you mean the number of responses, yes it's great.

The reason I posted this in the general newsgroup is because I thought 
others would like to know what's going on. But I think this is a 
newsgroup with a bunch of inflated egos who want to do everything else 
rather than address the problem. A typical open-source group. 
Evangelizing PGSQL was a mistake.





Thanks for all your help and good luck to everyone!
-n.




--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Small install (w/ pSQLODBC support) needed.

[Sachin Srivastava]

Yes the EnterpriseDB installer works from the shell, try running the 
installer with ' --mode text ' or --help for all options available.


On 3/11/10 11:17 PM, Ozz Nixon wrote:
I have written a binary wiki engine using PostgreSQL and FPC - it is 
sweet. But, now I have a customer and I am here today to install the 
product (along with other tasks) and their Linux box does not run X. 
My steps are down perfect, run install from EnteriseDB and drop in my 
product and .conf file.


I am not sure how to do this from a shell, will the installer from 
EnterpriseDB work from the shell and still install the ODBC and server?


// I use unixODBC (ODBC in general) to support any back-end for my 
Wiki. But, being an old Ora-DBA, I LOVE POSTGRESQL!


Thanks for any guidance you guys can give me!
Ozz



Thank you,

G.E. Ozz Nixon
CEO/Sr. Software Architect
3F, LLC
125 Robin Dr.
Barto PA 19504
Office: 1-484-363-2304
Cell: 1-610-698-7976
Email: o...@3flabs.com

The information contained in this communication is confidential. It is 
intended only for the use of the recipients named above, and may be 
legally privileged. If the reader of this message is not the intended 
recipient, you are here by notified that any dissemination, 
distribution or copying of this communication is strictly prohibited.


If you have received this communication in error, please resend the 
communication to the sender and delete the original message or any 
copy of it from your computer systems.






--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Problems with the Windows 8.4.1 upgrade from 8.3 on non-C drive

[Sachin Srivastava]

The one-click installers are designed in such a way that you can have 
different major versions of postgresql co-exist on the same machine. 
Thats the reason, the 8.4.1 installer doesn't realize that 8.3 is even 
installed.



On 2/26/10 12:56 AM, dtrobert wrote:

Hi,
We have tried this at least with Windows 2008 64-bit server and the problem
is very reproducible (multiple systems):

1. Install 8.3 on some non-C drive (say E:\)
2. Run the 8.4.1 installer to upgrade this install
   

it appears that the 8.4.1 doesn't realize 8.3 is even installed
 

Result: Installation fails with a permission problem. It seems certain files
from 8.3 are not able to be deleted. When I manually try to delete them,
even with the Administrator user, it fails. I ultimately needed to take
ownership and then give Full Control before I was allowed to delete them.

There is no problem with this upgrade on the C:\ drive.

Thanks
   



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] how do I disable automatic start on mac os x?

[Sachin Srivastava]

On 01/04/2010 07:13 PM, Dave Page wrote:

On Mon, Jan 4, 2010 at 1:42 PM, Chris Withersch...@simplistix.co.uk  wrote:
   

Dave Page wrote:
 

On Mon, Jan 4, 2010 at 1:38 PM, Chris Withersch...@simplistix.co.uk
wrote:
   

Naoko Reeves wrote:
 

Try check this directory: Library: StartupItems: postgres-plus-8.xx
there should be script to start automatically.
   

/Library/StartupItems is empty.

I think putting stuff in there is an old-fashioned way of doing things
that
went out with Mac OS X 10.4, and I'm glad to say it looks like the latest
postgres doesn't install like this..
 

Look in /Library/LaunchDaemons/
   

Ah, there it is... but now what do I do with it to disable the auto-start?
 

Iirc, you have to change:

 keyRunAtLoad/key
 true/

to

 keyRunAtLoad/key
 false/

Sachin; can you confirm please?
   

Yes. Though the daemon is loaded during startup.
and you can start it by using launchctl as ( sudo launchctl start 
com.edb.launchd. postgresql-8.4).

Also you can always move/delete the plist file to avoid that also.


--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] how do I disable automatic start on mac os x?

[Sachin Srivastava]

On 01/04/2010 08:07 PM, Chris Withers wrote:

Sachin Srivastava wrote:

Iirc, you have to change:

keyRunAtLoad/key
true/

to

keyRunAtLoad/key
false/

Sachin; can you confirm please?

Yes. Though the daemon is loaded during startup.


Will setting RunAtLoad to false not stop that?
RunAtLoad = false means, the daemon is loaded not executed/launched. If 
you dont want it to load at system startup. Remove the plist from that 
directory. (i.e. /Library/LaunchDaemons)


Chris




--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] how to install just client libraries on windows?

[Sachin Srivastava]

On 12/02/2009 06:59 AM, Craig Ringer wrote:

On 2/12/2009 7:10 AM, raf wrote:


aside
not only that, but on a windows host on which i had
installed the 8.3 client and server software, when i
uninstalled the server leaving the client software behind,
the client software was no longer complete and couldn't
be used (i.e. python's pygresql module failed to load
even though libpq.dll was there because something else
wasn't there). i had to rsync files over from another
host that had only had the client software installed.
/aside


Ouch. The installer is not not properly tracking the sharing of DLLs 
between components.



The easiest way to just get libpq and the
supporting libraries would be from the tarball distros:
http://www.enterprisedb.com/products/pgbindownload.do

Just extract, and grab the DLLs.


thanks but no thanks. i can see where this might lead.
i don't know what files are needed and what ones aren't.
it probably won't just be the dlls that are needed and
i'll waste half a day experimenting to see what's really
needed. plus it only helps me. it doesn't help anyone else.


Dependency Walker (depends.exe) from dependencywalker.com takes care 
of that. It really is trivial. However, I agree that it's a cludgy way 
to do things that shouldn't be necessary.


It'd be good to see a simple MSI installer of the client libs. The Pg 
server installer could always just bundle the client lib installer, 
but permit it to be distributed separately as well. That'd save on 
install complexity and size as well.


EnterpriseDB are currently handling the creation of the binary 
installers for PostgreSQL. I've been talking with them about some 
other installer issues (where the interferes with system libraries on 
Linux) too, so hopefully they'll be doing some work on their 
installers soon. Maybe they can look at splitting the client library 
installer into a separate package too.


Dave: Are there sources available for the EnterpriseDB 
installer/packaging system? I'd like to get into the linux library 
path patcking problem myself, since nobody at EDB seemed to be 
interested in the issues when discussed on -general last week.
Craig, we always hear to what the community says as that will help us 
improve the installer a lot. We have already committed a fix as per the 
discussion and are in a process of verifying the changes and will be 
hoping to release it very soon.




--
Craig Ringer




--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] how to install just client libraries on windows?

[Sachin Srivastava]

On 12/02/2009 09:42 AM, Craig Ringer wrote:

On 2/12/2009 10:40 AM, Sachin Srivastava wrote:


Dave: Are there sources available for the EnterpriseDB
installer/packaging system? I'd like to get into the linux library
path patcking problem myself, since nobody at EDB seemed to be
interested in the issues when discussed on -general last week.

Craig, we always hear to what the community says as that will help us
improve the installer a lot. We have already committed a fix as per the
discussion and are in a process of verifying the changes and will be
hoping to release it very soon.


Great - I'm glad to hear it. I had no idea you were working on it, as 
you didn't respond on the list except to suggest that you'd avoid 
installing libxml2 if it was already there.


Is that what you man by the fix? Or are you updating the installer to 
avoid messing with ld.so.conf by using rpath linking instead?
We have updated the installer to avoid configuring ld.so.conf and 
instead use rpath linking.


--
Craig Ringer



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

[Sachin Srivastava]

Libraries the One-Click installer tramples all over include:

libxml2
libssl
libcrypto
libreadline
libtermcap
libuuid
   
Apart from libxml2 (which is now being fixed) all other libraries you 
mentioned , dint get installed (or copied) to the PGHOME/lib directory 
if the same name library already present in the system (/lib and /usr/lib).

... all of which have the same names and in some cases soversions that
they're likely to have in the OS packages.

As libpq.so.5 is also added to the linker path, if a user has a
distro-packaged version of PostgreSQL which has the same soversion of
libpq then the distro-packaged psql etc is also likely to use the
one-click install's libpq, leading to the potential for all sorts of
exciting breakage if they've been built with different options.

An incomplete list of binaries clearly affected by library conflict
issues such as the libxml one the OP reported is, as checked in my
Ubuntu 9.04 install:

/usr/bin/amstex
/usr/bin/bonobo-browser
/usr/bin/bug-buddy
/usr/bin/compiz.real
/usr/bin/devhelp
/usr/bin/dvd95
/usr/bin/dwell-click-applet
/usr/bin/editor
/usr/bin/ekiga
/usr/bin/eog
/usr/bin/etex
/usr/bin/eview
/usr/bin/evim
/usr/bin/evolution
/usr/bin/evolution-addressbook-export
/usr/bin/ex
/usr/bin/gedit
/usr/bin/gnome-about-me
/usr/bin/gnome-appearance-properties
/usr/bin/gnome-default-applications-properties
/usr/bin/gnome-desktop-item-edit
/usr/bin/gnome-help
/usr/bin/gnome-keyboard-properties
/usr/bin/gnome-open
/usr/bin/gnome-panel
/usr/bin/gnome-phone-manager
/usr/bin/gnome-pilot-make-password
/usr/bin/gnome-text-editor
/usr/bin/gnomevfs-cat
/usr/bin/gnomevfs-copy
/usr/bin/gnomevfs-df
/usr/bin/gnomevfs-info
/usr/bin/gnomevfs-ls
/usr/bin/gnomevfs-mkdir
/usr/bin/gnomevfs-monitor
/usr/bin/gnomevfs-mv
/usr/bin/gnomevfs-rm
/usr/bin/gnome-volume-properties
/usr/bin/gpilot-applet
/usr/bin/gpilotd
/usr/bin/gpilotd-control-applet
/usr/bin/gpilotd-session-wrapper
/usr/bin/gpilot-install-file
/usr/bin/grip
/usr/bin/gthumb
/usr/bin/gview
/usr/bin/gvim
/usr/bin/gvimdiff
/usr/bin/inkscape
/usr/bin/inkview
/usr/bin/jadetex
/usr/bin/latex
/usr/bin/meinproc4
/usr/bin/msgattrib
/usr/bin/msgcat
/usr/bin/msgcmp
/usr/bin/msgcomm
/usr/bin/msgconv
/usr/bin/msgen
/usr/bin/msgexec
/usr/bin/msgfilter
/usr/bin/msgfmt
/usr/bin/msggrep
/usr/bin/msginit
/usr/bin/msgmerge
/usr/bin/msgunfmt
/usr/bin/msguniq
/usr/bin/nautilus
/usr/bin/panel-test-applets
/usr/bin/pdfetex
/usr/bin/pdffonts
/usr/bin/pdfimages
/usr/bin/pdfinfo
/usr/bin/pdfjadetex
/usr/bin/pdflatex
/usr/bin/pdftex
/usr/bin/pdftoabw
/usr/bin/pdftohtml
/usr/bin/pdftoppm
/usr/bin/pdftops
/usr/bin/pdftotext
/usr/bin/php5-cgi
/usr/bin/php-cgi
/usr/bin/pidgin
/usr/bin/pointer-capture-applet
/usr/bin/polkit-gnome-authorization
/usr/bin/recode-sr-latin
/usr/bin/rgview
/usr/bin/rgvim
/usr/bin/rhythmbox
/usr/bin/rview
/usr/bin/rvim
/usr/bin/seahorse
/usr/bin/seahorse-daemon
/usr/bin/test-moniker
/usr/bin/tracker-search-tool
/usr/bin/vi
/usr/bin/view
/usr/bin/vim
/usr/bin/vimdiff
/usr/bin/vim.gnome
/usr/bin/vinagre
/usr/bin/vino-preferences
/usr/bin/virsh
/usr/bin/virt-viewer
/usr/bin/xfce4-keyboard-settings
/usr/bin/xfce4-settings-helper
/usr/bin/xgettext
/usr/bin/xmlcatalog
/usr/bin/xmllint
/usr/bin/yelp

Other distros will experience different breakage. On Ubuntu 9.10, for
example, the standard readline soversion is .5.2 so the libreadline.so.4
bundled in the oc installer won't break users of the distro-packaged
libreadline. Ditto libssl  and libcrypto (oc: .5.2 ; distro: .0.9.8 ).

This needs really urgent attention. Step 1 is probably to rebuild the
installer using libraries where everything has been given custom
soversions; next step is to use rpath linkage to solve the problem properly.

--
Craig Ringe
   



--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

[Sachin Srivastava]

A quick-fix solution is deleting the file 
'/opt/PostgreSQL/8.4/lib/libxml2.so.2'.



On 11/28/2009 04:23 PM, Leonardo Camargo wrote:

Hi all,
I'm wondering if someone here know how to go about fixing this problem 
that apparently affects everyone who manually install Postgresql8.4 on 
Ubuntu Karmic(9.10).


Postgres installation seems to mess with something that renders other 
applications unable to function. For instance my problem is with 
Evolution Mail. This is the output I started getting after installing 
postgres:


evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by evolution)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by 
/usr/lib/evolution/2.28/libemiscwidgets.so.0)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libgdata-1.2.so.1)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libgdata-1.2.so.1)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/evolution/2.28/libetable.so.0)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/evolution/2.28/libeutil.so.0)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/evolution/2.28/libeutil.so.0)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libebook-1.2.so.9)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libedataserver-1.2.so.11)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libsoup-2.4.so.1)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libgnomevfs-2.so.0)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libgnomevfs-2.so.0)
evolution: /opt/PostgreSQL/8.4/lib/libxml2.so.2: no version 
information available (required by /usr/lib/libgnomevfs-2.so.0)
evolution: relocation error: /usr/lib/evolution/2.28/libeutil.so.0: 
symbol xmlFirstElementChild, version LIBXML2_2.7.3 not defined in file 
libxml2.so.2 with link time reference


I can't be sure(no logs) but VMWare Workstation seems to have been 
affected here too, can't get it to work anymore.


Other people having the same problem:
http://ubuntuforums.org/showthread.php?t=1307864
https://bugs.launchpad.net/ubuntu/+bug/461105


Best regards,
Leonardo C.







--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres 
http://www.enterprisedb.com company.

[GENERAL] initdb failing

[Sachin Srivastava]

Hi all,

I am using PostgreSQL 8.4.1 on Windows XP SP3 (64 -bit).

This is what i get when i fire initdb command:

/D:\Base\NetScope\pg\bininitdb.exe -d -n -U postgres -D 
d:\base\netscope\pg\data


Running in debug mode.
Running in noclean mode. Mistakes will not be cleaned up.
Running in debug mode.
Running in noclean mode. Mistakes will not be cleaned up.
VERSION=8.4.1
PGDATA=d:/base/netscope/pg/data
share_path=D:/Base/NetScope/pg/share
PGPATH=D:/Base/NetScope/pg/bin
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=D:/Base/NetScope/pg/share/postgres.bki
POSTGRES_DESCR=D:/Base/NetScope/pg/share/postgres.description
POSTGRES_SHDESCR=D:/Base/NetScope/pg/share/postgres.shdescription
POSTGRESQL_CONF_SAMPLE=D:/Base/NetScope/pg/share/postgresql.conf.sample
PG_HBA_SAMPLE=D:/Base/NetScope/pg/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=D:/Base/NetScope/pg/share/pg_ident.conf.sample
The files belonging to this database system will be owned by user 
NetScopeAdmin .

This user must also own the server process.

The database cluster will be initialized with locale 
Portuguese_Portugal.1252.

The default database encoding has accordingly been set to WIN1252.
The default text search configuration will be set to portuguese.

fixing permissions on existing directory d:/base/netscope/pg/data ... ok
* creating subdirectories ... initdb: could not create directory 
d:/base/netscope/pg: File exists
*initdb: data directory d:/base/netscope/pg/data not removed at user's 
request





Anything that i am missing anywhere??//

/

--
Regards,
Sachin Srivastava
www.enterprisedb.com

Re: [GENERAL] initdb failing

[Sachin Srivastava]

On 10/06/2009 11:41 PM, Raymond O'Donnell wrote:

On 06/10/2009 19:00, Sachin Srivastava wrote:

   

fixing permissions on existing directory d:/base/netscope/pg/data ... ok
* creating subdirectories ... initdb: could not create directory
d:/base/netscope/pg: File exists
*initdb: data directory d:/base/netscope/pg/data not removed at user's
request
 

Could it be that the /data directory isn't empty? I think initdb
will fail if this is the case.
   

its empty or i say its newly created.

Ray.

--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r...@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
   



--
Regards,
Sachin Srivastava
www.enterprisedb.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] initdb failing

[Sachin Srivastava]

On 10/07/2009 01:24 AM, Scott Mead wrote:


On Tue, Oct 6, 2009 at 3:09 PM, Sachin Srivastava 
sachin.srivast...@enterprisedb.com 
mailto:sachin.srivast...@enterprisedb.com wrote:


On 10/06/2009 11:41 PM, Raymond O'Donnell wrote:

On 06/10/2009 19:00, Sachin Srivastava wrote:


fixing permissions on existing directory
d:/base/netscope/pg/data ... ok
* creating subdirectories ... initdb: could not create
directory
d:/base/netscope/pg: File exists
*initdb: data directory d:/base/netscope/pg/data not
removed at user's
request

Could it be that the /data directory isn't empty? I
think initdb
will fail if this is the case.

its empty or i say its newly created.


  Because you're using the -n flag, after you run initdb once, the 
directory is left there.  Delete the 'data' directory and try again.
Actually i put the -n and -d flags just to get more information about 
what all has been created but they remain empty. Nevertheless tried 
removing the old data directory and without -n option still got the same 
output.


--Scott




--
Regards,
Sachin Srivastava
www.enterprisedb.com

Re: [GENERAL] error message on install [ REPOST from pgsql-novice ]

[Sachin Srivastava]

On 10/01/2009 07:00 PM, Ounce Snow wrote:

Hi,

this may be a FAQ but I did not see it listed there:

when I run the install (Intel Mac) I get a popup saying

problem running post install step
Installation may not complete correctly
The database cluster initialisation failed
Check the logs(/tmp/install-postgresql.log). You can also post the error 
part of the log.


what have I missed please?

Greg




--
Regards,
Sachin Srivastava
www.enterprisedb.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general