Thread: Database Publishing Wizard

Database Publishing Wizard

From

"Paolo Frizzera"

Date:

09 December 2002, 10:25:22

Hi all,

when I try to use the Database Publishing Wizard in pgAdmin2 I receive
always error messages.
I enclose some logs.

Thanks.
Ciao, Paolo



with version 1.4.2:

2002-12-05 13:36:37 -
*******************************************************************
2002-12-05 13:36:37 - Error(s)
2002-12-05 13:36:37 -
*******************************************************************
2002-12-05 13:36:37 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147467259 - [Microsoft][ODBC
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-05 13:36:37 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-05 13:36:37 - pgSchema Version: 1.4.1
2002-12-05 13:36:37 - MDAC Version: 2.7
2002-12-05 13:36:37 - DBMS Version: 07.02.0005 PostgreSQL 7.2.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-05 13:36:37 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=prova;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColu
mn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;
UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0
;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarc
har=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFC
onversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

2002-12-05 13:37:46 - Executing Plugin: Database Publishing Wizard v1.4.1
2002-12-05 13:37:46 - Examining Server...
2002-12-05 13:37:46 - Done - 0,06 Secs.
2002-12-05 13:37:55 - Examining Server...
2002-12-05 13:37:55 - Done - 0,11 Secs.
2002-12-05 13:38:48 - Publishing database...
2002-12-05 13:38:48 - Opening Connection:
DRIVER=PostgreSQL;SERVER=10.0.0.129;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATABASE
=test
2002-12-05 13:38:48 - Done - 0,45 Secs.

2002-12-05 13:38:48 -
*******************************************************************
2002-12-05 13:38:48 - Error(s)
2002-12-05 13:38:48 -
*******************************************************************
2002-12-05 13:38:48 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147467259 - [Microsoft][ODBC
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-05 13:38:48 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-05 13:38:48 - pgSchema Version: 1.4.1
2002-12-05 13:38:48 - MDAC Version: 2.7
2002-12-05 13:38:48 - DBMS Version: 07.02.0005 PostgreSQL 7.2.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-05 13:38:48 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=xxxxxx;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColum
n=
0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;Unk
nownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Op
timizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar
=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConv
ersion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

2002-12-05 13:44:03 - Publishing database...
2002-12-05 13:44:04 - Opening Connection:
DRIVER=PostgreSQL;SERVER=xxx.xxx.xxx.x;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATAB
ASE=Test
2002-12-05 13:44:04 - Done - 0,12 Secs.

2002-12-05 13:44:04 -
*******************************************************************
2002-12-05 13:44:04 - Error(s)
2002-12-05 13:44:04 -
*******************************************************************
2002-12-05 13:44:04 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147467259 - [Microsoft][ODBC
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-05 13:44:04 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-05 13:44:04 - pgSchema Version: 1.4.1
2002-12-05 13:44:04 - MDAC Version: 2.7
2002-12-05 13:44:04 - DBMS Version: 07.02.0005 PostgreSQL 7.2.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-05 13:44:04 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=xxxxxx;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColum
n=
0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;Unk
nownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Op
timizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar
=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConv
ersion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"





with version 1.4.6:

2002-12-06 15:43:51 -
###################################################################
2002-12-06 15:43:51 - pgAdmin II v1.4 Build 6 Startup
2002-12-06 15:43:51 -
###################################################################
2002-12-06 15:43:51 - Loading Plugins...
2002-12-06 15:43:51 - Loading Plugin: pgConnDebug.pgAdmin2_Plugin
(Connection Debugging Tools v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgImport.pgAdmin2_Plugin (Import
Wizard v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgMigration.pgAdmin2_Plugin (Database
Migration Wizard v1.4.5)
2002-12-06 15:43:51 - Loading Plugin: pgMSysConf.pgAdmin2_Plugin (MSysConf
Wizard v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgPublishing.pgAdmin2_Plugin (Database
Publishing Wizard v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgSecurity.pgAdmin2_Plugin (Security
Wizard v1.4.3)
2002-12-06 15:43:51 - Done - 0,74 Secs.
2002-12-06 15:44:02 - Connecting to 10.0.0.129...
...
2002-12-06 15:46:38 - Opening cnPostgreSQL:
SERVER=10.0.0.129;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATABASE=template1;DRIVER=
{P
ostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSION
ING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;
MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFET
CH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCE
LASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=0;
2002-12-06 15:46:39 - Done - 1,99 Secs.

2002-12-06 15:46:39 -
*******************************************************************
2002-12-06 15:46:39 - Error(s)
2002-12-06 15:46:39 -
*******************************************************************
2002-12-06 15:46:39 - Error in pgAdmin
II:frmConnect.cmdConnect_Click: -2147467259 - [Microsoft][ODBC Driver
Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-06 15:46:39 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-06 15:46:39 - pgSchema Version: 1.4.4
2002-12-06 15:46:39 - MDAC Version: 2.7
2002-12-06 15:46:39 - cnPostgreSQL.State = adStateClosed



with the last version:

2002-12-09 11:12:40 -
###################################################################
2002-12-09 11:12:40 - pgAdmin II v1.4 Build 7 Startup
2002-12-09 11:12:40 -
###################################################################
2002-12-09 11:12:40 - Loading Plugins...
2002-12-09 11:12:40 - Loading Plugin: pgConnDebug.pgAdmin2_Plugin
(Connection Debugging Tools v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgImport.pgAdmin2_Plugin (Import
Wizard v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgMigration.pgAdmin2_Plugin (Database
Migration Wizard v1.4.5)
2002-12-09 11:12:40 - Loading Plugin: pgMSysConf.pgAdmin2_Plugin (MSysConf
Wizard v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgPublishing.pgAdmin2_Plugin (Database
Publishing Wizard v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgSecurity.pgAdmin2_Plugin (Security
Wizard v1.4.3)
2002-12-09 11:12:40 - Done - 0,85 Secs.
2002-12-09 11:13:00 - Connecting to 10.0.0.129...
...
2002-12-09 11:15:26 - Publishing database...
2002-12-09 11:15:26 - Opening Connection:
DRIVER=PostgreSQL;SERVER=10.0.0.129;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATABASE
=prova
2002-12-09 11:15:26 - Done - 0,12 Secs.

2002-12-09 11:15:26 -
*******************************************************************
2002-12-09 11:15:26 - Error(s)
2002-12-09 11:15:26 -
*******************************************************************
2002-12-09 11:15:26 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147217843 - FATAL:  Non-superuser
connection limit exceeded


2002-12-09 11:15:26 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-09 11:15:26 - pgSchema Version: 1.4.4
2002-12-09 11:15:26 - MDAC Version: 2.7
2002-12-09 11:15:26 - DBMS Version: 07.02.0005 PostgreSQL 7.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-09 11:15:26 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=xxxxxx;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColum
n=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;U
nknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=1;
Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarch
ar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFCo
nversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

Re: Database Publishing Wizard

From

"Dave Page"

Date:

09 December 2002, 19:49:53


> -----Original Message-----
> From: Paolo Frizzera [mailto:geofrizz@mbox.dinamica.it]
> Sent: 09 December 2002 12:27
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Database Publishing Wizard
>
> Publishing Wizard:frmWizard.cmdOK_Click: -2147217843 - FATAL:
>  Non-superuser
> connection limit exceeded

Hi

I looks to me like you've run out of available connections on the
server. PostgreSQL 7.3+ allows the superuser to connect regardless,
hence the more informative message. Try increasing the maximum
connections setting in your postgresql.conf file on the server.

Regards, Dave.

pgadmin 1.4.3 postgreqsl 7.3

From

Julio Mendoza

Date:

10 December 2002, 14:15:20

I upgrade to postgresql 7.3, I can conect from a windows box using pgadmin..

if I use md5, the result error is description: blank

if I user ident sameuser, the result error is: ident authentication failed for user 'ddd'

any help thank,

I still conecting to another server using a previous postgresql version


JM



--
Julio Mendoza <jm@eemsystems.cjb.net>