2012/2/15 vossistemas
>
> 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 windows 7 está
On Fri, Apr 8, 2011 at 2:21 PM, Carlos Mennens wrote:
> On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz 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 Fri, Apr 8, 2011 at 1:42 PM, Carlos Mennens wrote:
> 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 db1_ssl.crt & db1_ssl.key i
On Mon, Nov 1, 2010 at 1:36 PM, Carlos Mennens 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 956 pts/0 S+
On Tue, Oct 26, 2010 at 2:18 PM, Ozz Nixon 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+' (');
> quer.SQL.Add('
On Tue, Sep 14, 2010 at 6:01 PM, Julia Jacobson 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
> #include
> #include
> #include
> #include "libpq-fe.h"
> us
On Thu, Apr 8, 2010 at 6:34 PM, sunpeng 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 relname from pg_class
2010/2/13 sergio barrera
> 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 comando en el ter
2010/2/13 sergio barrera
> 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 comando en el ter
On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Danny 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?
Also, the exact c
On Mon, Apr 20, 2009 at 9:25 AM, paulo matadr 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 corrupted and/
On Wed, Apr 1, 2009 at 3:50 PM, Jennifer Trey 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 failed. The
> Server
On Wed, Apr 1, 2009 at 3:16 PM, Jennifer Trey 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 can I find it?
> in
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 yo
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
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 rea
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: databas
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 somet
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
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
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 go
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
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 add_s
23 matches
Mail list logo
