[GENERAL] Executing \i of psql command using libpq library
Hi! How can i get the same behavior of psql -c "\\i './a_lot_of_sentences'" bd user, using the libpq library??? i tried Pqexec(pgconn,"\\i './a_lot_of_sentences'") but didn't work. :( -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] about memory size reported by system.
Hi everyone! I have a doubt about the memory consumed by each connection open. suddenly my server, running postgres 8.3.11, began to run too slowly. Checking the process with: ps -adelfo pcpu,vsz,args | more The processes,related to the connection to the db, each one have a consume of memory near to the 50Mb. by the way i have 50 connections to the db, so i have a reported memory consumed of 2.5M, when i have only 1G in the server. If I modify the shared_buffers value, the report of memory consumed is according with shared buffers value. Should I worry by that? There is a best way to tweak the memory consumed by postgres? -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] undefined symbol PQconnectionNeedsPassword referenced by file pg_ctl.o
Hi, i tried to compile postgres 8.3.13 but i got the next error: Undefined first referenced symbol in file PQconnectionNeedsPassword pg_ctl.o ERROR: Symbol referencing errors. No output written to pg_ctl cc -b elf -O pg_ctl.o -L../../../src/port -lpgport -L../../../src/interfaces/libpq -lpq -L../../../src/port -lpgport -lz -lreadline -lsocket -lm -o pg_ctl What library or object i missing??? by the way i have compiled previous version of postgres like 8.3.11 without this problem. El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido exclusivamente a su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico. The content of this email and its attached files are private and confidential and intended exclusively for the use of the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited. If you have received this email in error please delete it and notify the sender. The company cannot be held liable for unauthorized electronic transmissions or communications, nor for those emitted by non-company individuals and entities. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] why sometimes checkpoint is too slow????
why sometimes checkpoint is too slow and how can i do to avoid that??? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PANIC: ERRORDATA_STACK_SIZE exceeded
hi! i have postgresql 8.3.12 and i got the eror: PANIC: ERRORDATA_STACK_SIZE exceeded This happens after insert 1000 registers on a table every 1 minute during 3 hours. any idea, why this happened??? # - # PostgreSQL configuration file # - # # This file consists of lines of the form: # # name = value # # (The "=" is optional.) Whitespace may be used. Comments are introduced with # "#" anywhere on a line. The complete list of parameter names and allowed # values can be found in the PostgreSQL documentation. # # The commented-out settings shown in this file represent the default values. # Re-commenting a setting is NOT sufficient to revert it to the default value; # you need to reload the server. # # This file is read on server startup and when the server receives a SIGHUP # signal. If you edit the file on a running system, you have to SIGHUP the # server for the changes to take effect, or use "pg_ctl reload". Some # parameters, which are marked below, require a server shutdown and restart to # take effect. # # Any parameter can also be given as a command-line option to the server, e.g., # "postgres -c log_connections=on". Some paramters can be changed at run time # with the "SET" SQL command. # # Memory units: kB = kilobytes MB = megabytes GB = gigabytes # Time units:ms = milliseconds s = seconds min = minutes h = hours d = days #-- # FILE LOCATIONS #-- # The default values of these variables are driven from the -D command-line # option or PGDATA environment variable, represented here as ConfigDir. #data_directory = 'ConfigDir' # use data in another directory # (change requires restart) #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file # (change requires restart) #ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file # (change requires restart) # If external_pid_file is not explicitly set, no extra PID file is written. #external_pid_file = '(none)' # write an extra PID file # (change requires restart) #-- # CONNECTIONS AND AUTHENTICATION #-- # - Connection Settings - listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all # (change requires restart) port = 5432 # (change requires restart) max_connections = 512 # (change requires restart) # Note: Increasing max_connections costs ~400 bytes of shared memory per # connection slot, plus lock space (see max_locks_per_transaction). You might # also need to raise shared_buffers to support more connections. superuser_reserved_connections = 3 # (change requires restart) #unix_socket_directory = '' # (change requires restart) #unix_socket_group = '' # (change requires restart) #unix_socket_permissions = 0777 # begin with 0 to use octal notation # (change requires restart) #bonjour_name = '' # defaults to the computer name # (change requires restart) # - Security and Authentication - #authentication_timeout = 1min # 1s-600s #ssl = off # (change requires restart) #ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers # (change requires restart) #password_encryption = on #db_user_namespace = off # Kerberos and GSSAPI #krb_server_keyfile = ''# (change requires restart) #krb_srvname = 'postgres' # (change requires restart, Kerberos only) #krb_server_hostname = '' # empty string matches any keytab entry # (change requires restart, Kerberos only) #krb_caseins_users = off# (change requires restart) #krb_realm = '' # (change requires restart) # - TCP Keepalives - # see "man 7 tcp" for details #tcp_keepalives_idle = 0# TCP_KEEPIDLE, in seconds; # 0 selects the system default #tcp_keepalives_interval = 0# TCP_KEEPINTVL, in seconds; # 0 selects the system default #tcp_keepalives_count = 0 # TCP_KEEPCNT; # 0
[GENERAL] Relation raltion_name with OID ##### no longer exists
Hi ! i have the above error when i tried to insert a register, How can i solve this issue???' regards . -- 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] Question about SCO openserver and postgres...
On 07/22/2010 05:39 PM, Scott Marlowe wrote: > On Thu, Jul 22, 2010 at 3:24 PM, Edmundo Robles L. > wrote: > >> Hi! >> I have a problem with the max postgres connections on SCO >> Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 >> but this version comes in 2 editions: Starter and Enterprise. >> >> If SCO 5.0.7 only allows 95 ( -3 used by superuser) connections to >> postgres... >> >> Do you know how many connections to postgres can i have with >> OpenServer in Starter Edition or Enterprise edition? >> > Are you sure this isn't just a limit in max_connections in postgresql.conf? > > Yes, i sure. i have the same problem with postgres 7.2 (100 connections) and 8.3.11 (only 95 :-( ) I change the max_connections on postgres , on SCO 5.0.7 set the SHMMAX,SHM* to the maximun value and relink the SCO kernel but always , i have only 95 client connected to postgres no more. That is because we want buy SCO 6.0 but i don't know if we will have the same problem, our programs are developed on SCO so the migration to another operative system is not a choice... for now. By the way i send a mail to SCO but until now they don't answer to me. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Question about SCO openserver and postgres...
Hi! I have a problem with the max postgres connections on SCO Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 but this version comes in 2 editions: Starter and Enterprise. If SCO 5.0.7 only allows 95 ( -3 used by superuser) connections to postgres... Do you know how many connections to postgres can i have with OpenServer in Starter Edition or Enterprise edition? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] about scape characters
Hi!, maybe is a silly question but... Exists some syntax standard to escape especial characters on querys??? i mean, the notation E'\\ to escape especial characters only works in postgres (8.3.11) or this works on oracle, ms sql server too??? regards, eddie. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] getting the last N tuples of a query
Hi! if a want the first 5,10,N tuples of a query (even without order) i just have to do a: select * from table limit 10; but, What can i do to get the last 10 tuples ??? i try to do: select * from table limit -10; :-D but that query return 0 tuples . So, what is the right way to do that with no order -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] OFFTOPIC -- pgpool list is down?????
Do you know if the pgpool list is down???, i sent many emails to the pgpool list but since last week i can't receive any mail from pgpool list , i checktheir web site too, but the last message are of june. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Forcing the use of one index instead other.
Hello there! I have two index with a same field into them like this: create index numberfail on Events (numberfail); and create index failtype on Events (numberfail,eventtype); then i ran explain analyze and always took the numberfail index but i wish the failtype index; this is the query: SELECT * FROM events WHERE numberfail=194 AND eventtype='XXX'; What should i to do to force the use of failtypeindex I though maybe if i delete the index numberfail could works, but i don't know if the another program will fail if the numberfail index does'nt exists. well, thats all for the moment and i appreciate your time in reading this mail!!! See you. -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
FW: [GENERAL] lack in psql console
in the psql prompt try this: \! stty sane Ing. Edmundo Robles Lopez. Analista Programador. -- -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Juan Camilo Marín Sent: Wed 5/13/2009 12:58 PM To: Craig Ringer Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] lack in psql console Hello Craig. Thanks for your answer. I did what you say (use the default size of the terminal) but the problem persist, the psql still start to write the new senteces above the old one, it is to weird. Best regards, 2009/5/10 Craig Ringer > Juan Camilo Marín wrote: > > > => select * from \d summary_table; > > > > The sentense start after "=> select * from" I don't know why this is > > happen. > > Probably a terminal emulation issue. Readline will be sending the wrong > escape sequences to control your terminal or your terminal will be > misbehaving somehow. > > A common cause of readline issues is resizing your terminal window. Try > testing in a terminal window that's the default size. If that works OK, > try resizing it while it's still running the shell, THEN start psql. > > -- > Craig Ringer > -- Life may only be understood backwards but it must be lived forwards -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
FW: [GENERAL] how many connections can i use????
"Edmundo Robles L." writes: > I have a problem with the number of connections on postgres 7.2.1, -->egad ... the number of known bugs in that would curl your toes. -->Think about an upgrade. Do more than just think about it. yes, maybe the upgrade solve that problem, i will try with another version and test it. > I changed the parameters line of postmaster to "-N 128 -B 256" , " > -N 256 -B 512", etc; even modified the max_connections and > shared_buffers on postgresql.conf but i only got 100 connections :-( -->You sure you restarted the postmaster? Yes i sure!, each time i modified the parameter i restart the server :-) > Operative system: SCO OpenServer 5.0.7 --> double egad (and a bit at odds with your sig...) jeje :-) yes , this is because in my work we use SCO but personally i use ubuntu on my desktop pc and laptop. regards, tom lane -- Di NO a la pirateria, usa software libre. Say NO to piracy, use free(dom) software. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] how many connections can i use????
Hello there! I have a problem with the number of connections on postgres 7.2.1, yeah is a quite older :-) but i have it running on SCO OpenServer 5.0.7 and tried to change the number of connections above 100 but, i only got 100 sometimes 101 but no more. I changed the parameters line of postmaster to "-N 128 -B 256" , " -N 256 -B 512", etc; even modified the max_connections and shared_buffers on postgresql.conf but i only got 100 connections :-( I hope the following info, could help to solve the above mentioned: Operative system: SCO OpenServer 5.0.7 SHMMAX=106340761 SHMMIN= 1 SHMALL=512 SHMSEG=6 SHMMNI=100 SEMMNI= 256 SEMMSL=150 SEMMAP=8192 SEMVMX=32767 memsize: 1063407616 thanks in advance, and regards from Mexico. -- Di NO a la pirateria, usa software libre. Say NO to piracy, use free(dom) software. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general