What is Slony? I have a super user account for the server and the database.
Joshua D. Drake wrote:
On Thu, 2008-06-12 at 11:33 -0500, Adam Dear wrote:
Let me ask this question. Is there any other option for moving data
from one server to another that doesn't involve pg_dump? If I ca
the table structure, I just need the most current data to put into the
server.
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
If I restored the data directory again wouldn't that undo the Vacuum
Freeze command that I did that has locked the database into the state
that it i
. I restored a backup copy of the data directory I had made
yesterday morning before I started messing with it.
If I restored the data directory again wouldn't that undo the Vacuum
Freeze command that I did that has locked the database into the state
that it is in now?
Tom Lane wrote
@[EMAIL PROTECTED]@
[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
madisoncounty=# select ctid,xmin,xmax,cmin,cmax,usename from pg_shadow;
ctid | xmin | xmax | cmin | cmax |usename
---+--+-
|0 | madisoncounty
(3 rows)
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
The record is still there.
Hmph. Could we see all the system columns from that table?
select ctid,xmin,xmax,cmin,cmax,usename from pg_shadow;
regards, tom lane
--
Se
I tried:
Vacuum Freeze pg_shadow;
Then
Reindex database madisoncounty;
Then
Delete from pg_shadow where ctid='(0,1)';
The record is still there.
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
I tried:
Delete from pg_shadow where ctid = '(0,1)';
DELETE 0
e the same sysid. I tried to delete the one without
the password, I couldn't get it deleted.
I tried:
Delete from pg_shadow where ctid = '(0,1)';
DELETE 0
and
Delete from pg_shadow where passwd = '';
DELETE 0
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> write
er in there. Also, I tried starting
the db using /etc/init.d/postgres start, and it fails. Is that the
proper way to get the service going, or should I be doing something else?
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
I ran the select as instructed, and this is the output:
have been connecting to the db as the postgres user. Now I am
unable to connect to the database with the postgres user, or with the
actual user for the site.
Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
pg_dump: query to obtain list of schemas failed: ERROR: more than one
r
The pg_dump command is from version 7.4.11. This is the version of
postgres I am running on my old server.
Craig Ringer wrote:
Adam Dear wrote:
pg_dump: query to obtain list of schemas failed: ERROR: more than one
row returned by a subquery used as an expression
Is the pg_dump command
I am migrating to a new server. I am trying to get a dump of my
database to import into postgres 8.1.11 on my new server. When I run
the pg_dump commmand:
pg_dump --clean --file=madison.sql --schema=public -U madisoncounty
madisoncounty
I get this message:
pg_dump: query to obtain list of
11 matches
Mail list logo
