Re: [GENERAL] Search connections created per day
Hi there, I want to know how many connections is created simultaneously in data base per day. Do you want to know the max simo connections at any given time, or the total connections in a given day? Assuming you want to know the max simo connections at any given time, I think you're going to have to check pg_stat_activity every x minutes and store the number of rows somewhere to retrieve later. Are there some table where i can search it? pg_stat_activity, but it only has the info for right now in it. Thanks... I want to know the max simo connections at any given time, but I only have a backup of the database, so, I don't can use the pg_stat_activity. This database is running in a client, and I should to know if he is creating more connections of it is allowed. Thanks. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Search connections created per day
Hi there, I want to know how many connections is created simultaneously in data base per day. Are there some table where i can search it? All users is connected in the database with postgres user. Thanks. João Paulo Zavanela ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] Primary Key
Hello, How many fields is recomended to create a primary key? I'm thinking to create one with 6 fields, is much? Thanks! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] number errors
Hi all, When my application returns errors from database, some numbers errors is equals. Why number errors is equals? odbc driver or postgresql return this? It's run in Windows. Thanks. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] number errors
Hi all, When my application returns errors from database, some numbers errors is equals. Why number errors is equals? odbc driver or postgresql return this? It's run in Windows. Thanks. Hello, If you use ODBC - you should devide error from ODBC driver and errors from PostgreSQL, ODBC driver return it's own error codes, and composes error Description depending on Error Code and Text from PostgreSQL server. So you should have numbers: 1) ODBC error code - described in MSDN; 2) Native PostgreSQL error code - described in PostgreSQL manual; 3) Error description - composed by ODBC driver, based on description and error code, returned from server. Hi, Thanks for help. I'm using ODBC Driver, so the ODBC driver returns the errors, ok? So, this errors is independent from PostgreSQL server? ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] configure password
Hi, How I configure password to postgres user in Linux? I'm using trust, but I needing configure password in database. Thanks! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] configure password
Hi, How I configure password to postgres user in Linux? I'm using trust, but I needing configure password in database. Thanks! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match For database roles, you can change the password by ALTER ROLE command. For example, change the pwd for user postgres to 123 : ALTER ROLE postgres PASSWORD '123'; Thanks, but I need configure password to connect to server! Now the pg_hba.conf is trust, I need change to passwd. Changing the file to passwd, I don't know how configure password to connect! Thanks! ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] active connections
I don't understand, where I do it? -- Mensagem Original -- From: Martin Gainty [EMAIL PROTECTED] To: João Paulo Zavanela [EMAIL PROTECTED] Subject: Re: [GENERAL] active connections Date: Mon, 30 Oct 2000 16:51:30 -0500 ps aux | grep postgres M-- - Original Message - From: João Paulo Zavanela [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Tuesday, October 30, 2007 12:51 PM Subject: [GENERAL] active connections Hi, I would like to know how many active connections exist. Is necessary show the number ip of client. Please, somebody knows? Thanks! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Install plJava
João Paulo Zavanela wrote: The file pljava.dll exist in directory, why this error? Someone can help me? PL/Java has it's own mailing list here: http://gborg.postgresql.org/mailman/listinfo/pljava-dev I think it is still active, but I'm not sure. Sorry, I'm short on time. Search the archives there; I think this problem has come up before. -- Guy Rouillier Hi, thanks. I think it isn't active, I subscribe, but I don't received mails. You know other list? thanks! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] active connections
Hi, I would like to know how many active connections exist. Is necessary show the number ip of client. Please, somebody knows? Thanks! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Install plJava
João Paulo Zavanela wrote: The file pljava.dll exist in directory, why this error? Someone can help me? PL/Java has it's own mailing list here: http://gborg.postgresql.org/mailman/listinfo/pljava-dev I think it is still active, but I'm not sure. Sorry, I'm short on time. Search the archives there; I think this problem has come up before. -- Guy Rouillier Thanks! I will search in this mailing list. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] Install plJava
Hi there, I trying to install pljava, but I'm getting error in this command line: C:\Documents and Settings\Joao Paulojava -cp C:\\Program Files\\PostgreSQL\\8. 2\\share\\pljava\\deploy.jar;C:\\Program Files\\PostgreSQL\\8.2\\jdbc\\postgre sql-8.2-504.jdbc3.jar org.postgresql.pljava.deploy.Deployer -install -user comp iere -database compiere -password compiere org.postgresql.util.PSQLException: ERROR: could not load library C:/Program Fil es/PostgreSQL/8.2/lib/pljava.dll: The specified module could not be found. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract Jdbc2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:329) at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java: 474) at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269) The file pljava.dll exist in directory, why this error? Someone can help me? Thanks! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq