2012/2/15 vossistemas vossiste...@ibest.com.br
Instalei o Postgresql 8.3 no windows 7 como servidor. Em uma estação com xp
estou tentando me conectar e ocorre a seguinte mensagem: FATAL: no
pg_hba.conf entry for host 192.168.1.51, user Vilson, database
postgres, SSL off .
No servidor com
On Fri, Apr 8, 2011 at 1:42 PM, Carlos Mennens carlos.menn...@gmail.comwrote:
I had self signed SSL certificates on my database server but since
then removed them and received updated certificates from the security
team. I removed (backedup) the old server.crt server.key and now
have
On Fri, Apr 8, 2011 at 2:21 PM, Carlos Mennens carlos.menn...@gmail.comwrote:
On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz dsch...@gmail.com wrote:
Hi,
When linking to the certificate and key you should specify the full path.
ln -s /etc/ssl/certs/db1_ssl.crt /full/path/to/db1_ssl.crt
On Mon, Nov 1, 2010 at 1:36 PM, Carlos Mennens carlos.menn...@gmail.com wrote:
I did an upgrade on my database server this past weekend and the
database fails to start. I checked /var/log/postgresql and found the
reason:
[r...@slave ~]# ps aux | grep postgres
root 5189 0.0 0.0 8128
On Tue, Oct 26, 2010 at 2:18 PM, Ozz Nixon ozzni...@gmail.com wrote:
I am the only user on this system right now, and one table select count(*)
took over 20 minutes:
wikitags exists and has 58,988,656 records.
Structure (in pascal) is:
quer.SQL.Add('create table '+DBTags+' (');
On Tue, Sep 14, 2010 at 6:01 PM, Julia Jacobson julia.jacob...@arcor.de wrote:
Hello everybody out there using PostgreSQL,
What is the problem with the following C++ code for the extraction of data
from a BYTEA column to a binary file?
#include stdlib.h
#include stdio.h
#include iostream
On Thu, Apr 8, 2010 at 6:34 PM, sunpeng blueva...@gmail.com wrote:
once i have created mydb and several relations in it,are there any sql
commands used to list all the tables in this mydb?
i noticed there are no database( pg_database.oid) field in pg_class table,so
i can not use
select
2010/2/13 sergio barrera xpbarr...@hotmail.com
Buenas compañeros!
Tengo un problema al cual no le encuentro la lógica. Mi idea es realizar
una copia de seguridad de una base de datos PostgresSQL diaria bajo el
sistema operativo Linux-Ubuntu 9. Para ello primero, he ejecutado el
siguiente
2010/2/13 sergio barrera xpbarr...@hotmail.com
Buenas compañeros!
Tengo un problema al cual no le encuentro la lógica. Mi idea es realizar
una copia de seguridad de una base de datos PostgresSQL diaria bajo el
sistema operativo Linux-Ubuntu 9. Para ello primero, he ejecutado el
siguiente
On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Dannydanny_abra...@bmc.com wrote:
It runs fine with WIN1252.
The error message says something about lc_type.
Tried with various code pages: 850,1252. Nothing goes through.
Any thoughts?
Would you care to mention the PostgreSQL version you are using?
On Mon, Apr 20, 2009 at 9:25 AM, paulo matadr saddon...@yahoo.com.br wrote:
I get this error when make a select below
SELECT * FROM batch.funcionalidade_iniciada where proi_id = x
ERROR: missing chunk number 0 for toast value 458755
SQL state: XX000
Looks like your database repository is
On Wed, Apr 1, 2009 at 3:16 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
I even wrote down the password when I installed the DB and now it doesn't
work!
I have logged in once to the DB through pgAdmin, and choose to store the
password and it said that it was stored in plain text.. where
On Wed, Apr 1, 2009 at 3:50 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Sorry, for the confusion.. just want to make something I wrote more clear:
I tried to add a server and it required the use of a password and not to add
a password.. upon the creation and connection, it says that it
On Sat, Dec 6, 2008 at 8:50 AM, Martin Marques
[EMAIL PROTECTED]wrote:
I was making some table creation on one of our development DB and found
that psql's \dt has problems showing all tables available. Basically, if you
have to tables with the same name in different schemas, only one will be
On Sat, Dec 6, 2008 at 10:00 AM, Martin Marques
[EMAIL PROTECTED]wrote:
Diego Schulz escribió:
Hi,
Schemas are a lot like directories at operating system level (except that
can't be nested).
When you ls (or dir) in /home/martin/ , normally you don't expect to see
/home/johnny/ listed
On Fri, Nov 21, 2008 at 9:50 AM, Ciprian Dorin Craciun
[EMAIL PROTECTED] wrote:
Currently I'm benchmarking the following storage solutions for this:
* Hypertable (http://www.hypertable.org/) -- which has good insert
rate (about 250k inserts / s), but slow read rate (about 150k reads /
On Tue, Nov 4, 2008 at 9:57 AM, Lennin Caro [EMAIL PROTECTED] wrote:
Hi all,
I'm re-writing some functions and migrating bussines
logic from a
client application to PostgreSQL.
I expected something like this to work, but it doesn't:
-- simple table
CREATE TABLE sometable (
id SERIAL
On Tue, Nov 4, 2008 at 2:38 AM, Tom Lane [EMAIL PROTECTED] wrote:
Diego Schulz [EMAIL PROTECTED] writes:
On Mon, Nov 3, 2008 at 10:24 PM, Raymond O'Donnell [EMAIL PROTECTED] wrote:
Just curious - what have you got against currval()? It seems to me that
it would make your life easier
I
On Tue, Nov 4, 2008 at 6:32 PM, Eduardo Arévalo [EMAIL PROTECTED] wrote:
hola quiero crear una base que soporte caracteres en español y le doy este
comando pero no crea la base sino me manda este error:
-bash-3.2$ ./createdb --encoding=LATIN1 sig_spa_prueba
Password:
createdb: database
Hi all,
I'm re-writing some functions and migrating bussines logic from a
client application to PostgreSQL.
I expected something like this to work, but it doesn't:
-- simple table
CREATE TABLE sometable (
id SERIAL PRIMARY KEY,
text1 text,
text2 text
);
CREATE OR REPLACE FUNCTION
Forgot to mention: using 8.3.3 on FreeBSD.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Nov 3, 2008 at 10:24 PM, Raymond O'Donnell [EMAIL PROTECTED] wrote:
On 04/11/2008 01:20, Diego Schulz wrote:
I also tried this (somewhat silly) syntax to circumvent the issue
without resorting in currval:
Just curious - what have you got against currval()? It seems to me
On Mon, Nov 3, 2008 at 8:51 PM, Tom Lane [EMAIL PROTECTED] wrote:
Diego Schulz [EMAIL PROTECTED] writes:
I expected something like this to work, but it doesn't:
CREATE OR REPLACE FUNCTION add_something(text, text) RETURNS INTEGER AS $$
INSERT INTO sometable (id, foo, bar ) VALUES (DEFAULT
23 matches
Mail list logo