On Tue, 22 Oct 2002, Igor Georgiev wrote:
> > > edit *pg_hba.conf *
> > > # Allow any user on the local system to connect to any
> > > # database under any username, but only via an IP connection:
> > > host all 127.0.0.1 255.255.255.255trust
I have just installed redhat 8.0. It comes with postgresql rpms for
7.2.2. I have been trying to get an
application I have written to work, but my queries fail whenever I have
queries that use internal
date/time formatting functions.
example:
SELECT a.assignmentid AS "id",
u.lastname || ', ' ||
Title: newbie psql - Backup/Restore - database
Hello all,
I just convert a MSQL database to PSQL and wondering if someone can help me to duplicate or restore a database in a short period. Here is what I have done.
Backup database:
pg_dump -C -D -n -f backupDB.psql users
Duplicate da
we had someone make a php app that was a form fill-in type of questionaire.
They stored all data into postgres as vchar type columns. Now the problem we
have is that
1) rows retrieved from select include cr/lf chars from the form, makeing a row
multi lines long
2) rows are so long that their
Hello!
One of my harddrives crashed two day ago. Only the /lib och /usr
directories was on one of my other hd's.
The old hd can no longer be detected by the bios. I have reinstalled
everything now.
The data directory in the old /lib contains what I would guess is
postgresqls table data. Can I re
Hi,
is there an SQL command that just prints a line? I want to do sth like:
-- SQL query
print "Now displaying cities...";
SELECT * from cities;
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe
On Wed, 23 Oct 2002, Gareth Kirwan wrote:
> Gareth StationeryFurther information:
>
> I've now tried this ( I would have tried it first but the server was having
> it's nappy changed.
> It seems to have a problem with the notion that the individual items of the
> array are the references to the id
On Mon, 21 Oct 2002, Nguyen, Dan wrote:
> Hello all,
>
> I just convert a MSQL database to PSQL and wondering if someone can help me
> to duplicate or restore a database in a short period. Here is what I have
> done.
>
> Backup database:
>pg_dump -C -D -n -f backupDB.psql users
>
> Duplicate
On Tuesday 22 October 2002 19:46, Markus Dehmann wrote:
> Hi,
>
> is there an SQL command that just prints a line? I want to do sth like:
>
> -- SQL query
> print "Now displaying cities...";
> SELECT * from cities;
By definition SQL doesn't have any output formatting
functions; those are provided
Hello there
Is it possible to use a pg_dump like command from within a sql statement
and write the data/schema to an ascii file on the harddisc ?
I have a scheduler running and it writes log messages about db actions
into a log db.
When i need to run pg_dump with cron I don't see these messages
Title: Gareth Stationery
I've tried creating the db again - with -D,
on another server... and it's not working.
To clarify things I'm not going to post
exactly what happened... spot the mistake - PLEASE.
[root@carsplus structure]$ su - postgresbash-2.05$
initlocation 'PGDATA2'The location w
Hi
all!
I would like to know if there is a way to create more then one
postgresql
shared memory in the same machine.
I know the database is handled by shared memory, but it
seems
impossible
to stablish a shared memory number, which is common
in unix
programming.
Is that true
Not
sure if this is relevant - but ipcs will show it as allocated a shared memory
semaphore array under the mm library.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Elielson
FontaneziSent: 23 October 2002 18:34To: pgsql-admin;
pgsql-
On Thu, Oct 17, 2002 at 06:47:23AM -0500, D. S. Johnson wrote:
> As most DB's know to get full integrity in a backup you either have to
> perform cold backups or have a point in time capable hot backup. If
> Postgresql is truely useful as a production database you need a full
> point in time backup
On Tue, 22 Oct 2002 13:46:37 -0400, Markus Dehmann wrote:
> Hi,
>
> is there an SQL command that just prints a line? I want to do sth like:
>
> -- SQL query
> print "Now displaying cities...";
> SELECT * from cities;
Try \qecho:
\qecho Now displaying cities
SELECT * FROM cities;
Otherwise yo
>
>
> Hello!
>
> One of my harddrives crashed two day ago. Only the /lib och /usr
> directories was on one of my other hd's.
Do you mean /lib which contained the $PGDATA is still accessable.
please try to locate the folder named "data" that contains folder like
base, pg_xlog , global , pg_clog
CONGRATS!!
if your DB size is small consider pg_dumpall ing every nite and store it in a different
machine :-)
Regds
MALLAH.
> SOLVED!!
>
> I tried a tip of a earlier post
> - I wiped the new disk clean of all postgres packages.
> - I moved the old postgres lib dir to /var/lib/postgresql
> - d
when we execute
nmake /f win32.mak
we are getting a follwoing error
cd include
if not exist pg_config.h copy pg_config.h.win32 pg_config.h
cd ..
cd interfaces\libpq
nmake /f win32.mak
Building the Win32 static library...
No configuration specified. Defa
Title: Gareth Stationery
I just wanted to check that this is the
right syntax for a table.
CREATE
TABLE articles (
id
INT PRIMARY KEY DEFAULT
nextval('articles_seq'),
category
INT,
type
INT,
title
VARCHAR(50),
Title: Gareth Stationery
Correction: The [] should
have been after the INT, not the related :-)
Otherwise, as posted.
Gareth
-Original
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Gareth
KirwanSent: 23 October 2002 10:27To:
[EMAIL PROTECTED]
Title: Gareth Stationery
Further information:
I've now tried this ( I would have tried it
first but the server was having it's nappy changed.
It seems to have a problem with the notion
that the individual items of the array are the references to the id, rather than
the array itself.
How can
21 matches
Mail list logo