How would i go about starting postgresql when the machine boots
i am running linux mandrake 7.01 with the latest version of postgresql
and i just got confused with the install document
please can some one help me
thank you
antken
---(end of broadcast)---
Hello
I'm a portuguese student, and i have project in university and I need help,
about authentication to my postgresql database.
If you can help me, tell me something if you can.
Thanks.
---(end of broadcast)---
TIP 1: subscribe and unsubscrib
ZDE is the best choice, you can try with other softwares using ODBC
conections e.g. Ms-Access, you'll need ODBC driver for pgsql, but ZDE rules
"Peter Misovic" <[EMAIL PROTECTED]> wrote in message
992dn3$cc6$[EMAIL PROTECTED]">news:992dn3$cc6$[EMAIL PROTECTED]...
> Hallo,
> I´m sorry for ma begin
Try PgAdmin
http://www.greatbridge.org/project/pgadmin
"Peter Misovic" <[EMAIL PROTECTED]> wrote in message
992dn3$cc6$[EMAIL PROTECTED]">news:992dn3$cc6$[EMAIL PROTECTED]...
> Hallo,
> I´m sorry for ma beginner guestion, but I want to know, where can I
download
> a graphics GUI for managing my
Is PostgreSQL journalized? Can it be made to do so?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi !
Sorry for my English!
I'm a beginner Linux and PostgreSQL, so I haven't much
experience.I'm using Redhat Linux 7.0Now I want to use Postgres as
frontend to connect MS SQL server on a Windows machine . Is it
possible ?
If you know , please guide me.
Many thanks in
advance
Ola Dood.
Looks like :
A) Your postmaster is not in your default Path add it by
export PATH=$PATH:[path to pgsql bin directory]
B) You are not logged in as the postgres user
su - postgres
C) Your postmaster has disappeared.
Reinstall
D) Your postmaster is not set executabl
is there a good way to handle large objects when backing up a database? the
way it looks is that the large objects are external files on the file system
and are just pointed to by entries in the table. But it looks like when you
dump the database and then try to restore it, the object ids no lon
Hi
I would have expected this problem to have been brought up long ago with
people doing database backups and restores. Anyway below are the details
I am running PostgreSQL v 7.0.3 (upgraded yesterday from 7.0.2) on SuSE 6.3
with 2.2.17(SMP) kernel with S/W raid patch.
The actual database is
Hello,gurus
I find that u reply a topic about "Backend sent D message without prior
T"
problem on usenet, I think u can help me.
I'm new in PostgreSQL, I need to dump a table to another one, so I issue
the
pg_dump command.
but after I execute pg_dump -adt member db1 > /tmp/member.sq
Hi
Thanks for the help, in fact that is Exactly what is wrong. The pg_shadow
table has duplicated entries in it, I think I'm going to create a unique
index on it.
BTW I've migrated the entrie database to PG7.1RC1, running quite a big
search on the database basically involving a huge amount of
antken writes:
> How would i go about starting postgresql when the machine boots
> i am running linux mandrake 7.01 with the latest version of postgresql
> and i just got confused with the install document
> please can some one help me
http://www.postgresql.org/devel-corner/docs/postgres/postmas
ajob writes:
> I'm a portuguese student, and i have project in university and I need help,
> about authentication to my postgresql database.
>
> If you can help me, tell me something if you can.
http://www.postgresql.org/devel-corner/docs/postgres/client-authentication.html
--
Peter Eisentraut
Dear all,
I installed postgresql 7.03 and it works well in the first time.
After I reboot the computer (haven't stop the postgresql first),
I can't start the db server again and the following errors shown:
>postmaster -i -D /path/to/psql/data
FindExec: could not find a postmaster to execute ..
Po
Hi Concerned CItizens
I have a slight (BIG) problem, I can no longer connect to my a certain
database after erroneously creating a unique index on it pg_shadow file.
Below is the exerpt from a previous post that I did but on another
unrelated (semi) thread.
I did this in order to prevent dupli
Hi,
im unsing PostgreSQL as a database backend for my website and therefore it
stores image's and other large objects. As far as I know pg_dump(all) isn't
capable of backing up large objects. So I was wondering how to backup the
image's etc. Is there a script or such which does do the job?
Marti
> Thanks for the help, in fact that is Exactly what is wrong. The
pg_shadow
> table has duplicated entries in it, I think I'm going to create a
unique
> index on it.
Forgive me if I'm wrong about this, but doesn't the SQL Standard
prohibit duplicate rows in a table, unique index or not?
--
On Wed, Mar 28, 2001 at 06:48:27PM -0500, Tom Lane allegedly wrote:
> Mathijs Brands <[EMAIL PROTECTED]> writes:
> > PS_USE_CLOBBER_ARGV -is- used on Solaris. I just checked.
>
> Hm. But 7.1 postgres backends fail to change their ps display?
> Does sendmail change its ps display on your machine?
On Thu, Mar 29, 2001 at 12:30:06AM +0200, Mathijs Brands allegedly wrote:
> On Wed, Mar 28, 2001 at 04:56:15PM -0500, Bruce Momjian allegedly wrote:
> > [ Charset ISO-8859-1 unsupported, converting... ]
> > > whats wrong with /usr/ucb/ps auxw | grep $PGUSER
> > >
> > > to get only the processes
On Wed, Mar 28, 2001 at 04:56:15PM -0500, Bruce Momjian allegedly wrote:
> [ Charset ISO-8859-1 unsupported, converting... ]
> > whats wrong with /usr/ucb/ps auxw | grep $PGUSER
> >
> > to get only the processes for PG?
>
> I can do that if there is no other option, but on my BSDI machine,
> re
On Wed, Mar 28, 2001 at 07:12:39PM -0500, Tom Lane allegedly wrote:
> Mathijs Brands <[EMAIL PROTECTED]> writes:
> > mathijs297 0.1 0.2 6120 3352 pts/1S 01:59:18 0:00
>/opt/pgsql/bin/./postgres mathijs localhost template1 idle
>
> The interesting point about this is that the 7.0.3-on-
Thomas Sattler writes:
> Forgive me if I'm wrong about this, but doesn't the SQL Standard
> prohibit duplicate rows in a table, unique index or not?
You're wrong about this, and you're forgiven. ;-)
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
> How can I "binds" PostgreSQL to consider '' as null ?
You can modify src/backend/utils/{datetime,date,timestamp}.c to accept
an empty string as a null value. But imho it is better to fix this in
your input file, perhaps using sed:
sed "s/''/NULL/g" < informix.dump > pg.dump
Subject: Importing data from Informix to PostgreSQL.
Error in the date field (WITH NULL value)
Hello!
I'll try to explain my little problem. Well, I have this table
create table mytable
( codice char(16) not null,
dt_inizio date,
dt_finedate,
tipo_operaz
"Martijn de Munnik" <[EMAIL PROTECTED]> writes:
> im unsing PostgreSQL as a database backend for my website and therefore it
> stores image's and other large objects. As far as I know pg_dump(all) isn't
> capable of backing up large objects. So I was wondering how to backup the
> image's etc. Is t
25 matches
Mail list logo
