El 03/07/14 21:06, sunpeng escribió:
my server is pg 9.1.13 in win8 64, my client is win xp 32 bit, which
odbc version (32 or 64 bit) should be installed in Client ? is
psqlodbc_09_01_0200.zip or psqlodbc_09_01_0200-x64.zip?or others?
thks!
peng
Same as your client, in this case, 32 bits
postgresql
status can give you an idea...
or, more general
ps aux | grep postgres
Best regards
Rodrigo Gonzalez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
unix_socket /etc/postgresql/9.3/main/postgresql.conf
Of course change 9.3 with your version or jsut ls /etc/postgresql and
you will see which one you have installed there
I hope this helps
Best regards
Rodrigo Gonzalez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
with that on other
installations.
I can bet that it is connecting to another database or server, check
your perl script configuration.
Best regards
Rodrigo Gonzalez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On Thu, 13 Mar 2014 13:28:38 -0700
Susan Cassidy susan.cass...@decisionsciencescorp.com wrote:
No, it is connecting to localhost, which is the same system I am
running psql on.
Susan
Well, if one query is logged and the other one is not it means that it
is running against different servers
On Thu, 13 Mar 2014 13:44:48 -0700
Susan Cassidy susan.cass...@decisionsciencescorp.com wrote:
No, I don't have 2 instances running. I default the port on the psql
command line, and the perl program is using 5432, as normal.
Now, I'm discovering that syslog is no longer logging anything. I
On Wed, 18 Sep 2013 16:24:16 +0100
Tim Kane tim.k...@gmail.com wrote:
On 18/09/2013 14:44, Rowan Collins rowan.coll...@gmail.com wrote:
Running an EXPLAIN on the exact query should give you the plan. An
EXPLAIN ANALYZE would have to wait for the query to complete either
way, so you
On Thu, 12 Sep 2013 19:07:04 -0300
Roberto Scattini roberto.scatt...@gmail.com wrote:
On Thu, Sep 12, 2013 at 7:02 PM, Bosco Rama postg...@boscorama.com
wrote:
On 09/12/13 14:49, Chris Curvey wrote:
Is this just a case-sentitvity issue? if personas.apellido is a
varchar field, then I
On 06/08/12 13:31, Bruce Momjian wrote:
For longer terms, perhaps we should set up an URL forwarder or
something that the docs can link through in the cases where we really
need this, so we can more easily update the URLs?
Well, the problem there is that they don't get the real URL unless they
On Fri, 20 Apr 2012 17:36:59 +0200
Vincenzo Romano vincenzo.rom...@notorand.it wrote:
Hi all.
I'd like use a temporary view to hide a non-temp one for some
queries. Later I'd need to drop that view in order to revert to
normal operations. As there is no DROP TEMPORARY VIEW ... I'd be
forced
El Thu, 2 Feb 2012 12:03:20 -0500
david.sahag...@emc.com escribió:
Do EXPLAIN ANALYZE:
written=2325 !
Total runtime: 375542.347 ms
Then Do EXPLAIN ANALYZE again:
In general, can you tell me why [written=2325] is displayed by the
first EXPLAIN, but not the second EXPLAIN ?
On 11/30/2011 01:43 PM, Tomas Vondra wrote:
On 30 Listopad 2011, 17:23, BK wrote:
Hi Albe,
On Nov 30, 2011, at 2:31 PM, Albe Laurenz wrote:
Verify the current setting with
SELECT setting, source, boot_val, reset_val,
sourcefile, sourceline
FROM pg_settings WHERE name = 'wal_level';
El 05/11/11 01:51, Steve Murphy escribió:
I give! I'm flummoxed!
Here is what I have, 3 tables:
schedule
companybuilding status0
3 x active
4 x active
5 x active
3
El 02/11/11 22:40, Martín Marqués escribió:
2011/11/2 John R Piercepie...@hogranch.com:
On 11/02/11 11:21 AM, Martín Marqués wrote:
Don't worry, they are both x86 arch, so I'll just install 32bit
postgresql on the 64 bit server. That should make it work, right?
yes, that should work fine.
El 20/10/11 14:13, Martín Marqués escribió:
El día 19 de octubre de 2011 23:20, Jeff Davispg...@j-davis.com escribió:
On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote:
The only concern I have is that on insertion, I get this WARNING:
WARNING: nonstandard use of \\ in a string literal
On 10/06/2011 09:22 AM, Robert Buckley wrote:
Hi,
this works ok in pgadmin3
select name[i], kw[i]
from ( select generate_series(1,6) as i,
array['Biomasse', 'Deponiegas', 'Solar', 'Wasser',
'Wind','GESAMT'] as name,
array[biomasse_kw, deponiegas_kw,
On 10/03/2011 09:50 PM, John R Pierce wrote:
On 10/03/11 3:09 PM, Merlin Moncure wrote:
libjvm.so = /usr/lib/libjvm.so (0x00cfc000)
I've never heard of a Sun JRE in /usr/lib
are you using (eeew) GCJ ?
He is using...
merlin@mmoncure-ubuntu:~$ ls -l /usr/lib/libjvm.so
lrwxrwxrwx
On 08/30/2011 02:13 PM, Scott Ribe wrote:
On Aug 30, 2011, at 10:03 AM, JD Wong wrote:
How can I set postgres to qutomatically close connections that have finished
their queries and now sit idle?
AFAIK you can't, you should check |pg_terminate_backend function and see
if it is useful for you
On 08/18/2011 03:20 PM, alexondi wrote:
Hi!
Can I call initdb with some params as regular user (not root or postgres)?
postgres is a normal userso no problem at all.
initdb cannot be run as root
May I have some problem with replication, backup or with some other
subsystem?
Thank you!
--
select current_setting('search_path') union select version();
Regards
Rodrigo
On 08/01/2011 06:07 PM, Konstantin Izmailov wrote:
Is it possible instead of executing following two statements:
SHOW search_path; SELECT version();
to execute just one statement returning both search_path and
On 07/28/2011 03:09 PM, Michael Nolan wrote:
On Thu, Jul 28, 2011 at 12:23 PM, Andy Colson a...@squeakycode.net
mailto:a...@squeakycode.net wrote:
On 7/28/2011 11:40 AM, Michael Nolan wrote:
Why does this query succeed:
select count(*) from tablename where xmin = 2
On 07/09/2011 12:56 PM, Jonathan Camilleri wrote:
/Notes for Windows users/
http://www.postgresql.org/docs/9.0/static/app-psql.html
must be replication for the replication user
Regards
Rodrigo Gonzalez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
don't grant the user access to all database objects
I hope I am clear in my poor English
Regards
Rodrigo Gonzalez
On 06/07/2011 08:38 PM, owen marinas wrote:
Thx, Merci, Gracias Rodrigo
it worked indeed, Im wondering why replication is not included in All
regards
Owen
On Tue, Jun 7, 2011 at 2
Maybe this link can help you http://vimeo.com/channels/postgres
On Tue, 2 Nov 2010 22:11:34 +0100
Aljoša Mohorović aljosa.mohoro...@gmail.com wrote:
it's very hard to find postgres related videos although i regularly
read various blog posts mentioning some talk/conference.
is this because
It is defined in postgresql.conf
unix_socket_directory = '/var/run/postgresql'
On Tue, 07 Sep 2010 17:20:24 -0700
John R Pierce pie...@hogranch.com wrote:
On 09/07/10 5:15 PM, Scott Ribe wrote:
Assume I want to install an instance of postgres such that it
cannot interfere with another
Rodrigo Gonzalez
signature.asc
Description: PGP signature
Did you reload postgres configuration after changing pg_hba.conf?
On Mon, 2010-02-01 at 08:36 -0800, Christine Penner wrote:
Hi,
I'm having trouble getting a connection to Postgres to work from
outside of my local network. It was working fine at one point. Then I
had to change IP
Check
http://petereisentraut.blogspot.com/2009/07/how-to-find-all-tables-without-primary.html
On Fri, 2010-01-15 at 11:39 -0500, akp geek wrote:
Dear all -
I have the following query to find the tables with
primary keys. can you please help me finding the tables without
On 05/30/2009 07:02 PM, Kenneth Tilton wrote:
I am probably breaking the rules here which is why I have a problem, but
here goes: I am trying to build an audit trail skeleton of all my table
inserts. Everything table has a column for the serial ID of an audit
trail table row I will create for
you have to change RETURN NULL; with RETURN NEW;
On 05/21/2009 04:57 PM, Karl Nack wrote:
I'm attempting to create an inventory of trees. Here's a simplified,
sample table:
CREATE TABLE tree (
tree_id SERIAL PRIMARY KEY,
tree_species_id INT NOT NULL REFERENCES tree_species,
tree_location
Use quotes, there is a space between program and files
pg_ctl reload -D c:\program files\postgresql\8.3\data
On Sat, 2009-02-14 at 15:31 -0800, Bob Pawley wrote:
I'm running 8.3 on Windows XP.
I input pg_ctl reload -D c:\program files\postgresql\8.3\data- or any
combination thereof,
David Wall wrote:
Is there a way to get the PG version string from JDBC? I'm using PG 8.3.
Thanks,
David
SELECT version() ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
x asasaxax wrote:
Hi everyone,
I have the following sql script:
CREATE SEQUENCE public.teste_seq
INCREMENT 1 MINVALUE 1
MAXVALUE 32767 START 1
CACHE 1 CYCLE;
CREATE TABLE public.teste (
id SMALLINT DEFAULT nextval('teste_seq'::regclass) NOT NULL,
CONSTRAINT id_pk
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
Tom Lane wrote:
No, it's clear that things are already broken before pg_dump started.
You need to show us how to get to this state from a fresh database.
Interestinga new problem maybe, or maybe the same one
...
ERROR
Alban Hertroys wrote:
On Jun 26, 2008, at 5:41 AM, Rodrigo Gonzalez wrote:
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
Craig Ringer wrote:
What platform are you using?
It's running under CentOS 4.4 using ext3, no RAID or LVM.
Server is quad xeon 64 bits 3 GHz
Ugh, I'd
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
pg_dump is working fine now, the problem appear with the pg_buffercache
query...without it I dont notice anything wrong with DBbut of course
there is something wrong. Can be pg_buffercache the problem?
Oh ... looking again
tracing before
attempting to trace a process. The following command is sufficient to
disable tracing on all user owned processes, and, if executed by root,
all processes:
$ ktrace -C
So, read man page, and at least ktrace -C and read the output at
ktrace.out file.
Best regards
Rodrigo
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
Dont know exactly what you mean, if you are talking about the moment
that I receive the error...
No, it's clear that things are already broken before pg_dump started.
You need to show us how to get to this state from a fresh
?
Thanks
Rodrigo Gonzalez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Craig Ringer wrote:
Rodrigo Gonzalez wrote:
PgSQL is returning that error when I open pgdmin and when I run some
queries related to pg_buffercache. Also pg_dump cannot dump the DB.
PgSQL version is 8.3.3 and happened one day after loading the DB there.
What platform are you using
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
PgSQL is returning that error when I open pgdmin and when I run some
queries related to pg_buffercache. Also pg_dump cannot dump the DB.
PgSQL version is 8.3.3 and happened one day after loading the DB there.
That raises a lot
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
It had been working with pgsql 8.1 and 8.2 for 2 years without problems.
Suspicious is that problems started next day I've upgraded to 8.3.
Did you update anything else at the same time?
regards, tom lane
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
Tom Lane wrote:
Did you update anything else at the same time?
No, just postgres was updated
Well, that does start to sound like it could be a PG bug; but no one
else is reporting anything like it. Can you put together a
self
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
Craig Ringer wrote:
What platform are you using?
It's running under CentOS 4.4 using ext3, no RAID or LVM.
Server is quad xeon 64 bits 3 GHz
Ugh, I'd have liked to think RHEL4/Centos4 would be more reliable than
that :-(. Still
Tom Lane wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] writes:
Basically I should reinstall again PG with the same configuration and
wait 1 night. Any log you need or want? anything to do besides doing the
same I did?
Umm ... if I reinstall PG and wait one night, I'm quite sure that
nothing
E.J. Moloney escribió:
I am running the following query
update tempportfwdconnectiona set srcid=interface.objectid from
interface where tempportfwdconnectiona.hostid=interface.host and
tempportfwdconnectiona.spantreeport=interface.stpport
For application reasons the spantreeport in one
Are you sure?
\d IN
Let us know if you have OTHER table called IN.
When you use quotes you are making them case sensitive, so in != IN
!= In etc, etc
David Gagnon escribió:
Hi Adam,
It worked Thanks!! But there is definitly something wrong with the error
message I got (right?):
Rob Collins escribió:
Hello
We're looking for an open-source database solution that has a Python
interface and will do master-master replication. My client has a
flawed MS SQL Server system, with the replication hand-coded in
Python. They don't want to pay very high licence fees for the MS
Using star replication I have all the nodes as masterso n
master-master replication with the common DB as master to all the nodes
and all the nodes as master to the common DB
Alvaro Herrera escribió:
Julio Cesar Sánchez González wrote:
El mié, 16-04-2008 a las 12:13 +0100, Rob Collins
Yes and no
bucardo cannot handle master-master-master
What I am doing is
masterA-masterB
masterA-masterC
masterA-masterD
That is something that bucardo can handle and allow me to replicate
masterB-masterC but everything goes thru masterA always
Alvaro Herrera escribió:
Rodrigo
anything better that work with pgsql
Alvaro Herrera escribió:
Rodrigo Gonzalez escribió:
Yes and no
bucardo cannot handle master-master-master
What I am doing is
masterA-masterB
masterA-masterC
masterA-masterD
Oh, I see -- makes sense. Quite misleading docs
Roberts, Jon escribió:
I am moving from Windows to Solaris and I need pgcrypto and dblink.
Where are these? I don't see anything in the configure that suggests it
is even an option.
Jon
They are contribs, you have to install them after pgsql
smime.p7s
Description: S/MIME Cryptographic
Justin escribió:
Have a select statement with a where clause using datestamp with
timezone column compared to a date
Select * from sometable where DateStampColumn '2008-03-31'
this returns records that are equal 2008-03-31
but when the query includes casting to date
Select * from sometable
Zdeněk Kotala escribió:
Hello All,
I prepared patch for renaming postgreSQL script tools like createdb,
createuser, etc. to pg_createdb, pg_creteuser. Original names will be
kept for 2 or 3 following versions. The main reason for the patch is
to avoid possible clash of names with systems
Edward Blake escribió:
Thanks to everyone who's helped me before.
I'm trying to create the following mysql table in postgres:
CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
Bill Wordsworth escribió:
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't
Edward Blake escribió:
The table I have in MySQL is similar to below:
0 SET FOREIGN_KEY_CHECKS=0;
1 CREATE TABLE products (
2 product_id integer(11) not null auto_increment,
3 product_name varchar(255) not null,
4 product_descrition varchar(255) not null,
5 class_id
Steve Clark escribió:
Hello List,
I can't seem to figure out what is this code that worked on 7.4.x.
I've added cast to everything but still
get:
postgres error log:
ERROR: operator does not exist: text = integer
HINT: No operator matches the given name and argument type(s). You
might
Tri Quach escribió:
Hi All,
I am not sure which RHEL is on my server.
[EMAIL PROTECTED] pq8.2.6]# uname -a
Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT 2004
x86_64 x86_64 x86_64 GNU/Linux
Thank you for your help.
Tri.
cat /etc/redhat-release
smime.p7s
Tyler, Mark escribió:
Hi,
I am trying to set up a PostGreSQL database to send asynchronous
notifications when certain inserts or updates are performed on the
tables. The idea is I want to have publish / subscirbe model with the
database in the centre as the information hub. An application
DELETE FROM table WHERE id NOT IN (SELECT id FROM table ORDER BY
id DESC LIMIT 50)
Sean Z. escribió:
Hi,
I need to write a maintenance function to delete oldest records of a
table, leaving only a certain number of records, say 50. The task
should run once per day. How can I write it?
The
Bob Pawley escribió:
The documentation states that PostgreSQL does not support updating
data via a cursor.
Has that changed in the last little while.
Bob Pawley
I think that is in 8.3 beta, take a look to release notes
smime.p7s
Description: S/MIME Cryptographic Signature
Richard Huxton escribió:
Stefan Schwarzer wrote:
Hi there,
if I order a given year in DESCending ORDER, so that the highest
values (of a given variable) for the countries are displayed at the
top of the list, then actually the NULL values appear as first.
Only below, I find the values
Alexander Staubo wrote:
On 6/2/07, Guy Rouillier [EMAIL PROTECTED] wrote:
Have you looked at raidb? http://c-jdbc.objectweb.org. Narrow niche,
but if it happens to be the one you are in, then it's an option. I took
a quick look at the user's page, and both of them were using PostgreSQL.
Joshua D. Drake wrote:
Well no. PHP is not a professional language because it has no really
design - and that has nothing to do with the fact it beeing a scripting
language. Its a bad scripting language. (Say namespaces for example,
confusing function interfaces, unicode flaws, missing usable
Erick Papadakis wrote:
So how should I make a database rule in MySQL to not allow blank
strings. Basically to REQUIRE a value for that column, whether it is
NULL or NADA or VOID or whatever you wish to call it. I just want to
make sure that something, some value, is entered for a column. Would
Andrew Edson wrote:
I need to add a system to our postgres pg_hba.conf file; the main server
went down a few days ago, and this system was mistakenly left off the
list of allowed systems when the server was brought back up. (Older
version of the .conf file; I managed to accidentally delete
Tony Caduto wrote:
I had installed the win32 version awhile ago, but I had the pg_hba.conf
set to trust. Then I started to test SSL on win32 so I changed it to this:
hostall all 127.0.0.1/32 md5
hostall all 192.168.15.131/32 md5 #my pcs
James Neff wrote:
Greetings,
Ive got a java application I am reading data from a flat file and
inserting it into a table. The first 2 million rows (each file
contained about 1 million lines) went pretty fast. Less than 40 mins to
insert into the database.
After that the insert speed is
Joshua D. Drake wrote:
On Fri, 2006-12-29 at 13:21 -0500, James Neff wrote:
Joshua D. Drake wrote:
Also as you are running 8.2 you can use multi valued inserts...
INSERT INTO data_archive values () () ()
Would this speed things up? Or is that just another way to do it?
The fastest way
search_path=$user in postgresql.conf
and you create one schema for each user with the user name as name
Rodrigo
John McCawley wrote:
It seems that this approach would suffer the same problem as the one I
outlined in 1) Actually separate client data by table. I would have
to modify the
Really, I dont see the 3 varchar fields concatenated to a new field.
But do this
(varchar1||varchar2||varchar3||newfield)::varchar
Best regards
[EMAIL PROTECTED] wrote:
Last week I upgraded to postgresql 8.1.4 (YEAH!) In my database I
have a view which concatenates three varchar
SELECT b.ltname, ((c.refullname::text || d.enname::text) ||
f.evname::text)::varchar AS evlinkname1,
[EMAIL PROTECTED] wrote:
Rodrigo Gonzalez [EMAIL PROTECTED] wrote on 08/07/2006 11:36:28 AM:
Really, I dont see the 3 varchar fields concatenated to a new field.
But do this
(varchar1
I'm not an expert as you, but what about a small table where just one
user can read and create the function with this same user and definer
security?
Excuse if I say something stupid
Alvaro Herrera wrote:
Tom Lane wrote:
* Any database user is most of the time able to read function
Check where you are executing this.the user postgres does not have
permission to write logfile in your current directory
Victor Escobar wrote:
Hello,
I'm getting the following error when I do this step:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data logfile 21
Exit 1:
I dont know the answer to your question, but I think that you forgot
somethingmost linux distributions have postgresql included.so,
(I dont know the number) some people that use it, didnt download from
postgresql site or mirrors...
Ilir Gashi wrote:
Hello,
My name is Ilir Gashi and
Just to be sure
Any error msg in log?
Maybe you can run this query in psql and see if it return any error msg
Best regards
Rodrigo
HH wrote:
Hello,
I am running 8.1.3, built from source, on RHEL4/x64.
I have a Web application that uses this database to sell products. We have
an order
Disable php on Apache if you dont use itLoadModule php4_module
Rich Shepard wrote:
On Thu, 19 Jan 2006, Joshua D. Drake wrote:
If it is slackware I have no idea but on fedora it would be something
like php-pgsql.
Josh,
I've searched the Slackware package repository and there
Directory permissions for user the user running the service?
Ottó Havasvölgyi wrote:
Magnus,
It's a service, and it is 8.0.6. I have fixed the registry to this
value: C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe runservice -N
pgsql-8.0 -D E:\PostgreSQL\data\
The service does not start.
dont use user '
Andrew Toth wrote:
Dear List,
I have managed some small databases with FoxPro, but something is not
known by me to manage postgresql databases :(
I had created a database as 'postgres' user and I tried the following
as 'postgres' user too under Debian SID with
I answer here so each one can help you.
Cannot understand what you meanindex is numbered? Are you talking
about autoincrement as called in mysql? use sequences please
Best regards
Rodrigo
Poul Møller Hansen wrote:
Rodrigo Gonzalez wrote:
Poul,
2 thingsfirst, why do you think
want and why you want to know exact row count
someone can help you
Poul Møller Hansen wrote:
Rodrigo Gonzalez wrote:
I answer here so each one can help you.
Cannot understand what you meanindex is numbered? Are you talking
about autoincrement as called in mysql? use sequences please
Poul,
2 thingsfirst, why do you think it will have an impact on inserts?
And the second oneuse InnoDb tables in MySQL, and you will have the
same than with PostgreSQL, it's because of MVCC
Best regards
Rodrigo
Poul Møller Hansen wrote:
I can see it has been discussed before, why
select version()
Zlatko Matić wrote:
Hello.
Is there any way to check the
version of PostgreSQL by a query? Maybe by querying catalog tables?
Thanks,
Zlatko
85 matches
Mail list logo