Postgres Plus Forums - Latest forum topics

Syntax mistakes cause segfault errors on PPAS 9.1.2.2

quintinhoare — GMT

Hi.

This is my first post on the forum, so I hope I give enough detail regarding the problem.

OS: Red Hat Enterprise Linux Server release 5.3 (Tikanga)
DB: Postgres Plus Advanced Server 9.1.2.2

When attempting to run a very simple transaction (calling a function), a simple syntax problem causes a signall 11 segfault problem.

This is the query running correctly (I have taken out some client specific data and replaced it with [data]:
test=# begin;
BEGIN
test=# Select * from f_tg_locks_load_tbl('[data]', '[data]', '[data]');
strschema | strtbl | strtgschema
-----------+-----------+--------------------------
[data] | [data] | [data]
(1 row)

test=# end;
COMMIT

If I run the exact same query, but omit the ; after the begin I get the following:
test=# begin
test$# Select * from f_tg_locks_load_tbl('[data]', '[data]', '[data]');
test$# end;
The connection to the server was lost. Attempting reset: Failed.
!>
!>

In the log file I get the following:
LOG: server process (PID 27592) was terminated by signal 11: Segmentation fault
DETAIL: Failed process was running: begin Select * from f_tg_locks_load_tbl('[data]', '[data]', '[data]'); end;
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

If we test this on the free version (9.1.3) then we do receive a syntax error:
ERROR: syntax error at or near "Select"
LINE 2: Select * from f_tg_locks_load_tbl('[data]', '[data]', '...
^

********** Error **********
ERROR: syntax error at or near "Select"
SQL state: 42601
Character: 9

Is typehandlers in Ibatis supported by edb?Calling a storedProc(with table type OUT param)tru Ibatis

njohny — GMT

Hi,I am a newbie in edb.I am trying to migrate oracle to enterprise db.We used to use type handlers(of Ibatis) for handling the Table type out params in oracle.Please let me know the changes i should do to make it work with enterprise db. :?:
Please let me know the equivalent of oracle jdbc classes like OracleTypes,ARRAY,STRUCT,ArrayDescriptor etc.
ie the jdbc API for edb
Please help :cry: :cry:
thanks in advance,
Njohny.

Problem with stored functions with Out Parameter list

jagdeeps — GMT

Hi, This is my first post on the forum. Hope, I'll get a resolution to my problem.

We are in process of migration from Oracle 10g to Postgres9.1 Advance Server. The stored procedures/functions from Oracle have some parameters registered as Out parameters. Now, when we call it from Java, an exception thrown -:

org.postgresql.util.PSQLException: Malformed function or procedure escape syntax at offset 9.

The signature of Postgres Function is as ::
sfblprdbilldate(IN p_billdate numeric, IN p_cutoffday numeric, IN p_billfreq character varying, IN p_givendate timestamp without time zone, OUT po_startdate timestamp without time zone, OUT po_end_date timestamp without time zone)

Java code for calling this function is as follows ::

strSql="{? = call(SFBLPRDBILLDATE(?,?,?,?,?,?))}";

objCstmt = objConn.prepareCall(strSql);
objCstmt.registerOutParameter(1,Types.VARCHAR);
objCstmt.setInt(2,iBillDay);
objCstmt.setInt(3,iBillDay);
objCstmt.setString(4,strBillFrequency);
objCstmt.setDate(5,dtSysDate);
objCstmt.registerOutParameter(6,Types.DATE);
objCstmt.registerOutParameter(7,Types.DATE);
objCstmt.execute();
strBillPeriod = objCstmt.getString(1);
dtStartDate = objCstmt.getDate(6);

Anybody, who has resolved this sort of issue, please help me as this is in numbers in our code and we are looking for a solutuin to this problem.

Thanks
Jony.

IE8 Printing

marshall-9 — GMT

I am inserting the Data Matrix into web pages using the image tags. All runs well until I upgrade my IE7 to IE8 at the beginning of this month. The barcode did not show any more on IE, the location where should be a image is displayed as “X” now. What should I do?

Create a self contained postgres distribution

hagzag — GMT

What I am trying to achieve is creating a zip / tar.gz file with potgresql with all its inter-dependencies and then at buidl time download and extract the zip / tar.gz
[running as the user which instantiated the build], start the server, set up a user, pass & database, run my tests, stop the server then remove the installation.

The problem I am facing is running the installer does some fancy stuff I don't need [or want scattered around my system] for example the /etc/init.d scripts I don't need or want left over, the /etc/postgres-reg.ini I dont need or want.

I also found that dusinr installation via installer whilst executing ./postgresql-9.1.3-1-linux-x64.run --mode=unattended --optionfile
where the option file has the following entries:
debuglevel=4
installer-language=en
servicename=postgres-9.1
serviceaccount=myuser
create_shortcuts=0
prefix=mydir
datadir=mydatadir
superpassword=manager
serverport=5432

Have you any recommendations how to go about and do the above.

Thanks

error acquiring Payload

lz1asl — GMT

Hello,

Following error while scaling cluster up : error acquiring Payload(path=/opt/PostgresPlus/CloudDB/data/replication.crt]):No such file (attached).
The events are :
[code]
Node i-615beb07 is Shutting Down
Terminating
Replica addition: configuring certificates.
Replica addition: copying data.
Adding disks to replica i-615beb07
Adding Replica i-615beb07
Connecting [10.86.207.247]
Initializing Replica
Addition of replica to cluster XXX started.
[/code]

Any ideas ?
Thank you in advance.

Aleksandar

Problem witch User system account

Domenico — GMT

Hello Everyone, I have a problem with the installation of 'Make' of Enterprise Postgres SQL DB vers. 9.1.
Once I installed Postgres (and during installation insert the password for the database / system), when I go to the setup of 'Make' give me the following error: JDBC CONNECTION ERROR (error conneting: jdbc: edb :/ / postgres : 5444/edb-as EnterpriseDB / mypassword
Can anyone give me a help to solve this problem?
I insert the password I created for the user EnterpriseDB, there is a default password to a user's system?
Post a print screen of the error.

thanks

Problem creating slony replication

marcos.rodriguez — GMT

Hi.

I'm installing a slony replication system from [i]How to Set Up Slony-I Replication for Postgres Plus(R)[/i] tutorial. This is my system:

-Master (PPAS 9.1, CentOS 6.2)
-Slave (PPAS 9.1 Windows Server 2003 R2 Standard Edition)

I follow all steps, but when I try to create Slony service in slave node (Step 9 from tutorial) I get the following error:

"Failed to create service: 1057"

I run system simbol with Admin user

Thanks in advance,
Marcos

Cluster high load unexpected

lz1asl — GMT

The Enterprise Cloud DB Monitoring Console shows high cluster load (see attachment). The actual load on the system that connects to the system was none. I have checked all of the openned DB connections and all were idle. No backups were active.
The load can go up and stay high, can someone suggest how to investigate futher ?

Best Regards,
Aleksandar

Too many addresses allocated

lz1asl — GMT

The attached error when trying to clone or scale up a cluster :

Any ideas ?

Thank You,
Aleksandar

Installing pgAgent on Mac OS X 10.6.8 VM renames account as pgAgent

david.blaymires — GMT

We've been installing PostgreSQL 8.4.11 on a Mac OS X computer running 10.6.8 under VMware Fusion. We used Stackbuider to download and install pgAgent. When pgAgent is installed, it is renaming the account that we are logged in under as pgAgent, and is changing the home folder of the account to the pgAgent folder in /Library/PostgreSQL/. It does not rename the home folder of the account that it renames.

1. Have you seen this or similar behaviour before?
2. If so, is it a problem in the OS or in the pgAgent installer?

Any advice is sincerely welcomed!

Regards, David

How to fix Replica with Yellow Alert

db_architech28 — GMT

Hi

Upon initializing the may 2 replica Cluster | Server has yellow alert and Connection is 0. How to fix that?

Please help! Thanks!

EDB Cloud Console not accessible https://aws-us-east-1b.theclouddatabase.com/

db_architech28 — GMT

Hi

Got hitting this problem unable to access the console https://aws-us-east-1b.theclouddatabase.com/.

Thanks for the help!

Free Trial 72 Hours

db_architech28 — GMT

Hi EDB Team,

What happened to trial version with 72 hours allotment? I just got 24 only? this is very limited. Im just trying to do some testing before we proceed on final testing.

Thanks in advance!

validateuser.exe fails when installing in unattended mode

cdelgado — GMT

Hi,

I'm testing the installer, but I got stuck at this point and can't figure out what's happening:

I create the properties file and launch this command line:

[i]postgresql-9.1.3-1-windows.exe --optionfile optionsfile.txt[/i]

And suddently there's a window with this message: [i]...\validateuser.exe "." "postgres" "****": Program ended with an error code[/i]

The contents of the options file are these:
[i]mode=unattended
unattendedmodeui=minimal
prefix=C:\Program Files\myAppDB
datadir=d:\testPSQL
servicename=MyApp-Database
serverport=5555
create_shortcuts=0[/i]

Any clues of what can be happening?

Thanks

Carlos

What happened with options of the the silent install? - SOLVED

cdelgado — GMT

Hi,

I was hoping I could use this to embed the installation in my own application´s installer: http://pginstaller.projects.postgresql.org/silent.html

But it seems pretty old and just for Windows (I need it for Mac OS too)

What I really liked is the huge range of options that you can set there. Is there any way I can rename the service with the one-click instalator?

Is there a complete list of available options?

One more thing: it would be really useful if you write small examples on how to call the one-click installer from programming languages, like from Java (best way of invoking it, handling errores, variables...)

Thanks so mucho for this work.

Carlos

Replication from SQL 2008 to PostGres 9.1

pshere — GMT

I am trying to set this up via xdbreplication. When I try to create the subscription it fails with a syntax error in the create table syntax. I am able to create the table manually on the subscriber (Postgres). Is it possible to use that table to set up my subscription. If yes can you please guide me in the right direction.

Thanks.

Backup of cluster failed

schevelev — GMT

Hello,

In the Cloud Database console, in the events I see the following messages every day:

31122 Tue May 01 01:45:21 EDT 2012 Backup of cluster ngbeta2 started.
31123 Tue May 01 01:45:21 EDT 2012 Backup in progress
31124 Tue May 01 01:45:27 EDT 2012 A backup is alerady in progress.
31125 Tue May 01 01:45:27 EDT 2012 Backup of cluster ngbeta2 failed.

So, backup doesn't work. Could you tell me please what should I check to find the problem ? I don't see how I can change the configuration of the backup.

Cloud Database availability in Asia

james_m — GMT

What is the time frame for Cloud Database in the Tokyo & Singapore regions?

Thanks,

James

Password Constraints and Length Requirements

David_P — GMT

Can anyone point me to documentation on EnterpriseDB Advanced Server password constraints and min/max length requirements.

Install PostgreSQL on Windows via command line

desrocchi — GMT

Hi,
up until EnterpriseDB took over the Windows package of PostgreSQL we were able to launch a batch file containing all the options to install PostgreSQL skipping all the steps.

We used something like
[code]msiexec /i postgresql-8.1-int.msi /qr INTERNALLAUNCH=1 ADDLOCAL=server,nls,psql,pgadmin SERVICEDOMAIN="%COMPUTERNAME%" SERVICEACCOUNT="postgres" SERVICEPASSWORD="password" CREATESERVICEUSER=1 SUPERPASSWORD="pass" LOCALE="en_EN"[/code]

Is it possible to do the same with this new installer? And if now, can we have it back?

Thanks.

How to change the position of a column in a table

vas3255 — GMT

Hi All,

after adding a column to a table by using alter command, if i want change the position of that newly added column what i need to do.

Thanks & Regards,
Srinivas Davuluri

Feature request: add an option to specify pg_xlog directory location

Juan_M — GMT

Hi,

currently the one click installer has an option to specify the data directory location.
It would be nice to have another option to specify the pg_xlog directory location.
My understanding is that this is just a matter of creating a symlink (which are now supported on recent windows versions) on directory pointing to the proper location and set up the proper permissions on the real location.
Is this correct or am I missing something obvious?

Regards

Juan Martinez

Service Stop and Start PostgreSQL

Julio+Cesar_Martini — GMT

I installed PostgreSQL version 9.1 Mac OS (http://www.postgresql.org/download/macosx/). How do I enable a service to stop and start the database?

Regards,
Julio Cesar

Cloud xdb rep server and xdb replication console

stefhan — GMT

hi,

i have a subscrition of Postgres Plus Cloud. My server is a postgres plus 9.1...so, the server have xdb rep server how i can download xdb replication console??