Rajiv Rajaian wrote:
Hi all
Im using postgresql-8.0.3-1.
I need to create a new user in postgresql with password ..But it should not
prompt me to get the password ..ie only through command line I've to give
the password as input
Steps i had done are as follows
[EMAIL PROTECTED] ~]# su postgres -
Starting up postgres, I get the log contents below.
Is it really as bad as it suggests, namely that I
need to recover from backup?
The pg_clog directory has the following:
# ls -al pg_clog/
total 1216
drwx-- 2 postgres wheel 512 Jan 17 09:09 ./
drwx-- 10 postgres wheel 512 F
Hi,
Le mardi 19 février 2008, Carol Walter a écrit :
> I have to load a very large database. Is there a command that can
> load data in bulk faster than the copy command does?
The next version of pgloader has been asked to implement some new parallel
loading of a single file, which could speed
Hi Shane
Thanks for u r suggestions
I tried to create user with the following command ..Im getting
authentication error for postgres user
[EMAIL PROTECTED] echo "CREATE USER globus WITH PASSWORD 'globus' CREATEDB;" |
psql -U postgres
psql: FATAL: IDENT authentication failed for user "postgres"
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
phpPgAdmin (ppa) gives ability to edit/delete a row only when it founds
an unique index in the table (or in requested fields for a query) and
the value for the indexed col is not null.
Without unique index (or PK), ppa could not determine a WH
Hi vishal
While running it as "root" user Im getting
[EMAIL PROTECTED] ~]# echo "CREATE ROLE globus WITH PASSWORD 'globus'
CREATEDB;" |
psql -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
Also with "postgres" user getting the same error
[EMAIL PROTECTED] ~]$ echo "CR
Hi Vishal
Now I m able to create new user using command line
I ve created a database named 'postgres' for postgres user and I ve created
the new user in comand line
The steps I ve used
[EMAIL PROTECTED] ~]# su postgres -c "createdb postgres"
could not change directory to "/root"
CREATE DATABA
Darren Reed <[EMAIL PROTECTED]> writes:
> Starting up postgres, I get the log contents below.
> Is it really as bad as it suggests, namely that I
> need to recover from backup?
Probably :-(
pg_resetxlog would let you into the database, but I do not have high
hopes about the consistency/correctnes
Tom Lane wrote:
Darren Reed <[EMAIL PROTECTED]> writes:
> Starting up postgres, I get the log contents below.
> Is it really as bad as it suggests, namely that I
> need to recover from backup?
Probably :-(
I've started a new db in parallel with the old data and I'm rebuilding,
and if I can reb
Darren Reed <[EMAIL PROTECTED]> writes:
> # su postgres -c "/usr/pkg/bin/pg_resetxlog -f /data/db"
> Transaction log reset
> PANIC: could not access status of transaction 4570963
> DETAIL: could not read from file "pg_clog/0004" at offset 90112:
> Undefined error: 0
You may need to append a fe
Tom Lane wrote:
Darren Reed <[EMAIL PROTECTED]> writes:
> # su postgres -c "/usr/pkg/bin/pg_resetxlog -f /data/db"
> Transaction log reset
> PANIC: could not access status of transaction 4570963
> DETAIL: could not read from file "pg_clog/0004" at offset 90112:
> Undefined error: 0
You may
On Mittwoch, 20. Februar 2008 Tom Lane wrote:
> 5. Figure out why a simple power failure was able to do this to you,
> and fix it. The most likely bet is that your disk drives are lying
> about write completion ... see the PG archives for discussion.
It could be a caching RAID controller without
Hi All,
Wanted to know what does pg_ctl do in the background when we run *pg_ctl
-D datadir reload *
After modifying the entries in pg_hba.conf file we ran the reload
command. Generally, it just reloads the files and everything works fine.
But strangely, last time when we ran the reload comma
13 matches
Mail list logo
