On 31 out, 07:33, [EMAIL PROTECTED] (João Paulo Zavanela) wrote:
> 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 versio
Hi people. I have 2 databases named as follows:
1) company_a
2) company_b
These two databases do not have the same ER model. However, I want to
access tables on "company_a" there are in "company_b". I want to use
them as local tables (as other databases like Sybase allows, since you
have opened
On 31 out, 06:56, [EMAIL PROTECTED] (Joao Miguel
Ferreira) wrote:
> Hello all,
>
> I got surprised by this message:
>
> -
> The program "pg_dump" is needed by pg_dumpall but was not found in the
> same directory as "/usr/bin/pg_dumpall".
> Check your installation
On 31 out, 12:01, [EMAIL PROTECTED] (Craig White) wrote:
> I wrote a little script to individually back up table schemas, table
> data and then vacuum the table and it works nicely but I wanted a way to
> query a database and get a text file with just the table names and
> cannot figure out a way t
On 31 out, 11:00, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> The Amazon Dynamo framework is going to replace RDBMS?
>
> http://www.readwriteweb.com/archives/amazon_dynamo.php
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
"createdb: database creation failed: ERROR: encoding LATIN1 does not
match server's locale Portuguese_Brazil.1252
DETAIL: The server's LC_CTYPE setting requires encoding WIN1252."
On PostgreSQL 8.2.5 I'm able to create data d
I'm using Microsoft Visual Foxpro 9 developing an ERP application,
using PostgreSQL 8.2.5 and ODBC connection in version 7.
If I upgrade my ODBC drivers to use "PostgreSQL ANSI", becomes an
error like this:
"function saldo_estoque("unknown", "unknown", "unknown", "unknown",
timestamp without time
On 20 nov, 12:35, [EMAIL PROTECTED] (Reg Me Please) wrote:
> Il Tuesday 20 November 2007 15:01:53 T.J. Adami ha scritto:
>
>
>
> > I'm using Microsoft Visual Foxpro 9 developing an ERP application,
> > using PostgreSQL 8.2.5 and ODBC connection in version 7.
>
>
On Dec 19, 4:23 pm, [EMAIL PROTECTED] (Geoffrey) wrote:
> Joshua D. Drake wrote:
> > Geoffrey wrote:
> >> Johan van Zyl wrote:
> >>> Please elaborate! (Many a true word spoken in jest)
> >>> "That is until I can convince my new employer to realise the dark side
> >>> of Microsoft SQL Server."
>
> >
On 14 jan, 17:02, "Andrus" <[EMAIL PROTECTED]> wrote:
> create temp table test (col char);
> select count(col) from test order by col;
>
> causes
>
> ERROR: column "test.col" must appear in the GROUP BY clause or be used in
> an aggregate function
> SQL state: 42803
>
> How to fix this ?
> This st
On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote:
> Having recently jumped ship from MSSQL to Postgres I'm finding it a
> little difficult getting onto the 'correct path.' Basically I have a
> live database and I want to take a copy of that and then restore it
> onto a backup server.
>
> Fi
On 14 jan, 09:08, [EMAIL PROTECTED] (Ashish Karalkar) wrote:
> Hello list members,
> I hav a table with 140M rows. While I am trying to select the count from the
> table
> I am getting following error
> ERROR: shared buffer hash table corrupted
> Can anybody please suggest me wht had gone wrong a
On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote:
> > It's quite simple to have problems with pgAdmin's backup procedure.
>
> Hmm - shouldn't be, and if so then please let the pgAdmin people know!
> They're always working to improve the package and it's
>
I think the same. We (company I
with
extraordinary success in his ministry, in the conversion of many souls.
He had five harvests, as he called them. The first was about 57 years
ago; the second about 53; the third about 40; the fourth about 24; the
fifth and last about 18 years ago. Some of these times were much more
remarkable
fervent with love. Princes abandoned
their pomp; maidens suffered martyrdom. Whence came this influence? The
Messiah was come. These were the effect and sign of His coming.
773. Destruction of the Jews and heathen by Jesus Christ: Omnes gentes
venient et adorabunt eum.156 Parum est ut,157 etc. Pos
shall be sprinkled on his
garments, so as to stain all his raiment. He will not only hate you, but
he will have you in the utmost contempt: no place shall be thought fit
for you, but under his feet to be trodden down as the mire of the
streets.
The misery you are exposed to is that which God wil
the others in
their vastness. For who will not be astounded at the fact that our body,
which a little while ago was imperceptible in the universe, itself
imperceptible in the bosom of the whole, is now a colossus, a world, or
rather a whole, in respect of the nothingness which we cannot reach? He w
On 22 jan, 22:46, [EMAIL PROTECTED] ("Jamiil Abduqadir") wrote:
> I am trying to install PosgreSQL using postgresql-8.3-dev1 on my WindowsXP
> machine, but I get a message that reads
>
> Fail to create a temporary directory
>
> Does anyone know why I am getting this error message?
>
> Thank in adva
On 22 jan, 05:02, [EMAIL PROTECTED] (Julio Cesar
Sánchez González) wrote:
> Jon Hancock wrote:
> > The INSTALL file for postgresql 8.3rc1 lists the following install
> > instructions:
>
> > ./configure
> > gmake
> > su
> > gmake install
> > adduser postgres
> > mkdir /usr/local/pgsql/data
> > chown
On 29 jan, 18:42, cbmeeks <[EMAIL PROTECTED]> wrote:
> I love MySQL but I'm concerned about it's future. And, I'm always
> looking to learn something new. I love the licensing model of
> Postgres.
>
> Anyway, using online documentation, I've managed to get a server
> running but I find myself con
On 30 jan, 04:14, Jon Hancock <[EMAIL PROTECTED]> wrote:
> I have compiled postgres 8.3rc2 on ubuntu 7.04 and seem to a have
> working install.
> To start postgres, I do the following:
>
> > su postgres
> > /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data &
>
> ok, that works for dev mode. B
How I can recover data (or replicate data to another) based on
postgresql logs?
Where they are, and how I do it?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
I'm trying to install PostgreSQL 8.3 RC2 for Windows on my Windows
Vista Home Premium (Brazillian Portuguese), and thus I'm getting an
error on 'initdb' after copy of all files into destination path.
The error is this:
"Failed to run initdb: 1!
Please see the logfile in 'C:\Program Files\PostgreS
On 31 jan, 12:24, [EMAIL PROTECTED] ("Daniel Verite") wrote:
> T.J. Adami wrote:
>
> > I am also searching for a more 'professional' way to startup and
> > shutdown postgresql on ubuntu and debian systems.
>
> The source comes with a start
On 4 fev, 18:13, "Andrus" <[EMAIL PROTECTED]> wrote:
> I need to perform case insensitive search by first some characters (ABC) of
> name like
>
> SELECT ...
> FROM customer
> WHERE upper(customername) like 'ABC%'
>
> My database cluster locale is non-C
> Database encoding is UTF-8
>
> Which index
On 13 fev, 12:19, Hermann Muster <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I encountered something I can't really explain. I use the following
> statement in my application:
>
> COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')
>
> This returns "ERROR: syntax error at end of input"
>
> However, using the fol
I know that using tablespaces I can create a vertical partition by
creating two tables with the same primary key wich stores different
columns in each table.
However, I need to do some horizontal partition that receives about
2,000,000 records per month.
What the best way to perform this horizont
27 matches
Mail list logo
